How to run rda on cluster
To setup rda collection at cluster
– Download rda from metalink Note:314422.1
– Verify the RAC node status (e.g. by using either olsnodes or lsnodes.) Nodes should be available for collection
– Ensure remote connectivity using SSH/SCP or RSH/RCP is available and works. Test remote connectively to each node that data collection is going to performed on. For example $ssh oracle@wgora01.oracledbasupport.co.uk env
-The data collection requires an initial setup to determine which information should be collected
$./<rda> -vX RDA::Remote setup_cluster [<db_user>]
<db_user> can be specified as argument to get the cluster nodes from the running database. Following user formats are supported:
user -To connect with that user in the database referenced by the ORACLE_SID environment variable.
[oracle@wygora01 rda]$ ./rda.sh -vX RDA::Remote setup_cluster oracle Enter ORACLE 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 (/u01/app/oracle/product/10.2.0/db_1/admin/wygprod/rda) > Where setup files and reports should be stored on the remote nodes? Hit 'Return' to accept the default (/u01/app/oracle/product/10.2.0/db_1/admin/wygprod/rda) > Should an alternate login be used to execute remote requests (Y/N)? Hit 'Return' to accept the default (N) > Enter ORACLE user password: Please re-enter it to confirm: ------------------------------------------------------------------------------ Requesting information for node wygora01 ------------------------------------------------------------------------------ Enter the Oracle Home to be analyzed on the node wygora01 Hit 'Return' to accept the default (/u01/app/oracle/product/10.2.0/db_1) > Enter the Oracle SID to be analyzed on the node wygora01 Hit 'Return' to accept the default (wygprod1) > ------------------------------------------------------------------------------ Requesting information for node wygora02 ------------------------------------------------------------------------------ Enter the Oracle Home to be analyzed on the node wygora02 Hit 'Return' to accept the default (/u01/app/oracle/product/10.2.0/db_1) > Enter the Oracle SID to be analyzed on the node wygora02 > ------------------------------------------------------------------------------ RAC Setup Summary ------------------------------------------------------------------------------ Nodes: . NOD001 wygora01/wygprod1 . NOD002 wygora02/ 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 can contain alphanumerical characters only. 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 (/u01/app/oracle/product/10.2.0/db_1/admin/wygprod/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 (/u01/app/oracle/product/10.2.0/db_1) > Enter the domain name of this server Hit 'Return' to accept the default (wyg-asp.com) > ------------------------------------------------------------------------------- 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 ...
Locate number of RAC nodes for RDA [oracle@wygora01 rda]$ ./rda.sh -vX RDA::Remote list Nodes: . NOD001 wygora01/wygprod1 . NOD002 wygora02/ 2 nodes found
Start collecting stats
[oracle@wygora01 rda]$ ./rda.sh -v -e REMOTE_TRACE=1
Collecting diagnostic data ...
-------------------------------------------------------------------------------
RDA Data Collection Started 27-Mar-2008 14:45:31
-------------------------------------------------------------------------------
Processing Initialization module ...
Processing CFG module ...
Processing OCM module ...
Leave a Reply
You must be logged in to post a comment.
I was looking for a command line tool to process perfServlet XML output and stumbled across “wasstats”
wasstats – This is an example Jython script that parses a
PervServletApp XML document.
https://code.google.com/p/imakerobots/wiki/wasstats
[…] installed PervServletApp application to retrieve websphere performance matrix. The data returned is in XML format and I needed […]