RAC RDA Setup on AIX

Remote Diagnostic Agent (RDA) is a Oracle utility used to collect information on RAC configurations. It collects a wealth of information that would otherwise be tedious to collect manually. This includes operating system, network, hardware, database, cluster configuration and logs. This is useful for troubleshooting RAC issues such as node evictions. Once collected this information can then be uploaded to My Oracle Support (MOS) as part of a SR. It also complements Oracle Configuration Manager (OCM) which is used to proactively do health checks and help with the speedy resolution of SRs. RDA can be downloaded from MOS.
Unzip the RDA archive
oracle@gridora31[gridprd2]-/u02 >cd /mnt/orasource/AIX/utils
oracle@gridora31[gridprd2]-/mnt/orasource/AIX/utils >ls
RDA422.zip ocm-Production-AIX-ppc.zip swingbench230422.zip
cpumonitor02.91.zip orion_aix_ppc64.gz swingbench240688.zip
datagenerator040198.zip osw3b.tar traceanalyzer010100.zip
oracle@gridora31[gridprd2]-/mnt/orasource/AIX/utils >cp RDA422.zip /u02/
oracle@gridora31[gridprd2]-/mnt/orasource/AIX/utils >cd /u02
oracle@gridora31[gridprd2]-/u02 >ls
RDA422.zip datapump lost+found orion tmp
oracle@gridora31[gridprd2]-/u02 >unzip RDA422.zip
Verify the RAC nodes status using olsnodes
grid@gridora30[+ASM1]-/home/grid >olsnodes
gridora30
gridora31 
Ensure SSH/SCP connectivity as the RDA owner e.g. oracle from each server
oracle@gridora30[gridprd1]-/u02/rda >ssh gridora31 date
Thu Feb 24 12:45:07 CST 2011
oracle@gridora31[gridprd2]-/u02/rda >ssh gridora30 date
Thu Feb 24 12:47:54 CST 2011 
Perform initial setup to determine which information to collect.
oracle@gridora30[gridprd1]-/u02/rda >./rda.pl -vX RDA::Remote setup_cluster /
------------------------------------------------------------------------------
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 (/u02/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 (/u02/rda)
>
Do you want RDA to use an alternative login to execute remote requests (Y/N)?
Hit 'Return' to accept the default (N)
>
------------------------------------------------------------------------------
Requesting information for node gridora30
------------------------------------------------------------------------------
Enter the Oracle home to be analyzed on the node gridora30
Hit 'Return' to accept the default (/u01/oracle/11.2.0/dbhome_1)
>
------------------------------------------------------------------------------
Requesting information for node gridora31
------------------------------------------------------------------------------
Enter the Oracle home to be analyzed on the node gridora31
Hit 'Return' to accept the default (/u01/oracle/11.2.0/dbhome_1)
>
------------------------------------------------------------------------------
RAC Setup Summary
------------------------------------------------------------------------------
Nodes:
. NOD001 gridora30/gridprd1
. NOD002 gridora31/gridprd2
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 (/u02/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 performed as the 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/oracle/11.2.0/dbhome_1)
>
Enter the network domain name for this server
Hit 'Return' to accept the default (griddba.com)
>
-------------------------------------------------------------------------------
S010CFG: Collects Key Configuration Information
-------------------------------------------------------------------------------
-------------------------------------------------------------------------------
S090OCM: Set up the Configuration Manager Interface
-------------------------------------------------------------------------------
RDA benefits from Oracle Configuration Manager by improving its data
collection. Oracle Configuration Manager (OCM) collects the configuration
information and uploads it to the OCM Repository in connected mode. When OCM
is configured in disconnected mode, it adds the OCM payload to the RDA report
packages in future RDA runs.

Select the mode that you want to install Oracle Configuration Manager in
/u01/oracle/11.2.0/dbhome_1
C Connected Mode
D Disconnected Mode
Enter the letter corresponding to your choice
Hit 'Return' to accept the default (C)
>
Do you want to install OCM Database collection scripts (Y/N)?
Hit 'Return' to accept the default (Y)
>
Enter a SYSDBA user for installing the OCM Database collection scripts
Hit 'Return' to accept the default (sys)
>
Is /u01/oracle/11.2.0/dbhome_1 an Oracle E-Business Suite Database Oracle home
(Y/N)?
Hit 'Return' to accept the default (N)
>
-------------------------------------------------------------------------------
S919LOAD: Produces the External Collection Reports
-------------------------------------------------------------------------------
-------------------------------------------------------------------------------
S999END: Finalizes the Data Collection
-------------------------------------------------------------------------------
-------------------------------------------------------------------------------
S909RDSP: Produces the Remote Data Collection Reports
-------------------------------------------------------------------------------
Updating the setup file ... 
Review setup.cfg file to make any changes as necessary
oracle@gridora30[gridprd1]-/u02/rda >ls
Convert README_Windows.txt hcve rda.cmd
DISCLAIM.txt README_irda.txt irda.pl rda.com
IRDA README_upgrade.txt lNOD001_setup.cfg rda.pl
RDA ccr lNOD002_setup.cfg rda.sh
README_Unix.txt dfw modules setup.cfg
README_VMS.txt engine output
oracle@gridora30[gridprd1]-/u02/rda >vi setup.cfg 
Check Remote Nodes accessibility
oracle@gridora30[gridprd1]-/u02/rda >./rda.pl -vX RDA::Remote list
Nodes:
. NOD001 gridora30/gridprd1
. NOD002 gridora31/gridprd2
2 nodes found 
Start RDA collection on all nodes
./rda.pl -v -e REMOTE_TRACE=1 
The RDA reports are generated in the /output directory

oracle@gridora30[gridprd1]-/u02/rda/output >ls
JOB_RDA RDA_END_system.htm RDA_S909RDSP.txt
LCK_RDA RDA_END_system.txt RDA_S909RDSP_A.fil
RDA.RDA_gridora30.zip RDA_RDSP_overview.htm RDA_S999END.htm
RDA.log RDA_RDSP_overview.txt RDA_S999END.toc
RDA_CFG_S.fil RDA_RDSP_results.htm RDA_S999END.txt
RDA_CFG_homes.htm RDA_RDSP_results.txt RDA_S999END_A.fil
RDA_CFG_homes.txt RDA_S010CFG.htm RDA__blank.htm
RDA_CFG_oh_inv.htm RDA_S010CFG.toc RDA__index.htm
RDA_CFG_oh_inv.txt RDA_S010CFG.txt RDA__index.txt
RDA_END_files.htm RDA_S010CFG_A.fil RDA__start.htm
RDA_END_files.txt RDA_S090OCM_A.fil RDA_mrc.fil
RDA_END_report.htm RDA_S909RDSP.htm RDA_rda.css
RDA_END_report.txt RDA_S909RDSP.toc remote

The RDA.RDA_nodename.zip file can be uploaded to Oracle Support to assist with a SR.

Comments

Post a Comment

Popular posts from this blog

Setup a Wordpress site in 10 Minutes using Oracle Container Cloud Service

Image
Oracle Container Cloud Service Oracle Container Cloud Service lets you easily deploy applications based on docker images. If you don't have an existing application you can create one on docker. However, the easiest method to get a full application up and running is by deploying a stack. Oracle Container Cloud Service provides several example stacks that you can deploy, including web servers based on NGINX or Apache, MongoDB database, and Wordpress. You can find more examples on Oracle GitHub Site . Let's see just how easy it is to spin up a Wordpress site using the Oracle Container Cloud Service. Prerequisites: Access to Oracle Cloud Account Subscription to Oracle IaaS Service First, go to the Oracle Container Cloud Service console and launch a new service. In this example, I created a service with three containers. One manager and two worker nodes. Choose an appropriate "shape" for your compute instances. Note: Oracle uses the term "shape" to r...
Read more

Oracle Home Cloning: Tools and Techniques

One of the many necessary and frequent tasks that a database administrator performs before creating a database is installing the Oracle database binaries. These binaries form what is known as an Oracle Home (referenced by the ORACLE_HOME environment variable on Linux and UNIX environments). Unfortunately, this is also one of the most mundane and uninteresting tasks a DBA can perform. So like all good DBAs know, the best way to deal with such repetitive task is to automate it. Automating installations of Oracle database binaries enables us to reliably repeat the process to enable faster installation as well as provide identical copies of the software in multiple environments. Fortunately, Oracle allows us to clone the Oracle database binaries from one environment to another. Cloning your Oracle binaries from a source copy with all the necessary patches applied enables us to have gold images which can then be deployed to multiple environments. The procedure for cloning an Oracle home...
Read more

Using XFS on Oracle Linux

Install xfs packages on Oracle Linux 6.6 via Oracle Public Yum [root@matthew ~]# yum install xfsprogs Loaded plugins: refresh-packagekit Setting up Install Process public_ol6_UEKR3_latest | 1.2 kB 00:00 public_ol6_UEK_latest | 1.2 kB 00:00 public_ol6_UEK_latest/primary | 19 MB 00:02 public_ol6_UEK_latest 407/407 public_ol6_addons | 1.2 kB 00:00 public_ol6_addons/primary | 77 kB 00:00 public_ol6_addons 269/269 public_ol6_latest | 1.4 kB 00:00 public_ol6_latest/primary | 46 MB 00:05 public_ol6_latest 29302/29302 http://public-yum.oracle.com/beta/repo/OracleLinux/OL6/uek3/x86_64/repodata/repomd.xml: [Errno 14] PYCURL ERROR 22 - "The requested URL returned error: 404 Not Found" Trying other mirror. Resolving Dependencies --> Running transaction check ---> Package xfsprogs.x86_64 0:3.1.11-1.0.5.el6 will be installed --> Finished Dependency Resolution Dependencies Resolved ===================================================================================================...
Read more