データベースを含むシステム全般の情報収集が迅速にできるサポート・ツールです。
* 多種多様なパラメータ設定情報、統計情報などを、ひとつひとつ収集する必要がありません。
* 問題の調査時、情報取得についてお客様に細かく依頼する必要がなく、情報を即座に収集することができます。
* 各プラットフォームで共通に使用でき、コマンドの違いを意識することなく、共通の方法で情報取得ができます。
Oracleのサポートより依頼され、取得する場合が多いです。
サポートするOS：
IBM AIX
Intel Linux （RedHat and SuSE）
HP-UX （10.* and 11.*）
HP Tru64
Sequent Dynix/Ptx
Sun Solaris （2.6 - 2.10）
Windows XP Professional
Windows 2000 Workstation and Server
Windows 2003 Server
サポートするOracle製品：
Oracle RDBMS Server （Standard and Enterprise Editions）
Oracle RAC Cluster （Single Node Collection）
Oracle Application Server （iAS 1.0.2.x/9.0.x/10.1.2.x， HTTP Server）
Oracle Management Server and Intelligent Agent （Grid Server， Agent Server， DB Control）
OLAP Products （Express Server， Financial Analyzer， and Demand Planning Server）
Oracle Developer （Forms and Reports）
Oracle Collaboration Suites （Email Server and Internet Directo
主な機能：性能、インストール、アップグレード、移行及び内部エラーの診断・情報収集。
主に
・パフォーマンス問題
・インストール・設定問題
・ORA-600、ORA-7445、ORA-3113エラーが発生した場合
・アップグレード、移行及びリンク問題
の解決で利用する。
Metalinkから入手可能、詳細はMetalink Note 314422.1、187506.1を参照ください。
インストール：
注意：*nixバージョンはWindowsで解凍せず、FTPのバイナリモードで転送する
$ gunzip rda.tar.gz
$ tar xvf rda.tar
テスト：
$ ./rda.sh -c ＃エラーが表示されなければ良い
一般Oracleユーザで実行する。（SYSDBAでログイン可能）
はじめて実行の場合、初期情報収集が必要です。
setup.cfg, setup.bakなどの設定ファイルが生成されます。
$ ./rda.sh -S
-------------------------------------------------------------------------------
S010CFG: Collects Key Configuration Information
-------------------------------------------------------------------------------
-------------------------------------------------------------------------------
S999END: Finalizes the Data Collection
-------------------------------------------------------------------------------
-------------------------------------------------------------------------------
S000INI: Initializes the Data Collection
-------------------------------------------------------------------------------
The output file prefix is used to easily identify all files belonging to the
same data collection. It must start with a letter and may only contain
alphanumerical characters.
Enter the prefix for all the files generated
Hit 'Return' to accept the default (RDA):
Enter the directory used for all the files generated
Hit 'Return' to accept the default (output):
Do you want to keep report packages from previous runs (Y/N)?
Hit 'Return' to accept the default (N):
Enter the Oracle Home to be analyzed
Hit 'Return' to accept the default (/u01/oracle/app/oracle/product/10.2.0/db_1):
Enter the domain name of this server
Hit 'Return' to accept the default (CentOS53.test):
-------------------------------------------------------------------------------
S020SMPL: Controls Sampling
-------------------------------------------------------------------------------
-------------------------------------------------------------------------------
S100OS: Collects the Operating System Configuration
-------------------------------------------------------------------------------
-------------------------------------------------------------------------------
S105PROF: Collects the User Profile
-------------------------------------------------------------------------------
-------------------------------------------------------------------------------
S110PERF: Collects Performance Information
-------------------------------------------------------------------------------
-------------------------------------------------------------------------------
S120NET: Collects Network Information
-------------------------------------------------------------------------------
Should the network ping tests be performed (Y/N)?
Hit 'Return' to accept the default (N):
-------------------------------------------------------------------------------
S125GTW: Collects Transparent/Procedural Gateway Information
-------------------------------------------------------------------------------
Are Transparent/Procedural Gateways installed on this node (Y/N)?
Hit 'Return' to accept the default (N):
-------------------------------------------------------------------------------
S130INST: Collects the Oracle Installation Information
-------------------------------------------------------------------------------
-------------------------------------------------------------------------------
S200DB: Controls RDBMS Data Collection
-------------------------------------------------------------------------------
Is there a database on this node to be analyzed? (Y/N)
Hit 'Return' to accept the default (Y):
Enter the Oracle SID to be analyzed
Hit 'Return' to accept the default (ManualDB):
Is the INIT.ORA for the database to be analyzed located on this machine? (Y/N)
Hit 'Return' to accept the default (Y):
Enter the location of the INIT.ORA (including the directory and file name)
Hit 'Return' to accept the default (/u01/oracle/app/oracle/product/10.2.0/db_1/dbs/initManualDB.ora):
Warning: The specified file does not -yet- exists
Press 'Enter' to Continue
Enter an Oracle User ID (userid only) to view DBA_ and V$ tables
If RDA will be run under the Oracle software owner's ID, enter a '/' here,
and select Y at the SYSDBA prompt to avoid being prompted for the database
password at runtime.
Hit 'Return' to accept the default (system):
Is 'system' a sysdba user (will connect as sysdba) (Y/N)?
Hit 'Return' to accept the default (N):
-------------------------------------------------------------------------------
S201DBA: Collects RDBMS Information
-------------------------------------------------------------------------------
-------------------------------------------------------------------------------
S204LOG: Collects Database Trace and Log Files
-------------------------------------------------------------------------------
-------------------------------------------------------------------------------
S205BR: Collects Database Backup/Recovery Information
-------------------------------------------------------------------------------
Are the backup/recovery information to be gathered? (Y/N)
Hit 'Return' to accept the default (N):
-------------------------------------------------------------------------------
S210OLAP: Collects OLAP Information
-------------------------------------------------------------------------------
Is Oracle Express Server installed on this machine? (Y/N)
Hit 'Return' to accept the default (N):
-------------------------------------------------------------------------------
S220IA: Collects Intelligent Agent Information
-------------------------------------------------------------------------------
Is the Oracle Intelligent Agent in use on this node (Y/N)?
Hit 'Return' to accept the default (N):
-------------------------------------------------------------------------------
S240MAIL: Collects Email Server Information
-------------------------------------------------------------------------------
Is the Oracle E-mail Server in use on this node (Y/N)?
Hit 'Return' to accept the default (N):
-------------------------------------------------------------------------------
S260OMS: Collects OMS Information
-------------------------------------------------------------------------------
Is the Oracle OEM Management Server in use on this node (Y/N)?
Hit 'Return' to accept the default (N):
-------------------------------------------------------------------------------
S290DEV: Collects Forms/Reports Information
-------------------------------------------------------------------------------
Is Forms/Reports in use on this node (Y/N)?
Hit 'Return' to accept the default (N):
-------------------------------------------------------------------------------
S300IAS: Collects Web Server Information
-------------------------------------------------------------------------------
Are Oracle Web Application Server, Oracle iAS, Oracle 9iAS, or
Oracle AS 10g installed and should they be analyzed (Y/N)?
Hit 'Return' to accept the default (Y):
Enter the location of apache conf and log files
Hit 'Return' to accept the default (/home/oracle/iasprod/Apache/Apache):
Warning: The specified directory does not -yet- exists
Press 'Enter' to Continue
Enter the base url for the web server
Hit 'Return' to accept the default (http://sst:7777):
Enter the base url or DAD to connect to database
Hit 'Return' to accept the default (http://sst:7777/pls/DAD):
Should the complete DCM repository be analyzed (Y/N)?
Hit 'Return' to accept the default (N):
-------------------------------------------------------------------------------
S310J2EE: Collects J2EE Standalone Information
-------------------------------------------------------------------------------
Is the Oracle J2EE/OC4J standalone in use on this node (Y/N)?
Hit 'Return' to accept the default (N):
-------------------------------------------------------------------------------
S320IFS: Collects iFS (iFS, CMSDK, Files) Information
-------------------------------------------------------------------------------
Is Internet File System (iFS, CMSDK, Files) installed and should it
be analyzed (Y/N)?
Hit 'Return' to accept the default (N):
-------------------------------------------------------------------------------
S322ECM: Collects Enterprise Content Management Information
-------------------------------------------------------------------------------
Should Enterprise Content Management be analyzed (Y/N)?
Hit 'Return' to accept the default (N):
-------------------------------------------------------------------------------
S340OID: Collects Oracle Internet Directory Information
-------------------------------------------------------------------------------
Is Oracle Internet Directory in use on this node (Y/N)?
Hit 'Return' to accept the default (N):
-------------------------------------------------------------------------------
S350WEBC: Collects Web Cache Information
-------------------------------------------------------------------------------
Is Oracle Web Cache in use on this node (Y/N)?
Hit 'Return' to accept the default (N):
-------------------------------------------------------------------------------
S400RAC: Collects Cluster Information
-------------------------------------------------------------------------------
Is this being run on a clustered environment (Y/N)?
Hit 'Return' to accept the default (N):
-------------------------------------------------------------------------------
S401OCFS: Collects Oracle Cluster File System Information
-------------------------------------------------------------------------------
Is OCFS (Oracle Cluster File System) in use (Y/N)?
Hit 'Return' to accept the default (N):
-------------------------------------------------------------------------------
S410GRID: Collects Grid Information
-------------------------------------------------------------------------------
Is the Grid control for 10G installed on this node (Y/N)?
Hit 'Return' to accept the default (N):
-------------------------------------------------------------------------------
S420AGT: Collects Agent Server Information
-------------------------------------------------------------------------------
Is the Central Agent for 10G installed on this node (Y/N)?
Hit 'Return' to accept the default (N):
-------------------------------------------------------------------------------
S430DBC: Collects Database Control Server Information
-------------------------------------------------------------------------------
Is the Database Control for 10G installed on this node (Y/N)?
Hit 'Return' to accept the default (N):
-------------------------------------------------------------------------------
S800NPRF: Samples Performance Information (root not required)
-------------------------------------------------------------------------------
-------------------------------------------------------------------------------
S801RPRF: Samples Performance Information (root privileges required)
-------------------------------------------------------------------------------
-------------------------------------------------------------------------------
S898XSMP: Samples User Defined Data
-------------------------------------------------------------------------------
-------------------------------------------------------------------------------
S998XTRA: Collects User Defined Data
-------------------------------------------------------------------------------
At this point, it should be possible to collect the diagnostic information.
sqlplus should connect to the database with the userid specified during the
setup.
With the same command used so far, start the data collection:
./rda.pl [-v]
or
./rda.sh [-v]
The -v option is optional. It allows to see the collection progression.
Once it has completed, the results will be packaged for sending it to Oracle
Support Services, if this file was generated to assist in resolving a TAR.
Selective data collection is also possible. For more details, the command
usage can be displayed by specifying the -h option, or complete manual page
with the -M option.
起動コマンド：
$ ./rda.sh
（詳細を表示させたい場合：$ ./rda.sh -v）
-------------------------------------------------------------------------------
RDA Data Collection Started 29- 6月-2009 14時09分22秒
-------------------------------------------------------------------------------
Processing Initialization module ...
Enter the password for 'SYSTEM': SYSTEMのパスワードを入力する
Please re-enter it to confirm: パスワードを再入力する
Processing CFG module ...
Processing Sampling module ...
Processing OS module ...
Processing PROF module ...
Processing PERF module ...
Processing NET module ...
Processing networking information (network files, sql*net files)...
Listener checks may take a few minutes. please be patient...
Processing listener status, services and log for listener LISTENER
Processing Oracle installation module ...
Processing RDBMS module ...
Processing LOG module ...
Processing Web Server module ...
Processing Web Server (iAS 1.x) module ...
Processing HTTP Server ...
Processing End module ...
-------------------------------------------------------------------------------
RDA Data Collection Ended 29- 6月-2009 14時12分04秒
-------------------------------------------------------------------------------
You can view your report by:
- Copying the output directory to a web shared directory and go to:
http://machine:port/web_shared_directory/RDA__START.htm
or
- Trying your browser directly:
ftp://sst@sst.CentOS53.mito/rda/output/RDA__START.htm
If this file was generated to assist in resolving a Service Request,
please send output/RDA.RDA_sst.zip
to Oracle Support by uploading the file via Metalink.
If ftp'ing the file, please be sure to ftp in BINARY format.
情報収集後、rda/output/の下にレポートが生成され、
このままRDA__index.htmを開いても良いが、RDA.RDA_sst.zipファイルを取得しても良いです。
レポート内容：（RDA 4.1）
* Overview
* Report Settings
* System Information
* Database Information
* Operating System Setup
* CPUs
* Memory
* Disk Drives
* Kernel Tables and IPC
* Operating System Packages
* System/Kernel Settings
* System Error Log
* Linux Release Information
* Miscellaneous Linux Information
* Linux GNU Libc
* NLS Environment Information
* Java Version
* /etc/*conf Files
* Tracing Tools
* Links(Patches)(Docs)
* User Profile
* Environment Variables
* Ulimit
* Hidden Files in HOME
* Hidden Files of Interest
o .bashrc
* Profile Files of Interest
o profile
o .bash_profile
* Performance
* Overview
* Top SQL
* ADDM Report
* AWR Report
* Network
* Interface Configuration
* TCP/IP Settings
* UDP Settings
* Adapters Output
* SQL*Net Configuration
o sqlnet.ora
o tnsnames.ora
o listener.ora
* Heterogeneous Services Configuration
o inithsodbc.ora
* Listener Status and Services
o LISTENER
* Network Environment
* Network Performance
* Key /etc Files
* Oracle Installation
* Oratab
* Oracle Home Files
* Oracle Installer
o oraInst.loc File
o Inventory Log Directory
o Log File Contents
o Error File Contents
o Out File Contents
o Last Make Log
* Detailed Inventory Report
* RDBMS
* Product Versions
* INIT.ORA
* Database Parameters
* Database SPFile Parameters
* Database Options
* Database Registry
* SGA Information
* Sessions and Processes
* V$License Information
* V$Compatibility Information
* NLS Information
* Feature Usage Statistics
* Feature Information
* HighWaterMark Statistics
* Control File Information
* Log Information
* Undo Information
* Database Properties
* V$System_Event
* V$Resource_Limit
* V$Session_Wait
* Latch Information
* Tablespaces
* Database Files
* Replication Information
* DBA Jobs Information
* Auditing and Password Information
* Invalid Objects
* Security Related Directory Listings and File Contents
* Spatial Information
* Advanced Queueing Information
* Partitioned Object Data
* CTXSYS Information
* RDBMS Log/Trace Files
* Alert.log
* Last Errors
o /u01/oracle/app/admin/new/bdump
+ manualdb_j000_11651.trc
+ manualdb_j000_11813.trc
+ manualdb_j000_17808.trc
+ manualdb_j000_20661.trc
+ manualdb_j000_23958.trc
+ manualdb_j000_26336.trc
+ manualdb_j000_29441.trc
+ manualdb_j000_29505.trc
+ manualdb_j000_2976.trc
+ manualdb_j000_5467.trc
+ manualdb_j000_5978.trc
+ manualdb_j000_9237.trc
+ manualdb_j001_11656.trc
+ manualdb_j001_11815.trc
+ manualdb_j001_17814.trc
+ manualdb_j001_20670.trc
+ manualdb_j001_23963.trc
+ manualdb_j001_26341.trc
+ manualdb_j001_29450.trc
+ manualdb_j001_29511.trc
+ manualdb_j001_2978.trc
+ manualdb_j001_5470.trc
+ manualdb_j001_5985.trc
+ manualdb_j001_9241.trc
* Trace/Log Directory Listings
* Web Server (old)
* Web Environment
* Web Processes
* Apache Overview
* Main URL
* owa_util.print_cgi_env
* HTTP Server (new)
* Listener Configuration
* Listener Log Files
再度設定し、収集したい場合：
レポートを削除後、
$ ./rda.sh -Svf
$ ./rda.sh -v
