No question at this time
DBA Top 10
1 B. Vroman 12500
2 M. Cadot 12200
3 A. Kavsek 11000
4 M. Hidayathullah ... 5800
5 J. Schnackenberg 5600
6 T. Boles 5400
7 P. Wisse 3100
8 T. P 700
9 R. Wauben 500
9 H. Steijntjes 500
About
DBA-Village
Download PLATO
The free tool for auditing and tuning your database
Version 55 now available
Sep 02, 2016
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48147
Total active users1686
Act. users last 24h5
Act. users last hour0
Registered user hits last week154
Registered user hits last month1269
Go up

free tool to make database audit
Next thread: Database Vault implementation with SaaS application using trigger
Prev thread: NTPD AND CTSS ON RAC ENV ...

Message Score Author Date
Hello All, Could you please suggest me the best...... Rastislav Farar Feb 06, 2018, 10:27
Hi, please check below link. http://www.dba-...... Mirza Hidayathullah Baig Feb 06, 2018, 14:40
There is a little bit of a learning curve and it w...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Tim Boles Feb 09, 2018, 20:37
Tim, thank you for your response this is very help...... Rastislav Farar Feb 12, 2018, 12:43

Follow up by mail Click here


Subject: free tool to make database audit
Author: Rastislav Farar, Slovakia
Date: Feb 06, 2018, 10:27, 17 days ago
Os info: Linux
Message: Hello All,

Could you please suggest me the best way to make audit of some databases run on Linux server.
Those databases running in dev environment and I need to do some kind of database list with specific details (tbs,sga,db version, patch etc...)
could you please suggest me a tools for this ?

thank you
Rasto
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: free tool to make database audit
Author: Mirza Hidayathullah Baig, United Kingdom
Date: Feb 06, 2018, 14:40, 17 days ago
Message: Hi,

please check below link.

http://www.dba-village.com/village/dvp_plato_pub.main

Regards
Mirza
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: free tool to make database audit
Author: Tim Boles, United States
Date: Feb 09, 2018, 20:37, 14 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message: There is a little bit of a learning curve and it will take a little tweaking for it to produce the information you want but I find that Oracle's RDA does a really good job giving you any and all information you might want. I generally limit it to my database only but it can tell you information about SOOOO MANY different Oracle components / applications / software.

You can check out the different lists of components.
Remote Diagnostic Agent (RDA) - Content Modules Man Page (Doc ID 330760.1)

The ones I normally use are:
DB Controls Oracle RDBMS Data Collection
DBA Collects Oracle RDBMS Information
DBC Collects Database Control Information
DBM Collects Oracle RDBMS Memory Information
DBPGA Collects Oracle RDBMS Process Global Area Memory Information

They also provide different PROFILES that allow combine modules already.

Remote Diagnostic Agent (RDA) - Profile Manual Pages (Doc ID 391983.1)

Profile - DB11g
Profile DB11g - Oracle Database 11g problems
MODULES
The DB11g profile uses the following modules:
DB:DCdb Controls Oracle RDBMS Data Collection
DB:DCdba Collects Oracle RDBMS Information
DB:DCdbm Collects Oracle RDBMS Memory Information
DB:DCdnfs Collects Direct NFS Information
DB:DClog Collects Oracle Database Trace and Log Files
DB:DCsp Collects SQL*Plus/iSQL*Plus Information
EM:DCagt Collects Enterprise Manager Agent Information
EM:DCdbc Collects Database Control Information
EM:DCgrid Controls Grid Control Data Collection
OS:DCinst Collects the Oracle Installation Information
OS:DCnet Collects Network Information
OS:DConet Collects Oracle Net Information
OS:DCos Collects the Operating System Information
OS:DCperf Collects Performance Information
OS:DCprof Collects the User Profile

The getting start note for RDA is Remote Diagnostic Agent (RDA) - Getting Started (Doc ID 314422.1)

When I execute it I generally use the perl version with the command line.

./rda.pl -SNfCR DB DBA DBC DBM DBPGA

It creates nice htm pages that I can then review.

Regards
Tim

Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: free tool to make database audit
Author: Rastislav Farar, Slovakia
Date: Feb 12, 2018, 12:43, 11 days ago
Message: Tim, thank you for your response this is very helpful
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here