RDA 在RAC DB 上安裝設定和收集資訊方法

zhulch發表於2007-05-09
.....[@more@]

oracle user
1.ftp rda_4.7-070308.tar to 伺服器上共享(GPFS管理的)的一個目錄/testarch/RDA/
2.tar xvf rda_4.7-070308.tar

3.執行如下
./rda.sh -vX RDA::Remote setup_cluster system
[testdb1:oracle] /testarch/RDA/rda> ote setup_cluster system <
Enter SYSTEM user password:
Please re-enter it to confirm:
------------------------------------------------------------------------------
Requesting common information
------------------------------------------------------------------------------
Where RDA should be installed on the remote nodes?
Hit 'Return' to accept the default (/testarch/RDA/rda)
>

Where setup files and reports should be stored on the remote nodes?
Hit 'Return' to accept the default (/testarch/RDA/rda)
>

Should an alternate login be used to execute remote requests (Y/N)?
Should an alternate login be used to execute remote requests (Y/N)?
Hit 'Return' to accept the default (N)
>

The authenticity of host 'testsvr1 (10.96.14.203)' can't be established.
RSA key fingerprint is ab:a6:be:be:b1:2e:d5:27:ca:60:cb:28:42:39:85:a3.
Are you sure you want to continue connecting (yes/no)? yes
password:
------------------------------------------------------------------------------
Requesting information for node testsvr2
------------------------------------------------------------------------------
Enter the Oracle Home to be analyzed on the node testsvr2
Hit 'Return' to accept the default (/oracle/app/oracle/product/10.2.0)
>


------------------------------------------------------------------------------
Requesting information for node testsvr1
------------------------------------------------------------------------------
Enter the Oracle Home to be analyzed on the node testsvr1
Hit 'Return' to accept the default (/oracle/app/oracle/product/10.2.0)
>

------------------------------------------------------------------------------
RAC Setup Summary
------------------------------------------------------------------------------
Nodes:
. NOD001 testsvr2/testdb1
. NOD002 testsvr1/testdb2
2 nodes found
-------------------------------------------------------------------------------
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 (/testarch/RDA/rda/output)
>

Do you want to keep report packages from previous runs (Y/N)?
Hit 'Return' to accept the default (N)
>

Is a fresh collection done as default action (Y/N)?
Hit 'Return' to accept the default (Y)
>

Enter the Oracle Home to be used for data analysis
Hit 'Return' to accept the default (/oracle/app/oracle/product/10.2.0)
>

Enter the domain name of this server
>


Warning: No domain has been specified
Do you want to specify a new value (Y/N)?n

-------------------------------------------------------------------------------
S010CFG: Collects Key Configuration Information
-------------------------------------------------------------------------------
-------------------------------------------------------------------------------
S090OCM: Setting up Oracle Configuration Manager Interface
-------------------------------------------------------------------------------
-------------------------------------------------------------------------------
S919LOAD: Produces the External Collection Reports
-------------------------------------------------------------------------------
-------------------------------------------------------------------------------
S999END: Finalizes the Data Collection
-------------------------------------------------------------------------------
-------------------------------------------------------------------------------
S909RDSP: Produces the Remote Data Collection Reports
-------------------------------------------------------------------------------
Updating the setup file ...


4.資料收集(因為沒用SSH ,這樣只能收集一個節點的,需要到另外一個節點再做一次)
./rda.sh -v -e REMOTE_TRACE=1

testdb1:oracle] /testarch/RDA/rda> ./rda.sh -v -e REMOTE_TRACE=1
Collecting diagnostic data ...
-------------------------------------------------------------------------------
RDA Data Collection Started 09-May-2007 10:09:50
-------------------------------------------------------------------------------
Processing Initialization module ...
Processing CFG module ...
Processing OCM module ...
Processing REXE module ...
NOD001> Setting up ...
password: Processing RDSP module ...
Processing LOAD module ...
Processing End module ...
-------------------------------------------------------------------------------
RDA Data Collection Ended 09-May-2007 10:10:00
-------------------------------------------------------------------------------
Generating the reports ...
- RDA_CFG_homes.txt ...
- RDA_CFG_oh_inv.txt ...
- RDA_RDSP_overview.txt ...
- RDA_RDSP_results.txt ...
- RDA_END_report.txt ...
- RDA_END_system.txt ...
- Report index ...
Packaging the reports ...

You can review the reports by transferring the contents of the
/testarch/RDA/rda/output directory to a location where you have web-browser
access. Then, point your browser at this file to display the reports:
RDA__start.htm

Based on your server configuration, some possible alternative approaches are:
or
- If your client computer with a browser has FTP access to the server
computer with the /testarch/RDA/rda/output directory, visit this URL:

m

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

Updating the setup file ...
[testdb1:oracle] /testarch/RDA/rda>
password:
password:


./rda.sh -vX RDA::Remote retry NOD002
[testdb1:oracle] /testarch/RDA/rda> ./rda.sh -vX RDA::Remote retry testsvr1
Updating the setup file ...


/testarch/RDA/rda/output/remote/ 下的ZIP 檔案FTP 過來,在自己機器上解壓
C:Documents and Settingsnaonao桌面RDA_NOD001RDA__start.htm 開啟這個HTM 檔案就可以了。
DB 的所有資訊都在裡面了

其他命令

./rda.sh -v -X RDA::Remote restart testsvr1

./rda.sh -vX RDA::Remote list

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/7318139/viewspace-914171/,如需轉載,請註明出處,否則將追究法律責任。

相關文章