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 laterInformation 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
<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.
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;
- the ORACLE_HOME directory location,
- 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 |