rda安装

OS:red hat 6.5
数据库：11.2.0.1 64bit
1、下载：http://www.blogJava.net/Files/beauty_beast/rda.rar
2、解压：gunzip rda_4[1].1-051205.tar.gz
        tar -zxf rda_4[1].1-051205.tar
3、改用户和组，赋权限：
chown -R oracle:oinstall /rda
chmod -R 777 rda/
4、第1次使用初始化
[oracle@oracle2 rda]$ ./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/app/oracle/product/11.2.4/dbhome_1):


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


-------------------------------------------------------------------------------
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):y^H


Enter the name of the node the script is running on
(used for ping tests)
Hit 'Return' to accept the default (oracle2):


Enter a remote node connecting to this Server
(used for ping tests)
Hit 'Return' to accept the default (wan_node):


Enter the node hosting the database instance
(used for ping tests)
Hit 'Return' to accept the default (oracle2):


Enter the node where the Web Server/Forms server is on
(used for ping tests)
Hit 'Return' to accept the default (web_node):


Enter a typical client node connecting to the database
(used for ping tests)
Hit 'Return' to accept the default (client_pc):


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


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/app/oracle/product/11.2.4/dbhome_1/dbs/initora11g.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):


-------------------------------------------------------------------------------
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://oracle2:7777):


Enter the base url or DAD to connect to database
Hit 'Return' to accept the default (http://oracle2: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.

5、采集数据
[oracle@oracle2 rda]$ ./rda.sh 
-------------------------------------------------------------------------------
RDA Data Collection Started 17-Jan-2017 11:44:14 AM
-------------------------------------------------------------------------------
Processing Initialization module ...
Enter the password for 'SYSTEM': 
Please re-enter it to confirm:
ORA-28002: the password will expire within 7 days
 The database to be analyzed (ora11g) does not appear to be
 accessible.


 Please do one of the following:


    -  If the database is not started, start it in another session, then
       press 'Enter' to continue this script after the database has been
       started;
    -  Interrupt this script, start the database or solve the connection
       problem, and next re-run rda; or
    -  Hit 'Enter' to continue this script without gathering information
       from the database.


 If you choose to continue without database connection, some information
 will be missing and Oracle Support may request that rda be re-run.


Press 'Enter' to Continue
RDA-00501: Database access disabled due to a connection problem
ORA-28002: the password will expire within 7 days
Processing CFG module ...
Processing Sampling module ...
Processing OS module ...
Processing PROF module ...
Processing PERF module ...
Processing NET module ...
Processing networking information (pings, network files, sql*net files)...
Listener and network 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 17-Jan-2017 11:47:18 AM
-------------------------------------------------------------------------------


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://root@oracle2.com/rda/output/RDA__START.htm


If this file was generated to assist in resolving a Service Request,
please send output/RDA.RDA_oracle2.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 - 30 database request(s) not executed in CFG, DBA, LOG, IAS module(s)

6、访问数据
[oracle@oracle2 rda]$ ls
DISCLAIM.txt  output  rda.bat  rda.sh           README_Windows.txt  setup.cfg
modules       RDA     rda.pl   README_Unix.txt  setup.bak
[oracle@oracle2 rda]$ cd output/
下载 RDA.RDA_oracle2.zip 文件，解压缩，打开*_start.htm
就可以查看

上面采集数据时最后有如下提示：
RDA-00015: Warning - 30 database request(s) not executed in CFG, DBA, LOG, IAS module(s)
还没仔细研究！

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

转载于:http://blog.itpub.net/31414383/viewspace-2132551/