RDA 在RAC DB 上安裝設定和收集資訊方法
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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- rda收集資訊命令
- DB健康檢查使用RDA收集資料
- 【RAC】在ESX 上安裝asm 共享磁碟ASM
- RDA的安裝使用
- 在rhel和CentOS上安裝SQL Server的方法CentOSSQLServer
- ORACLE RDA 安裝及使用Oracle
- 在 RHEL、CentOS 和 Fedora 上安裝 Git 及設定 Git 賬號的技巧CentOSGit
- 在AIX上安裝配置Oracle10g RACAIOracle
- 在VMware 上安裝配置Oracle10g RACOracle
- 在WINDOWS上安裝ORACLE RAC的注意事項WindowsOracle
- ORACLE RAC的FLASHBACK後期安裝設定Oracle
- OGG在RAC上的初始化(上)-- 安裝配置篇
- DB2 V9.7在Linux上的安裝DB2Linux
- 上網本安裝Win7系統的設定方法Win7
- mysql在linux上cmake安裝方法(自己安裝版)MySqlLinux
- 在linux6.4上安裝11g racLinux
- 在sun t2000上安裝rac概要
- 設定nmon 每天自動收集效能資訊
- CoreOS 在 PC 上快速安裝方法指南
- rac日誌收集方法
- Oracle 12cR1 RAC 在VMware Workstation上安裝(下)—靜默安裝Oracle
- Openfiler+RAC的安裝之五--在RAC 節點上配置 iSCSI 卷
- 【DB2】在AIX 上安裝DB2 遇到空間不足的錯誤DB2AI
- CentOS5.4上安裝RACCentOS
- 在RedHat LInux5上安裝Oracle 10g dbRedhatLinuxOracle 10g
- 在oracle linux 5.6上安裝oracle 11g RACOracleLinux
- 在AIX上安裝配置Oracle10g RAC2AIOracle
- Oracle11gR2 RAC在Linux上的安裝OracleLinux
- Oracle 12cR1 RAC 在VMware Workstation上安裝(中)—圖形介面安裝Oracle
- 在CentOS 7.5上安裝和配置ProFTPDCentOSFTP
- 在Red Hat和Centos上安裝MongoDBCentOSMongoDB
- 在 Linux 上安裝和使用 DockerLinuxDocker
- 在AIX安裝DB2 8.2AIDB2
- 安裝ORACLE時在Linux上設定核心引數的含義OracleLinux
- [zt] Oracle10g 自動收集收集CBO統計資訊設定Oracle
- 如何在 Arch Linux 上安裝和設定 KDE 桌面環境?Linux
- 在 Linux x86 上安裝 Oracle RAC 10gLinuxOracle
- 在Ubuntu 8.04安裝設定snmpd筆記Ubuntu筆記