Remote Diagnostic Agent (RDA) 4 - RAC Cluster(example)

来源:互联网 发布:2016年中国进出口数据 编辑:程序博客网 时间:2024/05/20 03:37

    本文为Remote Diagnostic Agent (RDA) 4 在RAC上的一个使用实例,具体的可参考metalink文章[314422.1]、[359395.1]

[oracle@db2 ~]$ unzip p11812741_423_LINUX.zip

[oracle@db2 ~]$ cd rda/

[oracle@db2 rda]$ mkdir output

[oracle@db1 ~]$ unzip p11812741_423_LINUX.zip

[oracle@db1 ~]$ cd rda/

[oracle@db1 rda]$ mkdir output

[oracle@db1 rda]$ . rda.sh -vX RDA::Remote setup_cluster

dirname: invalid option -- b

Try `dirname --help' for more information.

------------------------------------------------------------------------------

Requesting common information

------------------------------------------------------------------------------

Enter the absolute path of the directory where RDA will be installed on the

remote nodes.

Hit 'Return' to accept the default (/home/oracle/rda)

>

Enter the absolute path of the directory where setup files and reports will be

stored on the remote nodes?

Hit 'Return' to accept the default (/home/oracle/rda)

>

Do you want RDA to use an alternative login to execute remote requests (Y/N)?

Hit 'Return' to accept the default (N)

>

Enter an Oracle User ID (user ID only) to view DBA_ and V$ tables. If RDA is

to be run under the user ID of the Oracle software owner, then enter a forward

slash (/) here, and enter Y at the SYSDBA prompt. This prevents a prompt for

the database password at collection time.

Hit 'Return' to accept the default (system)

> /

Is '/' a SYSDBA user (will connect as SYSDBA) (Y/N)?

Hit 'Return' to accept the default (N)

> Y

------------------------------------------------------------------------------

Requesting information for node db1

------------------------------------------------------------------------------

Enter the Oracle home to be analyzed on the node db1

Hit 'Return' to accept the default (/oracle/product/10.2.0/db_1)

>

Enter the Oracle SID to be analyzed on the node db1

Hit 'Return' to accept the default (db1)

>

------------------------------------------------------------------------------

Requesting information for node db2

------------------------------------------------------------------------------

Enter the Oracle home to be analyzed on the node db2

Hit 'Return' to accept the default (/oracle/product/10.2.0/db_1)

>

Enter the Oracle SID to be analyzed on the node db2

> db2

------------------------------------------------------------------------------

RAC Setup Summary

------------------------------------------------------------------------------

Nodes:

. NOD001  db1/db1

. NOD002  db2/db2

2 nodes found

-------------------------------------------------------------------------------

S000INI: Initializes the Data Collection

-------------------------------------------------------------------------------

RDA uses the output file prefix to identify all files belonging to the same

data collection. The prefix must start with a letter and must contain only

alphanumeric characters.

Enter the prefix to be used for all the generated files

Hit 'Return' to accept the default (RDA)

>

Enter the directory used for all the files to be generated

Hit 'Return' to accept the default (/home/oracle/rda/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 used for data analysis

Hit 'Return' to accept the default (/oracle/product/10.2.0/db_1)

>

Enter the network domain name for 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: Set up the 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 ...

[root@db1 ~]# su - oracle

[oracle@db1 ~]$ cd rda/

[oracle@db1 rda]$ . rda.sh -v -e REMOTE_TRACE=1

dirname: invalid option -- b

Try `dirname --help' for more information.

        Collecting diagnostic data ...

-------------------------------------------------------------------------------

RDA Data Collection Started 06-Apr-2011 14:45:40

-------------------------------------------------------------------------------

Processing Initialization module ...

Processing OCM module ...

Processing CFG module ...

Processing REXE module ...

NOD001>         Setting up ...

NOD002>         Setting up ...

NOD002>         Collecting diagnostic data ...

NOD002> -------------------------------------------------------------------------------

NOD002> RDA Data Collection Started 06-Apr-2011 14:42:09

NOD002> -------------------------------------------------------------------------------

NOD002> Processing Initialization module ...

NOD002> Processing OCM module ...

NOD002> Processing PERF module ...

NOD002> Processing CFG module ...

NOD001>         Collecting diagnostic data ...

NOD001> -------------------------------------------------------------------------------

NOD001> RDA Data Collection Started 06-Apr-2011 14:45:53

NOD001> -------------------------------------------------------------------------------

NOD001> Processing Initialization module ...

NOD001> Processing OCM module ...

NOD002> Processing Sampling module ...

NOD002> Processing OS module ...

NOD001> Processing PERF module ...

NOD001> Processing CFG module ...

NOD001> Processing Sampling module ...

NOD001> Processing OS module ...

NOD002> Processing PROF module ...

NOD002> Processing NET module ...

NOD002> Processing ONET module ...

NOD002> Listener checks may take a few minutes. please be patient...

NOD001> Processing PROF module ...

NOD001> Processing NET module ...

NOD001> Processing ONET module ...

NOD001> Listener checks may take a few minutes. please be patient...

NOD002>   Processing listener LISTENER_db2

NOD002> Processing Oracle installation module ...

NOD002> Processing RDBMS module ...

NOD001>   Processing listener LISTENER_db1

NOD001> Processing Oracle installation module ...

NOD001> Processing RDBMS module ...

NOD001> Processing RDBMS Memory module ...

NOD002> Processing RDBMS Memory module ...

NOD002> Processing LOG module ...

NOD002> Processing Cluster module ...

NOD001> Processing LOG module ...

NOD001> Processing Cluster module ...

NOD002> Processing RDSP module ...

NOD002> Processing LOAD module ...

NOD002> Processing End module ...

NOD002> -------------------------------------------------------------------------------

NOD002> RDA Data Collection Ended 06-Apr-2011 14:43:37

NOD002> -------------------------------------------------------------------------------

NOD002>         Generating the reports ...

NOD002>                 - RDA_OS_sysdef.txt ...

NOD002>                 ```

NOD002>                 ```

NOD002>                 - RDA_DBM_lchitrat.txt ...

NOD002>                 - Report index ...

NOD002>         Packaging the reports ...

NOD002>                 RDA_NOD002.zip created for transfer

NOD002>         Updating the setup file ...

NOD001> Processing RDSP module ...

NOD001> Processing LOAD module ...

NOD001> Processing End module ...

NOD001> -------------------------------------------------------------------------------

NOD001> RDA Data Collection Ended 06-Apr-2011 14:47:38

NOD001> -------------------------------------------------------------------------------

NOD001>         Generating the reports ...

NOD001>                 - RDA_RAC_cluvfy.txt ...

NOD001>                 ```

NOD001>                 ```

NOD001>                 - RDA_OS_cpu_info.txt ...

NOD001>                 - Report index ...

NOD001>         Packaging the reports ...

NOD001>                 RDA_NOD001.zip created for transfer

NOD001>         Updating the setup file ...

Processing RDSP module ...

Processing LOAD module ...

Processing End module ...

-------------------------------------------------------------------------------

RDA Data Collection Ended 06-Apr-2011 14:47:47

-------------------------------------------------------------------------------

        Generating the reports ...

                - RDA_END_files.txt ...

                - RDA_END_report.txt ...

                - RDA_RDSP_results.txt ...

                - RDA_CFG_homes.txt ...

                - RDA_RDSP_overview.txt ...

                - RDA_CFG_oh_inv.txt ...

                - RDA_END_system.txt ...

                - Report index ...

        Packaging the reports ...

 You can review the reports by transferring the contents of the

 /home/oracle/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:

 - If your client computer with a browser has access to a web shared

   directory, copy the /home/oracle/rda/output directory to the web shared

   directory and visit this URL:

    http://machine:port/web_shared_directory/RDA__start.htm

   or

 - If your client computer with a browser has FTP access to the server

   computer with the /home/oracle/rda/output directory, visit this URL:

    ftp://root@db1/rda/output/RDA__start.htm

 If this file was generated to assist in resolving a Service Request, please

 send /home/oracle/rda/output/RDA.RDA_db1.zip to Oracle Support by uploading

 the file via My Oracle Support. If ftp'ing the file, please be sure to ftp in

 BINARY format.

        Updating the setup file ...