How to run rda on cluster

Posted By Sagar Patil

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.

2 Responses to “ Websphere: Using PerformanceMonitor Servlet to Monitor Performance Metric ”

  1. 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

  2. […] installed PervServletApp application to retrieve websphere performance matrix.  The data returned is in XML format and I needed […]

Top of Page

Top menu