My Oracle Support Banner

Implementing RDA for Oracle GoldenGate Data collection (Doc ID 1362838.1)

Last updated on FEBRUARY 23, 2022

Applies to:

Oracle GoldenGate - Version 11.1.1.0.0 and later
Information in this document applies to any platform.

Details

GoldenGate is now a supported module in the Oracle database Remote Diagnostic Agent (RDA).

The RDA collects data to be returned to Oracle to assist in the resolution of SR's.
When data is collected via the RDA and uploaded to Oracle,  most of the information required by Oracle is automatically provided.
The RDA can be downloaded in only a couple minutes, and may be accessed from:

<Note 314422.1> - Remote Diagnostic Agent (RDA) - Getting Started

 and downloaded via the supplied "Download RDA" link.

Installation varies slightly from platform to platform, but should be fast on all platforms.
Data collection takes about 1 minute, where the collected file is should be around 1Mb in size.

Scope and Application

This document is intended for Oracle GoldenGate users.

It is limited to basic usage of RDA to gather OGG diagnostic information only.

The actual RDA Note 314422.1 Remote Diagnostics Agent - Overview and User Guide
supersedes this document in both details and usage.

Actions

Before you start...

Before starting the RDA,  be prepared to answer the following questions;
  1. the ORACLE_HOME directory location,
  2. the GoldenGate installation directory location.
Also, please make sure that the GoldenGate MANAGER process is running.

Installation on the MS-Windows platform

Copy the downloaded file to a new folder such as c:\rda on Windows.
Start a command prompt and go to c:\rda
Run rda.sh -S OGG
c:\rda rda.sh -S OGG
This will install the code. It is quick and easy.  It will require you to enter some defaults. Accept them.
You will need to enter the location of your OGG install directory, such as
C:\GG\Teradata.
RDA will create a sub-folder called rda so you now have c:\rda\rda.
Create a data collection by executing c:\rda\rda rda.cmd
This may create a popup error. Ignore it. It does not affect the collection.
Collection time is around a minute.
Go to c:\rda\rda\output. There is a file called RDA.<your_computer_name>.zip.
The output file will be around 1 meg of data or more depending on your environment.
This is the file that can be attached to the SR for the support analyst to examine.
The collected report information can be viewed locally by opening the file c:\rda\rda\output\rda_start.htm.
The data may be re-collected for future incidents by again running c:\rda\rda rda.cmd.
Total download and install time: under 5 minutes
Total data data collection time: about 1 minute
Total time saved as compared to incrementally gathering data for support: priceless.

Installation on UNIX platforms

1) Download the appropriate module to an RDA directory and unzip it.
:/RDA> unzip *.zip
Here it is downloaded and unzipped on a Sun box:
:/RDA> ls
p12942951_425_SOLARIS64.zip rda readme.txt
2) Change to the created rda directory:
:/RDA cd rda
:/RDA/rda> ls
ccr                 hcve                rda.cmd             README_Unix.txt
Convert             IRDA                rda.com             README_upgrade.txt
dfw                 irda.pl             rda.pl              README_VMS.txt
DISCLAIM.txt        modules             rda.sh              README_Windows.txt
engine              RDA                 README_irda.txt
3) Verify the install:
:/RDA/rda> ./rda.sh -cv
Loading the file list ...
Checking the directory '.' ...
Checking the directory 'IRDA' ...
Checking the directory 'IRDA/CV0100' ...
Checking the directory 'RDA' ...
Checking the directory 'RDA/Archive' ...
Checking the directory 'RDA/Handle' ...
Checking the directory 'RDA/Library' ...
Checking the directory 'RDA/Library/Remote' ...
Checking the directory 'RDA/Local' ...
Checking the directory 'RDA/Object' ...
Checking the directory 'RDA/Operator' ...
Checking the directory 'RDA/Value' ...
Checking the directory 'RDA/Web' ...
Checking the directory 'dfw/cv0100' ...
Checking the directory 'engine' ...
Checking the directory 'hcve' ...
Checking the directory 'modules' ...
No issues found
4) Setup Collection Parameters for OGG only
For this example, the OGG install directory is /home/ora104:
Use defaults. 
Don't bother with the Oracle install info.
Directory is at /home/ora104.
:/home/RDA/rda> ./rda.sh -S OGG
-------------------------------------------------------------------------------
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 (/RDA/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
>
Warning: The specified directory does not -yet- exist
Do you want to specify a new value (Y/N)?n
Enter the network domain name for this server
Hit 'Return' to accept the default (oracle.com)
>
-------------------------------------------------------------------------------
S010CFG: Collects Key Configuration Information
-------------------------------------------------------------------------------
-------------------------------------------------------------------------------
S090OCM: Set up the Configuration Manager Interface
-------------------------------------------------------------------------------
-------------------------------------------------------------------------------
S909RDSP: Produces the Remote Data Collection Reports
-------------------------------------------------------------------------------
-------------------------------------------------------------------------------
S919LOAD: Produces the External Collection Reports
-------------------------------------------------------------------------------
-------------------------------------------------------------------------------
S999END: Finalizes the Data Collection
-------------------------------------------------------------------------------
-------------------------------------------------------------------------------
S394OGG: Collects Oracle GoldenGate Information
-------------------------------------------------------------------------------
Do you want RDA to analyze Oracle GoldenGate (Y/N)?
Hit 'Return' to accept the default (N)
> y

Specify the Oracle GoldenGate installation directory
> /home/ora104
-------------------------------------------------------------------------------
S990FLTR: Controls Report Content Filtering
-------------------------------------------------------------------------------
:/RDA/rda>
5) Execute RDA collection capture:
:/RDA/rda> ./rda.sh -v
        Collecting diagnostic data ...
-------------------------------------------------------------------------------
RDA Data Collection Started 03-Oct-2011 07:58:16
-------------------------------------------------------------------------------
Processing Initialization module ...
Processing OCM module ...
Processing CFG module ...
Processing OGG module ...
Processing RDSP module ...
Processing LOAD module ...
Processing End module ...
-------------------------------------------------------------------------------
RDA Data Collection Ended 03-Oct-2011 07:58:53
-------------------------------------------------------------------------------
        Generating the reports ...
                - RDA_CFG_homes.txt ...
                - RDA_OGG_dirdat.txt ...
                - RDA_OGG_R00006_R2801_cpr.dat ...
                - RDA_OGG_dirchk.txt ...
                - RDA_OGG_R00009_MGR_pcm.dat ...
                - RDA_OGG_dirpcs.txt ...
                - RDA_OGG_R00011_mgr_prm.dat ...
                - RDA_OGG_dirprm.txt ...
                - RDA_OGG_R00012_r2801_prm.dat ...
                - RDA_OGG_R00014_MGR_rpt.dat ...
                - RDA_OGG_dirrpt.txt ...
                - RDA_OGG_R00015_MGR0_rpt.dat ...
                - RDA_OGG_R00016_R2801_rpt.dat ...
                - RDA_OGG_R00017_R28010_rpt.dat ...
                - RDA_OGG_R00018_dirrpt_tar.dat ...
                - RDA_OGG_serproc.txt ...
                - RDA_OGG_ggserr.txt ...
                - RDA_END_system.txt ...
                - RDA_END_files.txt ...
                - RDA_END_report.txt ...
                - Report index ...
        Packaging the reports ...
 You can review the reports by transferring the contents of the
 /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:
 - If your client computer with a browser has access to a web shared
   directory, copy the /RDA/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 /RDA/rda/output directory, visit this
   URL:
    ftp://support@server.oracle.com/RDA/rda/output/RDA__start.htm

 If this file was generated to assist in resolving a Service Request, please
 send /RDA/rda/output/RDA.RDA_support.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.
 Please note: Do not submit any health, payment card or other sensitive
 production data that requires protections greater than those specified in the
 Oracle GCS Security Practices
 (http://www.oracle.com/us/support/library/customer-support-security-practices-069170.pdf).
 Information on how to remove data from your submission is available at
 https://support.oracle.com/oip/faces/secure/km/DocumentDisplay.jspx?id=1227943.1
        Updating the setup file ...
6) Review the results:
:/RDA/rda> cd output
:/RDA/rda/output> ls
extern                         RDA_OGG_R00014_MGR_rpt.dat
JOB_RDA                        RDA_OGG_R00014_MGR_rpt.htm
RDA__blank.htm                 RDA_OGG_R00015_MGR0_rpt.dat
RDA_CFG_homes.htm              RDA_OGG_R00015_MGR0_rpt.htm
RDA_CFG_homes.txt              RDA_OGG_R00016_R2801_rpt.dat
RDA_CFG_S.fil                  RDA_OGG_R00016_R2801_rpt.htm
RDA_END_files.htm              RDA_OGG_R00017_R28010_rpt.dat
RDA_END_files.txt              RDA_OGG_R00017_R28010_rpt.htm
RDA_END_report.htm             RDA_OGG_R00018_dirrpt_tar.dat
RDA_END_report.txt             RDA_OGG_R00018_dirrpt_tar.htm
RDA_END_system.htm             RDA_OGG_serproc.htm
RDA_END_system.txt             RDA_OGG_serproc.txt
RDA__index.htm                 RDA_rda.css
RDA__index.txt                 RDA.RDA_mugato.zip
RDA.log                        RDA_S010CFG_A.fil
RDA_mrc.fil                    RDA_S010CFG.htm
RDA_OGG_dirchk.htm             RDA_S010CFG.toc
RDA_OGG_dirchk.txt             RDA_S010CFG.txt
RDA_OGG_dirdat.htm             RDA_S090OCM_A.fil
RDA_OGG_dirdat.txt             RDA_S394OGG_A.fil
RDA_OGG_dirpcs.htm             RDA_S394OGG_D.fil
RDA_OGG_dirpcs.txt             RDA_S394OGG.htm
RDA_OGG_dirprm.htm             RDA_S394OGG_I.fil
RDA_OGG_dirprm.txt             RDA_S394OGG.toc
RDA_OGG_dirrpt.htm             RDA_S394OGG.txt
RDA_OGG_dirrpt.txt             RDA_S919LOAD_A.fil
RDA_OGG_ggserr.htm             RDA_S919LOAD.htm
RDA_OGG_ggserr.txt             RDA_S919LOAD.toc
RDA_OGG_R00006_R2801_cpr.dat   RDA_S919LOAD.txt
RDA_OGG_R00006_R2801_cpr.htm   RDA_S999END_A.fil
RDA_OGG_R00009_MGR_pcm.dat     RDA_S999END.htm
RDA_OGG_R00009_MGR_pcm.htm     RDA_S999END.toc
RDA_OGG_R00011_mgr_prm.dat     RDA_S999END.txt
RDA_OGG_R00011_mgr_prm.htm     RDA__start.htm
RDA_OGG_R00012_r2801_prm.dat   TMP_RDA
RDA_OGG_R00012_r2801_prm.htm
:/RDA/rda/output>
The output zip file is: RDA.RDA_oracle.zip. This is to be attached to the SR.

7) Upload the zip file to the SR.
KEYWORDS: ABEND, LAG, CHECKPOINT, HUNG, SLOW, PERFORMANCE, STOPPED, REPLICAT, OGG, RDA

Contacts

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Details
 Scope and Application
Actions
 Before you start...
 Installation on the MS-Windows platform
 Installation on UNIX platforms
Contacts
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.