The following is database extra tip #1 from "30 tips in 30 minutes," brought to you by the IOUG. Return to the
main page for more tips on this topic.
When you set up a tar with Oracle, it gets tiresome supplying the Oracle support person with all your database version information. It takes a long time just to get the question or problem you have.
On your next support call, go to metalink.oracle.com and search for RDA. Choose the Remote Diagnostic Agent (RDA) entry. You'll find a set of Unix shell scripts to gather detailed information from an Oracle environment. The scripts are focused to collect information that will aid in problem diagnosis. However the output is also very useful to see the overall system configuration. Download the tar archive file and you'll be impressed by all the database environment information collected. Send this information back to Oracle or use it yourself for your own diagnosis.
The scripts are tested on the following Unix platforms:
- Sun Solaris (2.5 - 8)
- HP-UX (10.X and 11.X)
- Compaq Unix (OSF1) 4.0
Get more tips in minutes! Return to the main page.
About the author: Kenny Smith has been working with Oracle technology on HP servers for over a decade. He specializes in Oracle database architecture, database administration and development. He has presented at numerous Oracle conferences on two continents. He has published many articles describing Oracle solutions and has co-authored "Oracle backup and recovery 101" from Oracle Press.
IOUG: Become a member of the IOUG to access the paper referenced here and a repository of technical content created for Oracle users by Oracle users.