oracle rda的使用

oracle 提供的rda是一个很好的了解数据库服务器的工具，尤其是当你到一个新的环境当中去了以后，先用rda来收集下，就能很快的了解数据库服务，数据库的各个情况，在metelink上做sr的时候，oracle官方也向我们要这个东西，可见rda的功能之强大，附件为rda的时候和传上一个rda工具。大家学习下

我的是rac环境下做的rda，不知道上传附件（软件就没法上传了，需要的单独联系）就只有贴出来了

$ ./rda.sh -S  ==创建一个rda的配置文件setup.cfg，如果已经有了的就把以前的删除，在新的环境中重新配置一个配置文件==
-------------------------------------------------------------------------------
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):ora10g1   

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 (/data/oracle/product/10g):

Enter the domain name of this server
Hit 'Return' to accept the default ():

Warning: No domain has been specified
Press 'Enter' to Continue

-------------------------------------------------------------------------------
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 (ora10g1):

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 (/data/oracle/product/10g/dbs/initora10g1.ora):

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):Y

-------------------------------------------------------------------------------
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):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):Y

Are you experiencing an instance hang or slowness (Y/N)?
Hit 'Return' to accept the default (N):Y

-------------------------------------------------------------------------------
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.

$ ll
total 288
-r--r--r--   1 oracle     dba           4087 Mar 29  2005 DISCLAIM.txt
drwxr-xr-x   4 oracle     dba           8192 Dec  3  2005 RDA
-r--r--r--   1 oracle     dba          12662 Nov 24  2005 README_Unix.txt
-r--r--r--   1 oracle     dba          12546 Nov 24  2005 README_Windows.txt
drwxr-xr-x   2 oracle     dba           8192 Dec  5  2005 modules
drwxr-xr-x   2 oracle     dba             96 May 14 15:45 output
-r-xr-xr-x   1 oracle     dba           2918 Nov  8  2005 rda.bat
-r-xr-xr-x   1 oracle     dba          26891 Dec  5  2005 rda.pl
-r-xr-xr-x   1 oracle     dba           3017 Nov 23  2005 rda.sh
-rw-r--r--   1 oracle     dba          20105 May 14 15:45 setup.bak
-rw-r--r--   1 oracle     dba          16215 May 14 16:03 setup.cfg
$ ./rda.sh
-------------------------------------------------------------------------------
RDA Data Collection Started 14-May-2010 16:03:48
-------------------------------------------------------------------------------
Processing Initialization module ...
Enter the password for 'SYSTEM as sysdba':
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_RX8640A
  Processing of LISTENER_RX8640A log file can take some time
Processing Oracle installation module ...
Processing RDBMS module ...
Processing LOG module ...
Processing Cluster module ...
Processing End module ...
-------------------------------------------------------------------------------
RDA Data Collection Ended 14-May-2010 16:10:52
-------------------------------------------------------------------------------

You can view your report by:
- Copying the output directory to a web shared directory and go to:
   http://machine:port/web_shared_directory/ora10g1__START.htm
  or
- Trying your browser directly:
   ftp://root@rx8640a./tmp/rda/output/ora10g1__START.htm

If this file was generated to assist in resolving a Service Request,
please send output/RDA.ora10g1_rx8640a.zip
to Oracle Support by uploading the file via Metalink.
If ftp'ing the file, please be sure to ftp in BINARY format.

RDA-00015: Warning - 2 database request(s) not executed in RAC module(s)

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/16719800/viewspace-662731/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/16719800/viewspace-662731/