Collection of important notes on the interaction of Oracle GoldenGate with the Oracle database
Posted on April 23, 2012 by Alex Lima
Note 1273285.1 How to troubleshoot Oracle Redo log reading
Note 1060533.1 How to trace transaction from trail back to redo log
Note 1060593.1 Analysis of empty supplemental log key values in trail for an Oracle update
Note 1268590.1 Checking for Oracle archive log corruption
Note 1273285.1 How do I troubleshoot Oracle Redo Log Reading Extract Slow Performance
Note 1127476.1 Redo Thread: error 13 (Permission denied) opening redo log
Note 1086154.1 Compatibility between OGG builds and Oracle database versions
Note 1054126.1 How do I change the version compatibility to 9.2 in an Oracle Database
Note 1060581.1 Why is the “select any table” privilege required for extract on an Oracle Partition table
Note 1267901.1 How to configure GoldenGate extract when adding or removing redo log threads in an Oracle RAC
Note 1269274.1 Why does GoldenGate require DBA/SYSDBA privileges in extract/replicat
Note 1112325.1 Deploying Oracle Goldengate to achieve operational reporting for Oracle E-Business Suite
Note 1112403.1 Deploying Oracle Goldengate to achieve operational reporting for Oracle Siebel CRM
Note 1112406.1 Deploying Oracle Goldengate to achieve operational reporting for Oracle JD Edwards
Note 1114746.1 Deploying Oracle GoldenGate to achieve operational reporting for PeopleSoft
Note 1276058.1 Oracle GoldenGate Best Practices: Instantiation form an Oracle Source Database
Note 1298562.1 Oracle GoldenGate data base complete database check script (all schemas)
Oracle GoldenGate Logdump Complete Reference FAQ (Doc ID 1446672.1)
Click to add to Favorites How to Stop the OGG Replicat at a Particular CSN Value (Doc ID 1368812.1)
Note 972950.1 Why do I receive the Error “ORA-12638 Credential Retrieval Failed”
Note 1059710.1 GoldenGate Extract/Replicat Error in Oracle-UNIX environment
Note 1195995.1 Implementing GoldenGate for DataGuard fail overs
Note 1269855.1 Oracle GoldenGate supports reading redo and archive log files stored on Raw devices with source database on AIX OS and also requires TRANLOFOPTIONS RAWDEVICEOFFSET parameter
Note 1280235.1 Oracle procedure failed with ORA-12801 and ORA-01031 only when OGG DDL trigger is enabled
Note 1280584.1 Where to find the list of supported and unsupported Oracle Data Types for GoldenGate
Note 1297398.1 GoldenGate – Error(904, ORA-00904:: Invalid identifier)selecting data in ORAUTIL_getCurrentSCN()
Note 972950.1 Why do I receive the Error “ORA-12638 Credential Retrieval Failed”
Note 1149823.1 Extract cannot read database redo (Oracle) or only (SQLServer) logs on Windows 2008 or Windows 7
Note 1206737.1 Extract generates a large colume of trail data for Lob updates on Oracle
Note 1296567.1 Why does extract fail with Error OGG-00665: ORA-22812
Note 1297398.1 GOldenGate – Erro r(904, ORA-00904:: Invalid identifier)selecting data in ORAUTIL_getCurrentSCN()
Note 972329.1 Why do I get the Error message “GG ErrorNote 1 18 Unknown Specifier in Archive log format”
Note 972946.1 Why does extract/replicat on OracleNote 1 0.2.0.3 fail with the “1008-ORA-01008: not all variables bound error message
Note 972950.1 Why do I receive the Error “ORA-12638 Credential Retrieval Failed”
Note 973586.1 Extraction of CLOB/LOB data, when do we do a DB fetch
Note 987379.1 How to recover from extract ERRORNote 1 80 encountered commit SCN that is not greater than the highest SCN already processed
Note 1059895.1 Extract processes running in an Oracle RAC on Linux environment
Note 1060553.1 Extract for Oracle abends with the Error “getting Last rollback item ROWID”
Note 1108953.1 What does this message mean? “Redo thread online log/oracle
Note 1125265.1 Extract abend with Error numcnv_getnumeric buffer overflow, chained row or others
Note 1186935.1 GGS Error 500 could not find archived log for sequence
Note 1192972.1 ALO extract hangs on restart an error 22 (invalid argument) occurs
Note 1206737.1 Extract generates a large column of trail data for Lob updates on Oracle
Note 1211806.1 OGG extract abends with” cm_obj_pop_last_item: object empty: error 116
Note 1242965.1 Reenabling a RAC thread got extract abend with “begin time prior to oldest log in log history
Note 1265785.1 Extract abended with ORA-01013 when processing DDL record
Note 1267048.1 Extract abends as a table is considered as compresses only when with DDL parameter
Note 1270168.1 OGG-01028 Compression not supported – when extract processes regular and cluster tables
Note 1273546.1 Oracle export hangs when OGG extract DDL trigger enabled
Note 1274300.1 Extract abended with Error “ORA-00942:table or view does not exist, SQL< select values$ from sys.props$ where name = ‘NLS_LANGUAGE’
Note 1285734.1 Why extract on RAC with DDL parameter, abended on a table that is not included in the parameter list
Note 1291330.1 DBLOGREADER extract fails with this versions of ORACLE does not support DBLOGREADER
Note 972962.1 How do I call an Oracle function within replicat
Note 1087305.1 How to specify which Oracle database to access from a GoldenGate replicat
Note 1116896.1 OGG replicat gets ORA-01873 for interval data on HP-UX
Note 1259884.1 ERROR OGG-01082 when running a replicat against an Oracle database
Note 972411.1 Can I minimize notification of long running transactions on Oracle
Note 1054126.1 How do I change the version compatibility to 9.2 in an Oracle Database
Note 1059352.1 How to turn on supplemental logging at the database or the table level
Note 1059362.1 How do I determine if supplemental logging is turned ON at the database or the table level
Note 1059583.1 When GoldenGate fetches data from the database on extraction for Oracle
Note 1060437.1 Why do I get the ora-00001 when doing multi-row PK/unique_key update by single statement in Oracle
Note 1060525.1 Does GolenGate support the DML statement merge
Note 1060533.1 How to trace transaction from trail back to redo log
Note 1060535.1 Using Oracle GoldenGate in an Oracle ASM environment when a non sys user
Note 1060568.1 GGS Error 118 OCI error creating temp LOB
Note 1060581.1 Why is the “select any table” privilege required for extract on an Oracle Partition table
Note 1060794.1 How to solve an Ora-02292 error in replicat for a self-referential FK when processing multi-row deletes
Note 1060870.1 ALTARCHIVELOGDEST
Note 1061093.1 Extract fails with Error 118 No valid Log File for current Redo sequence xxxx thread Y
Note 1063125.1 Error message ORA-20782: DDL operation Failed because Recyclebin is turned on
Note 1063389.1 How to turn-off Oracle Recycle bin
Note 1081322.1 Configuring Oracle GoldenGate for partitioned Replication
Note 1083886.1 Can I use the @RANGE Function to split data exactly by a column value
Note 1087214.1 OCI error ora-01830 in OGG replicat when using sqlexec to call a procedure
Note 1265554.1 OGG DDL support of ALTER TABLE move or DBMS_REDEFINITION
Note 1280235.1 Oracle procedure failed with ORA-12801 and ORA-01031 only when OGG DDL trigger is enabled
Note 1297811.1 Why do I see a message INFO 220 found Crash Recovery Marker from
===========================================================================================================================================================
See Individual products Notes for individual links:
Note 1304561.1 Master Note - Oracle GoldenGate - Upgrading OGG code
Note : 1235992.1 How to find Patches and Updates for Oracle GoldenGate
Note : 1293587.1 Searching the Patch site for a particular OGG release
Note : 970860.1 How To Apply Oracle GoldenGate Patches
Note: 1112325.1 Deploying Oracle GoldenGate to Achieve Operational Reporting for Oracle E-Business Suite
Note: 1112406.1 Deploying Oracle GoldenGate to Achieve Operational Reporting for Oracle JD Edwards
Note: 1114746.1 Deploying Oracle GoldenGate to Achieve Operational Reporting for PeopleSoft
Note: 1112403.1 Deploying Oracle GoldenGate to Achieve Operational Reporting for Oracle Siebel CRM
Compatibility
Note : 965423.1 Is GoldenGate Compatible Between Different Releases?
Note : 1086154.1 Compatibility between OGG builds and Oracle database Versions
Note : 1300936.1 NSK Specific Main Note
Note: 266043.1 Support of Linux and Oracle Products on Linux
Performance and Tuning (LAG):
Note 1304557.1 Main Note - Oracle GoldenGate - Lag, Performance, Slow and Hung Processes
Tracing:
Note 1304496.1 Main Note - Oracle GoldenGate - Tracing
Handlecollisions
Note 966207.1 What Does The HANDLECOLLISIONS Parameter Do
NLS_LANG
Note 969551.1 How is NLS_LANG Set When You Run OGG On The Superset Character Sets Database
Note 969651.1 ORA-12705: Invalid Or Unknown NLS Parameter Value Specified.
Supplemental Logging
"Supplemental logging at the table level and the database level must be enabled for the tables from the source database."
Note 1304503.1 Main Note - Oracle GoldenGate - Supplemental Logging
RAC
Note 1304593.1 Main Note - Oracle GoldenGate - RAC
ARCHIVE LOG Sequence
Note 1186935.1 GGS Error 500 Could Not Find Archived Log For Sequence
Note 1108953.1 What does this mean? Redo thread 1: Online log /oracle/..... on sequence# nnn has missing
Note 971825.1 Why Does Extract For Oracle Abend With Error "Mismatched Sequences In Archive Log"?
CheckPoint
Note 1304617.1 Main Note - Oracle GoldenGate - Checkpoints
Note 1138409.1 EXTRACT / REPLICAT CHECKPOINT RBA IS LARGER THAN LOCAL TRAILFILE SIZE, AFTER SERVER CRASH
TCP Port Assignment and Usage:
Note 1300117.1 Main Note - OGG Port Usage and TCP
Colmap
Note 1302422.1 Column Mapping Usage
Note 1277199.1 REPLICAT abend 'Error in COLMAP clause' but we aren't using COLMAP
Note 1111576.1 Replicat Abends With Can Not Process Without All Fields Or Colmap Error
ASM
Note 1304627.1 Main Note - Oracle GoldenGate - ASM
TDE - Transparent data Encryption
Note 965745.1 How To Replicate Oracle TDE (Transparent Data Encryption) Data.
Note 1271522.1 Oracle GoldenGate (OGG) and Transparent Data Encryption (TDE)
ALTARCHIVELOGDEST
ALTARCHIVELOGDEST " Points Extract to the archived or backup Oracle transaction logs when they reside somewhere other than the default location. Extract first checks the specified location and then checks the default location"
Note 1060870.1 ALTARCHIVELOGDEST
Note 966243.1 How Do I Use The ALTARCHIVELOGDEST ; Parameter To Access Oracle Redo Archive Logs In An Alternate Directory?
Note 969500.1 Parameter Options After ALTARCHIVELOGDEST Entry Are Ignored
Note 969542.1 Restored Archive Files To Another Location, Then Extract Failed With LOG_ARCHIVE_FORMAT Parameter Is
Top Linked Docs:
Note 966211.1 How To Resync A Single Table With Minimum Impact To Other Tables' Replication?
Note 966227.1 Troubleshooting TCP/IP Errors In Open Systems
Note 972954.1 What Causes The 'Bad Column Index(xxxx)' Error In Replicat?
Note 987379.1 How to recover from Extract ERROR 180 encountered commit SCN that is not greater than the highest SCN already processed (GG Version 10)
Note 1112506.1 GoldenGate Extract Abends with "Unable to lock file" Error For Trail File
Note 1124403.1 When Replicat is Running but Not Applying Records
Note 1138409.1 EXTRACT / REPLICAT CHECKPOINT RBA IS LARGER THAN LOCAL TRAILFILE SIZE, AFTER SERVER CRASH
Note 1163073.1 When using rmthost with timeout option, there are orphaned data collector processes on target system
Note 1266389.1 Oracle GoldenGate and compressed tables
Note 1270168.1 OGG-01028 Compression Not Supported - when extract processes regular and cluster tables
Note 1276538.1 Replicat abending with missing key cols
Note 1280584.1 Where To Find The List Of Supported And Unsupported Oracle Data Types for GoldenGate
Note 1288562.1 GG Data Pumps Error With OGG-01031 When Upgrading the Target Side
Note 957112.1 Encountered SCN That Is Not Greater Than The Highest SCN Already Processed
Note 1271578.1 How to Handle Tables without Primary Keys or Unique Indexes with Oracle GoldenGate
Note 957053.1 Recovering From a GG Pump Process Abending With An Incompatible Record Error
Note 968622.1 Does GoldenGate Support Tables With An UNUSED Column?
Note 968614.1 Why Does GoldenGate Report The Lag Is Unknown or a Timestamp Mismatch?
Note 968769.1 GoldenGate Errors That Occur In Teradata Extract Setting
Note 1163073.1 When using rmthost with timeout option, there are orphaned data collector processes on target system
Note 964709.1 How To Handle Oracle DDLs (add/drop/resize a Column) 22 19 1
Note 1300076.1 Usage and considerations for allocation of ports and DYNAMICPORTLIST
Note 1232303.1 mount options to use when configuring GoldenGate to run on NFS mounted file system
Note 1298548.1 Extract not accepting CACHESIZE settings
Note 1300197.1 Logger not logging cobol transactions for GGSLIB with non default AUDCFG location
Note 1273285.1 How To Troubleshoot Oracle Redo Log Reading Extract Slow Performance Issue
References
NOTE:1112406.1 - Deploying Oracle GoldenGate to Achieve Operational Reporting for Oracle JD Edwards
NOTE:1112506.1 - GoldenGate Extract Abends with "Unable to lock file" Error For Trail File
NOTE:1114746.1 - Deploying Oracle GoldenGate to Achieve Operational Reporting for PeopleSoft
NOTE:1138409.1 - OGG EXTRACT / REPLICAT CHECKPOINT RBA IS LARGER THAN LOCAL TRAIL SIZE
NOTE:1307305.1 - Master Note Oracle GoldenGate Management Pack - Director
NOTE:957053.1 - Recovering From a GG Pump Process Abending With An Incompatible Record Error
NOTE:957112.1 - OGG Encountered SCN That Is Not Greater Than The Highest SCN Already Processed
NOTE:964709.1 - How To Handle Oracle DDLs (add/drop/resize a Column)
NOTE:1298548.1 - Extract not accepting CACHESIZE settings
NOTE:1300076.1 - Usage and considerations for allocation of ports and DYNAMICPORTLIST
NOTE:1300117.1 - Master Note - OGG TCP Port Usage
NOTE:1159684.1 - OGG Extract abends,mss: missing trailing blocks, unable to queue I/O, I/O beyond file size
NOTE:965373.1 - Visual Representation of Oracle GoldenGate In An Oracle RAC Environment
NOTE:1276058.1 - Oracle GoldenGate Best Practices: Instantiation from an Oracle Source Database
NOTE:1276538.1 - Replicat Abending With Missing Key Columns
NOTE:1277199.1 - REPLICAT abend 'Error in COLMAP clause' but we aren't using COLMAP
NOTE:1280584.1 - Where To Find The List Of Supported And Unsupported Oracle Data Types (Datatypes) for GoldenGate ?
NOTE:1199561.1 - GoldenGate Replicat Characterset Conversion: Error 160 Bad column length
NOTE:1271578.1 - How to Handle Tables Without Primary Keys or Unique Indexes With Oracle GoldenGate
NOTE:1195995.1 - Implementing GoldenGate for DataGuard fail overs
NOTE:1271522.1 - Oracle GoldenGate (OGG) 11.1.1.0 and Transparent Data Encryption (TDE)
NOTE:1273285.1 - How To Troubleshoot Oracle Redo Log Reading Extract Slow Performance Issue using TESTMAPPINGSPEED
NOTE:1292874.1 - GoldenGate Extract/Pump/Replicat Abends on Startup with Error OGG-01088 Realloc xxx Bytes Failed.
NOTE:1293587.1 - Searching the Patch site for a particular OGG release
NOTE:965230.1 - How to Find GoldenGate on edelivery.oracle.com (Oracle Software Delivery Cloud)
NOTE:965270.1 - How does the Manager Allocate TCPIP Ports ?
NOTE:965356.1 - OGG GGS Error 150: No Dynamic Ports Available
NOTE:1112325.1 - Deploying Oracle GoldenGate to Achieve Operational Reporting for Oracle E-Business Suite
NOTE:1060547.1 - How To Set NLS_LANG When You Run GoldenGate On The Superset Character Sets Database?
NOTE:1232303.1 - Oracle GoldenGate Best Practice: NFS Mount options for use with GoldenGate
NOTE:1060867.1 - How To Upgrade A Single Component In GoldenGate Version 10.0
NOTE:1060870.1 - ALTARCHIVELOGDEST Oracle GoldenGate Extract
NOTE:1061093.1 - Extract fail due to an ASM connection configuration issue
NOTE:1124403.1 - When Replicat is Running but Not Applying Records
NOTE:1108953.1 - What does this message mean? "Redo thread 1: Online log /oracle/..... on sequence# 8463 has missing trailing blocks."
NOTE:1111576.1 - Replicat Abends With Can Not Process Without All Fields Or Colmap Error
NOTE:1163073.1 - When using rmthost with timeout option, there are orphaned data collector processes on target system
NOTE:1186935.1 - GGS Error 500 Could Not Find Archived Log For Sequence
NOTE:1112403.1 - Deploying Oracle GoldenGate to Achieve Operational Reporting for Oracle Siebel CRM
NOTE:1235992.1 - How to find Patches and Updates for Oracle GoldenGate
NOTE:1266389.1 - Oracle GoldenGate: Compressed tables are not supported until OGG v11.2.x Integrated Extract.
NOTE:1270168.1 - Ogg-01028 Compression Not Supported - when extract processes regular and cluster tables
NOTE:1286276.1 - Why Isn't GoldenGate Manager Purging The Trail Files?
NOTE:1288562.1 - OGG Data Pumps Error With OGG-01031 When Upgrading the Target Side
NOTE:965394.1 - Installing GoldenGate Code Into An Existing Subvolume on NSK
NOTE:965423.1 - Is GoldenGate Compatible Between Different Releases?
NOTE:965745.1 - OGG How To Replicate Oracle TDE (Transparent Data Encryption) Data.
NOTE:966156.1 - Why Does Replicat Abend With ORA-01461?
NOTE:966181.1 - Installing GoldenGate For Oracle RAC
NOTE:966207.1 - What Does The HANDLECOLLISIONS Parameter Do?
NOTE:966211.1 - How To Resync A Single Table With Minimum Impact To Other Tables' Replication?
NOTE:1300197.1 - Logger not logging cobol transactions for GGSLIB with non default AUDCFG location
NOTE:1300933.1 - Main Note - Oracle GoldenGate Core Product - Open Systems
NOTE:1300936.1 - Main Master Note - Oracle GoldenGate Core Product - HP NonStop (NSK, Tandem, Guardian, S-Series)
NOTE:1302422.1 - Column Mapping Usage - COLMAP , USEDEFAULTS
NOTE:966227.1 - OGG Troubleshooting TCP/IP Errors In Open Systems
NOTE:966243.1 - How Do I Use The "ALTARCHIVELOGDEST" Parameter To Access Oracle Redo Archive Logs In An Alternate Directory Path?
NOTE:1304561.1 - Main Note - Oracle GoldenGate - Documentation and References for Upgrading OGG code
NOTE:1304564.1 - Main Note - Oracle GoldenGate - Installation
NOTE:969551.1 - How is NLS_LANG Set When You Run GoldenGate On The Superset Character Sets Database?
NOTE:1304593.1 - Main Note - Oracle GoldenGate - RAC
NOTE:1304617.1 - Main Note - Oracle GoldenGate - Checkpoints
NOTE:1304627.1 - Main Note - Oracle GoldenGate - ASM
NOTE:1307285.1 - Master Note Oracle GoldenGate Veridata
NOTE:969542.1 - Restored Archive Files To Another Location, Then Extract Failed With LOG_ARCHIVE_FORMAT Parameter Is Undefined
NOTE:969651.1 - ORA-12705: Invalid Or Unknown NLS Parameter Value Specified.
NOTE:970860.1 - How to Apply Oracle GoldenGate Patches
NOTE:971825.1 - Why Does Extract For Oracle Abend With The Error Message "Mismatched Sequences In Archive Log"?
NOTE:972954.1 - What Causes The GGS ERROR 160 Bad Column Index(xxxx) Error in Replicat?
NOTE:987379.1 - How to recover from Extract ERROR 180 encountered commit SCN that is not greater than the highest SCN already processed (GG Version 10)
NOTE:969500.1 - Parameter Options After ALTARCHIVELOGDEST Entry Are Ignored
NOTE:968614.1 - Why Does GoldenGate Report The Lag Is Unknown or a Timestamp Mismatch?
NOTE:968622.1 - Does GoldenGate Support Tables With An UNUSED Column?
NOTE:968632.1 - Does GoldenGate Support Installation Of Its Product On A Shared Disk Subsystem In A Clustered Environment?
NOTE:968769.1 - GoldenGate Errors That Occur In Teradata Extract Setting
NOTE:1304496.1 - Main Note - Oracle GoldenGate - Tracing
NOTE:1304503.1 - Main Note - Oracle GoldenGate - Supplemental Logging
NOTE:1304557.1 - Main Note - Oracle GoldenGate - Lag, Performance, Slow and Hung Processes
====================================================================================================================================================================
How to find the database SCN from OGG trails (Doc ID 1349180.1)
OGG How To Trace A Transaction From Trail Back To Redo Log In Oracle DB (Doc ID 1359141.1)
GoldenGate Trail File Attributes and Management (Doc ID 1492616.1)
How to set up basic Oracle GoldenGate(OGG) and implement high availability(HA) in Oracle Database Appliance(ODA) environment using Oracle Clusterware (Doc ID 1391398.1)
GoldenGate Not Replicating One New Table (Doc ID 1595713.1)
OGG Extract TCP/IP Performance troubleshooting (Doc ID 1428353.1)
Troubleshooting GoldenGate Extract When Reading Redo Logs on ASM, ERROR OGG-00446 Getting attributes for ASM file, ORA-15173: entry 'oramcbta' does not exist in directory (Doc ID 1315404.1)
Oracle GoldenGate - How To Use GDB To Generate Stack Trace For Troubleshooting Purpose (Doc ID 1458985.1)
GoldenGate Configuration for Stability and Recovery (Doc ID 1451514.1)
oldenGate Performance Tuning, Configuration Attributes & Monitoring (Doc ID 1455566.1)
Master Note - Oracle GoldenGate (Doc ID 1298817.1)
Oracle GoldenGate Performance Data Gathering (Doc ID 1488668.1)
How To Troubleshoot Extract Performance Issues (Doc ID 1063123.1)
What Are The Considerations in Using "Batchsql"? (Doc ID 1060546.1)
How to Optimise the OGG Replicat BATCHSQL Parameters and What are Their Limits? (Doc ID 1375506.1)
Excessive REPLICAT LAG Times (Doc ID 962592.1)
How To Setup GoldenGate To Maintain A Heartbeat With The Database (Doc ID 965415.1)
How to diagnose GoldenGate GGSCI command errors on an Oracle database (Doc ID 1575600.1)
Oracle GoldenGate database Complete Database Profile check script for Oracle DB (All Schemas) Classic Extract(Doc ID 1298562.1)
V$GOLDENGATE_MESSAGE_TRACKING,
V$GOLDENGATE_CAPTURE,
V$GOLDENGATE_TRANSACTION
http://dbasolutions.wikispaces.com/Golden+Gate (Golden Gate)
RAC
Note 966181.1 Installing GoldenGate For Oracle RAC
Note 965373.1 Installing And Configuring OGG In A RAC Environment
Note 970876.1 Oracle ASM RAC EXTRACT Hanging
Note 967390.1 Using Alternative Archived Log Destination On Oracle RAC
Note 1242965.1 Re-enabling a RAC thread got extract abend with 'begin time .. prior to oldest log in log history.'
Note 957112.1 Encountered SCN That Is Not Greater Than The Highest SCN Already Processed
Note 987379.1 How to recover from Extract ERROR 180 encountered commit SCN that is not greater than the highest
Note 1342635.1How the mapping of OGG thread will change when a RAC node is add added or remove removed?
Note 965373.1 Visual Representation of Oracle GoldenGate In An Oracle RAC Environment
Note 1476058.1 Downgrading INTEGRATED Extract to Classic Extract fails on RAC environment
Note 1313703.1 Oracle GoldenGate Best Practices: Oracle GoldenGate high availability using Oracle Clusterware
Note 1267901.1 How to configure GoldenGate extract when adding or removing redo log threads in an Oracle RAC.
Note 1059895.1 Extract Processes Running In An Oracle RAC On Linux Environment
OGG How Can I View Transaction Boundaries And Type In Logdump? (Doc ID 968618.1)
How to Stop the OGG Replicat at a Particular CSN Value (Doc ID 1368812.1)
Oracle GoldenGate - Using the GoldenGate Logdump Utility to Manually Load Balance across Multiple Processes (Doc ID 1301300.1)
How to recover GoldenGate replication after flashing back (or recovering to a precious point at) source database? (Doc ID 1626736.1)
How to Check the Records in an Encrypted Trail File by Using OGG Logdump Utility (Doc ID 1351522.1)
How to Encrypt/Decrypt Oracle GoldenGate Trail File (Doc ID 1287578.1)
GoldenGate Trail File Attributes and Management (Doc ID 1492616.1)
How to combine "before" image and "after" image update record values in the trail to a single row on target ? (Doc ID 1494488.1)
FAQ - 11.2.1 - How do extract parameters affect the data to be selected to be written to the GoldenGate trail file. (Doc ID 1478414.1)
http://www.juliandyke.com/Blog/?p=279 (Oracle GoldenGate – Trail Internals)
Oracle GoldenGate database Complete Database Profile check script for Oracle DB (All Schemas) Classic Extract (Doc ID 1298562.1)
http://myoracleproduct.blogspot.com/2013/11/oracle-goldengate-replication-oracle-to.html
OGG Displaying Incorrect Status from Inactive Node (Doc ID 1350133.1)
Controlled DR Tests Using Dataguard with Goldengate in the Mix (Doc ID 1672938.1)
Best Practices for failover during server failures (Doc ID 1323472.1)
How to Perform Hot-site Maintenance Failover with GoldenGate (Doc ID 1397455.1)
Can GoldenGate Extract process through Oracle database resetlogs?
Extract will not Start After Degradation of Oracle Goldengate Version (Doc ID 1963174.1)
Read Note:1371410.1 OGG Replicat Abends with Database Errors Such as Oracle DB Errors ORA-01403, ORA-00001, Etc.
Read Note:1329189.1 Replicat Abends With "OGG-01154 SQL Error 1403 Mapping"
If the solutions do not resolve your issue, follow the steps detailed in the document below:
Read Note:1906074.1 SRDC - Information to Collect When GoldenGate Replicat Abends with ORA-00001, ORA-01403, ORA-02291 Errors
Unable To Skip Long Running Transaction In Oracle Goldengate Using SKIPTRANS (Doc ID 1639676.1)
How to compare subset of data in veridata using 'Where' clause (Doc ID 1471441.1)
How do I skip one DML / IO / row that is a problem when there are several in the transaction? (Doc ID 1645816.1)
How to start / alter an OGG Pump Extract from a timestamp or SCN (Doc ID 1915865.1)
How to Stop the OGG Replicat at a Particular CSN Value (Doc ID 1368812.1)
Oracle GoldenGate ( OGG ) Recovery Techniques Main Note (Doc ID 1465044.1)
OGG How to Avoid Transaction Looping in an Active-Active(Bi-Directional) Environment (Doc ID 1404384.1)
Oracle GoldenGate, Best Practice: How To Handle DDL Changes in a DML Only Replication (Doc ID 1346788.1)
FAQ - Oracle GoldenGate on Oracle 12c cdb/pdb (Doc ID 1634589.1)
Master Note for Oracle GoldenGate for Filtering and Transformation Data (Doc ID 1450495.1)
Skipping transactions across different Data Bases (Doc ID 1983997.1)
How To Upgrade From Goldengate Classic Extract To Integrated Extract (Doc ID 1484313.1)
How Can I Capture Data with Datapump when Data is Split between Two Trails and Pump won't Advance to Second Trail? Datapump Will not Finish Processing Data in Trail (Doc ID 1465083.1)
Rebuild Index Online Causes Extract/Replicat Abend (Doc ID 1348226.1)
How to Resolve ORA-12154 When Extract or Replicat Abends at Startup (Doc ID 971697.1)
No Unique Key Is Defined For Table - OGG-01296 Error mapping (Doc ID 2017835.1)
Golden Gate Replicat Abending: OGG-01296 (Doc ID 1514686.1)
GoldenGate Extract abends with no error when processing DDL related to database link (Doc ID 1543892.1)
Which Information to Provide if GoldenGate Extract or Replicat Abend Without Error (Doc ID 1378446.1)
OGG-02544 Unhandled Error (ORA-00904: : Invalid Identifier) (Doc ID 1940722.1)
Comparison Between Oracle Streams and GoldenGate (Doc ID 1437736.1)
My Checkpoint Table Is Corrupted. What Do I Do? (Doc ID 965703.1)
=============================================================
Master Note - Oracle GoldenGate (Doc ID 1298817.1)
Information in this document applies to any platform.
Posted on April 23, 2012 by Alex Lima
Note 1273285.1 How to troubleshoot Oracle Redo log reading
Note 1060533.1 How to trace transaction from trail back to redo log
Note 1060593.1 Analysis of empty supplemental log key values in trail for an Oracle update
Note 1268590.1 Checking for Oracle archive log corruption
Note 1273285.1 How do I troubleshoot Oracle Redo Log Reading Extract Slow Performance
Note 1127476.1 Redo Thread: error 13 (Permission denied) opening redo log
Note 1086154.1 Compatibility between OGG builds and Oracle database versions
Note 1054126.1 How do I change the version compatibility to 9.2 in an Oracle Database
Note 1060581.1 Why is the “select any table” privilege required for extract on an Oracle Partition table
Note 1267901.1 How to configure GoldenGate extract when adding or removing redo log threads in an Oracle RAC
Note 1269274.1 Why does GoldenGate require DBA/SYSDBA privileges in extract/replicat
Note 1112325.1 Deploying Oracle Goldengate to achieve operational reporting for Oracle E-Business Suite
Note 1112403.1 Deploying Oracle Goldengate to achieve operational reporting for Oracle Siebel CRM
Note 1112406.1 Deploying Oracle Goldengate to achieve operational reporting for Oracle JD Edwards
Note 1114746.1 Deploying Oracle GoldenGate to achieve operational reporting for PeopleSoft
Note 1276058.1 Oracle GoldenGate Best Practices: Instantiation form an Oracle Source Database
Note 1298562.1 Oracle GoldenGate data base complete database check script (all schemas)
Oracle GoldenGate Logdump Complete Reference FAQ (Doc ID 1446672.1)
Click to add to Favorites How to Stop the OGG Replicat at a Particular CSN Value (Doc ID 1368812.1)
Note 972950.1 Why do I receive the Error “ORA-12638 Credential Retrieval Failed”
Note 1059710.1 GoldenGate Extract/Replicat Error in Oracle-UNIX environment
Note 1195995.1 Implementing GoldenGate for DataGuard fail overs
Note 1269855.1 Oracle GoldenGate supports reading redo and archive log files stored on Raw devices with source database on AIX OS and also requires TRANLOFOPTIONS RAWDEVICEOFFSET parameter
Note 1280235.1 Oracle procedure failed with ORA-12801 and ORA-01031 only when OGG DDL trigger is enabled
Note 1280584.1 Where to find the list of supported and unsupported Oracle Data Types for GoldenGate
Note 1297398.1 GoldenGate – Error(904, ORA-00904:: Invalid identifier)selecting data in ORAUTIL_getCurrentSCN()
Note 972950.1 Why do I receive the Error “ORA-12638 Credential Retrieval Failed”
Note 1149823.1 Extract cannot read database redo (Oracle) or only (SQLServer) logs on Windows 2008 or Windows 7
Note 1206737.1 Extract generates a large colume of trail data for Lob updates on Oracle
Note 1296567.1 Why does extract fail with Error OGG-00665: ORA-22812
Note 1297398.1 GOldenGate – Erro r(904, ORA-00904:: Invalid identifier)selecting data in ORAUTIL_getCurrentSCN()
Note 972329.1 Why do I get the Error message “GG ErrorNote 1 18 Unknown Specifier in Archive log format”
Note 972946.1 Why does extract/replicat on OracleNote 1 0.2.0.3 fail with the “1008-ORA-01008: not all variables bound error message
Note 972950.1 Why do I receive the Error “ORA-12638 Credential Retrieval Failed”
Note 973586.1 Extraction of CLOB/LOB data, when do we do a DB fetch
Note 987379.1 How to recover from extract ERRORNote 1 80 encountered commit SCN that is not greater than the highest SCN already processed
Note 1059895.1 Extract processes running in an Oracle RAC on Linux environment
Note 1060553.1 Extract for Oracle abends with the Error “getting Last rollback item ROWID”
Note 1108953.1 What does this message mean? “Redo thread online log/oracle
Note 1125265.1 Extract abend with Error numcnv_getnumeric buffer overflow, chained row or others
Note 1186935.1 GGS Error 500 could not find archived log for sequence
Note 1192972.1 ALO extract hangs on restart an error 22 (invalid argument) occurs
Note 1206737.1 Extract generates a large column of trail data for Lob updates on Oracle
Note 1211806.1 OGG extract abends with” cm_obj_pop_last_item: object empty: error 116
Note 1242965.1 Reenabling a RAC thread got extract abend with “begin time prior to oldest log in log history
Note 1265785.1 Extract abended with ORA-01013 when processing DDL record
Note 1267048.1 Extract abends as a table is considered as compresses only when with DDL parameter
Note 1270168.1 OGG-01028 Compression not supported – when extract processes regular and cluster tables
Note 1273546.1 Oracle export hangs when OGG extract DDL trigger enabled
Note 1274300.1 Extract abended with Error “ORA-00942:table or view does not exist, SQL< select values$ from sys.props$ where name = ‘NLS_LANGUAGE’
Note 1285734.1 Why extract on RAC with DDL parameter, abended on a table that is not included in the parameter list
Note 1291330.1 DBLOGREADER extract fails with this versions of ORACLE does not support DBLOGREADER
Note 972962.1 How do I call an Oracle function within replicat
Note 1087305.1 How to specify which Oracle database to access from a GoldenGate replicat
Note 1116896.1 OGG replicat gets ORA-01873 for interval data on HP-UX
Note 1259884.1 ERROR OGG-01082 when running a replicat against an Oracle database
Note 972411.1 Can I minimize notification of long running transactions on Oracle
Note 1054126.1 How do I change the version compatibility to 9.2 in an Oracle Database
Note 1059352.1 How to turn on supplemental logging at the database or the table level
Note 1059362.1 How do I determine if supplemental logging is turned ON at the database or the table level
Note 1059583.1 When GoldenGate fetches data from the database on extraction for Oracle
Note 1060437.1 Why do I get the ora-00001 when doing multi-row PK/unique_key update by single statement in Oracle
Note 1060525.1 Does GolenGate support the DML statement merge
Note 1060533.1 How to trace transaction from trail back to redo log
Note 1060535.1 Using Oracle GoldenGate in an Oracle ASM environment when a non sys user
Note 1060568.1 GGS Error 118 OCI error creating temp LOB
Note 1060581.1 Why is the “select any table” privilege required for extract on an Oracle Partition table
Note 1060794.1 How to solve an Ora-02292 error in replicat for a self-referential FK when processing multi-row deletes
Note 1060870.1 ALTARCHIVELOGDEST
Note 1061093.1 Extract fails with Error 118 No valid Log File for current Redo sequence xxxx thread Y
Note 1063125.1 Error message ORA-20782: DDL operation Failed because Recyclebin is turned on
Note 1063389.1 How to turn-off Oracle Recycle bin
Note 1081322.1 Configuring Oracle GoldenGate for partitioned Replication
Note 1083886.1 Can I use the @RANGE Function to split data exactly by a column value
Note 1087214.1 OCI error ora-01830 in OGG replicat when using sqlexec to call a procedure
Note 1265554.1 OGG DDL support of ALTER TABLE move or DBMS_REDEFINITION
Note 1280235.1 Oracle procedure failed with ORA-12801 and ORA-01031 only when OGG DDL trigger is enabled
Note 1297811.1 Why do I see a message INFO 220 found Crash Recovery Marker from
===========================================================================================================================================================
See Individual products Notes for individual links:
Note 1304561.1 Master Note - Oracle GoldenGate - Upgrading OGG code
Note : 1235992.1 How to find Patches and Updates for Oracle GoldenGate
Note : 1293587.1 Searching the Patch site for a particular OGG release
Note : 970860.1 How To Apply Oracle GoldenGate Patches
Note: 1112325.1 Deploying Oracle GoldenGate to Achieve Operational Reporting for Oracle E-Business Suite
Note: 1112406.1 Deploying Oracle GoldenGate to Achieve Operational Reporting for Oracle JD Edwards
Note: 1114746.1 Deploying Oracle GoldenGate to Achieve Operational Reporting for PeopleSoft
Note: 1112403.1 Deploying Oracle GoldenGate to Achieve Operational Reporting for Oracle Siebel CRM
Compatibility
Note : 965423.1 Is GoldenGate Compatible Between Different Releases?
Note : 1086154.1 Compatibility between OGG builds and Oracle database Versions
Note : 1300936.1 NSK Specific Main Note
Note: 266043.1 Support of Linux and Oracle Products on Linux
Performance and Tuning (LAG):
Note 1304557.1 Main Note - Oracle GoldenGate - Lag, Performance, Slow and Hung Processes
Tracing:
Note 1304496.1 Main Note - Oracle GoldenGate - Tracing
Handlecollisions
Note 966207.1 What Does The HANDLECOLLISIONS Parameter Do
NLS_LANG
Note 969551.1 How is NLS_LANG Set When You Run OGG On The Superset Character Sets Database
Note 969651.1 ORA-12705: Invalid Or Unknown NLS Parameter Value Specified.
Supplemental Logging
"Supplemental logging at the table level and the database level must be enabled for the tables from the source database."
Note 1304503.1 Main Note - Oracle GoldenGate - Supplemental Logging
RAC
Note 1304593.1 Main Note - Oracle GoldenGate - RAC
ARCHIVE LOG Sequence
Note 1186935.1 GGS Error 500 Could Not Find Archived Log For Sequence
Note 1108953.1 What does this mean? Redo thread 1: Online log /oracle/..... on sequence# nnn has missing
Note 971825.1 Why Does Extract For Oracle Abend With Error "Mismatched Sequences In Archive Log"?
CheckPoint
Note 1304617.1 Main Note - Oracle GoldenGate - Checkpoints
Note 1138409.1 EXTRACT / REPLICAT CHECKPOINT RBA IS LARGER THAN LOCAL TRAILFILE SIZE, AFTER SERVER CRASH
TCP Port Assignment and Usage:
Note 1300117.1 Main Note - OGG Port Usage and TCP
Colmap
Note 1302422.1 Column Mapping Usage
Note 1277199.1 REPLICAT abend 'Error in COLMAP clause' but we aren't using COLMAP
Note 1111576.1 Replicat Abends With Can Not Process Without All Fields Or Colmap Error
ASM
Note 1304627.1 Main Note - Oracle GoldenGate - ASM
TDE - Transparent data Encryption
Note 965745.1 How To Replicate Oracle TDE (Transparent Data Encryption) Data.
Note 1271522.1 Oracle GoldenGate (OGG) and Transparent Data Encryption (TDE)
ALTARCHIVELOGDEST
ALTARCHIVELOGDEST " Points Extract to the archived or backup Oracle transaction logs when they reside somewhere other than the default location. Extract first checks the specified location and then checks the default location"
Note 1060870.1 ALTARCHIVELOGDEST
Note 966243.1 How Do I Use The ALTARCHIVELOGDEST ; Parameter To Access Oracle Redo Archive Logs In An Alternate Directory?
Note 969500.1 Parameter Options After ALTARCHIVELOGDEST Entry Are Ignored
Note 969542.1 Restored Archive Files To Another Location, Then Extract Failed With LOG_ARCHIVE_FORMAT Parameter Is
Top Linked Docs:
Note 966211.1 How To Resync A Single Table With Minimum Impact To Other Tables' Replication?
Note 966227.1 Troubleshooting TCP/IP Errors In Open Systems
Note 972954.1 What Causes The 'Bad Column Index(xxxx)' Error In Replicat?
Note 987379.1 How to recover from Extract ERROR 180 encountered commit SCN that is not greater than the highest SCN already processed (GG Version 10)
Note 1112506.1 GoldenGate Extract Abends with "Unable to lock file" Error For Trail File
Note 1124403.1 When Replicat is Running but Not Applying Records
Note 1138409.1 EXTRACT / REPLICAT CHECKPOINT RBA IS LARGER THAN LOCAL TRAILFILE SIZE, AFTER SERVER CRASH
Note 1163073.1 When using rmthost with timeout option, there are orphaned data collector processes on target system
Note 1266389.1 Oracle GoldenGate and compressed tables
Note 1270168.1 OGG-01028 Compression Not Supported - when extract processes regular and cluster tables
Note 1276538.1 Replicat abending with missing key cols
Note 1280584.1 Where To Find The List Of Supported And Unsupported Oracle Data Types for GoldenGate
Note 1288562.1 GG Data Pumps Error With OGG-01031 When Upgrading the Target Side
Note 957112.1 Encountered SCN That Is Not Greater Than The Highest SCN Already Processed
Note 1271578.1 How to Handle Tables without Primary Keys or Unique Indexes with Oracle GoldenGate
Note 957053.1 Recovering From a GG Pump Process Abending With An Incompatible Record Error
Note 968622.1 Does GoldenGate Support Tables With An UNUSED Column?
Note 968614.1 Why Does GoldenGate Report The Lag Is Unknown or a Timestamp Mismatch?
Note 968769.1 GoldenGate Errors That Occur In Teradata Extract Setting
Note 1163073.1 When using rmthost with timeout option, there are orphaned data collector processes on target system
Note 964709.1 How To Handle Oracle DDLs (add/drop/resize a Column) 22 19 1
Note 1300076.1 Usage and considerations for allocation of ports and DYNAMICPORTLIST
Note 1232303.1 mount options to use when configuring GoldenGate to run on NFS mounted file system
Note 1298548.1 Extract not accepting CACHESIZE settings
Note 1300197.1 Logger not logging cobol transactions for GGSLIB with non default AUDCFG location
Note 1273285.1 How To Troubleshoot Oracle Redo Log Reading Extract Slow Performance Issue
References
NOTE:1112406.1 - Deploying Oracle GoldenGate to Achieve Operational Reporting for Oracle JD Edwards
NOTE:1112506.1 - GoldenGate Extract Abends with "Unable to lock file" Error For Trail File
NOTE:1114746.1 - Deploying Oracle GoldenGate to Achieve Operational Reporting for PeopleSoft
NOTE:1138409.1 - OGG EXTRACT / REPLICAT CHECKPOINT RBA IS LARGER THAN LOCAL TRAIL SIZE
NOTE:1307305.1 - Master Note Oracle GoldenGate Management Pack - Director
NOTE:957053.1 - Recovering From a GG Pump Process Abending With An Incompatible Record Error
NOTE:957112.1 - OGG Encountered SCN That Is Not Greater Than The Highest SCN Already Processed
NOTE:964709.1 - How To Handle Oracle DDLs (add/drop/resize a Column)
NOTE:1298548.1 - Extract not accepting CACHESIZE settings
NOTE:1300076.1 - Usage and considerations for allocation of ports and DYNAMICPORTLIST
NOTE:1300117.1 - Master Note - OGG TCP Port Usage
NOTE:1159684.1 - OGG Extract abends,mss: missing trailing blocks, unable to queue I/O, I/O beyond file size
NOTE:965373.1 - Visual Representation of Oracle GoldenGate In An Oracle RAC Environment
NOTE:1276058.1 - Oracle GoldenGate Best Practices: Instantiation from an Oracle Source Database
NOTE:1276538.1 - Replicat Abending With Missing Key Columns
NOTE:1277199.1 - REPLICAT abend 'Error in COLMAP clause' but we aren't using COLMAP
NOTE:1280584.1 - Where To Find The List Of Supported And Unsupported Oracle Data Types (Datatypes) for GoldenGate ?
NOTE:1199561.1 - GoldenGate Replicat Characterset Conversion: Error 160 Bad column length
NOTE:1271578.1 - How to Handle Tables Without Primary Keys or Unique Indexes With Oracle GoldenGate
NOTE:1195995.1 - Implementing GoldenGate for DataGuard fail overs
NOTE:1271522.1 - Oracle GoldenGate (OGG) 11.1.1.0 and Transparent Data Encryption (TDE)
NOTE:1273285.1 - How To Troubleshoot Oracle Redo Log Reading Extract Slow Performance Issue using TESTMAPPINGSPEED
NOTE:1292874.1 - GoldenGate Extract/Pump/Replicat Abends on Startup with Error OGG-01088 Realloc xxx Bytes Failed.
NOTE:1293587.1 - Searching the Patch site for a particular OGG release
NOTE:965230.1 - How to Find GoldenGate on edelivery.oracle.com (Oracle Software Delivery Cloud)
NOTE:965270.1 - How does the Manager Allocate TCPIP Ports ?
NOTE:965356.1 - OGG GGS Error 150: No Dynamic Ports Available
NOTE:1112325.1 - Deploying Oracle GoldenGate to Achieve Operational Reporting for Oracle E-Business Suite
NOTE:1060547.1 - How To Set NLS_LANG When You Run GoldenGate On The Superset Character Sets Database?
NOTE:1232303.1 - Oracle GoldenGate Best Practice: NFS Mount options for use with GoldenGate
NOTE:1060867.1 - How To Upgrade A Single Component In GoldenGate Version 10.0
NOTE:1060870.1 - ALTARCHIVELOGDEST Oracle GoldenGate Extract
NOTE:1061093.1 - Extract fail due to an ASM connection configuration issue
NOTE:1124403.1 - When Replicat is Running but Not Applying Records
NOTE:1108953.1 - What does this message mean? "Redo thread 1: Online log /oracle/..... on sequence# 8463 has missing trailing blocks."
NOTE:1111576.1 - Replicat Abends With Can Not Process Without All Fields Or Colmap Error
NOTE:1163073.1 - When using rmthost with timeout option, there are orphaned data collector processes on target system
NOTE:1186935.1 - GGS Error 500 Could Not Find Archived Log For Sequence
NOTE:1112403.1 - Deploying Oracle GoldenGate to Achieve Operational Reporting for Oracle Siebel CRM
NOTE:1235992.1 - How to find Patches and Updates for Oracle GoldenGate
NOTE:1266389.1 - Oracle GoldenGate: Compressed tables are not supported until OGG v11.2.x Integrated Extract.
NOTE:1270168.1 - Ogg-01028 Compression Not Supported - when extract processes regular and cluster tables
NOTE:1286276.1 - Why Isn't GoldenGate Manager Purging The Trail Files?
NOTE:1288562.1 - OGG Data Pumps Error With OGG-01031 When Upgrading the Target Side
NOTE:965394.1 - Installing GoldenGate Code Into An Existing Subvolume on NSK
NOTE:965423.1 - Is GoldenGate Compatible Between Different Releases?
NOTE:965745.1 - OGG How To Replicate Oracle TDE (Transparent Data Encryption) Data.
NOTE:966156.1 - Why Does Replicat Abend With ORA-01461?
NOTE:966181.1 - Installing GoldenGate For Oracle RAC
NOTE:966207.1 - What Does The HANDLECOLLISIONS Parameter Do?
NOTE:966211.1 - How To Resync A Single Table With Minimum Impact To Other Tables' Replication?
NOTE:1300197.1 - Logger not logging cobol transactions for GGSLIB with non default AUDCFG location
NOTE:1300933.1 - Main Note - Oracle GoldenGate Core Product - Open Systems
NOTE:1300936.1 - Main Master Note - Oracle GoldenGate Core Product - HP NonStop (NSK, Tandem, Guardian, S-Series)
NOTE:1302422.1 - Column Mapping Usage - COLMAP , USEDEFAULTS
NOTE:966227.1 - OGG Troubleshooting TCP/IP Errors In Open Systems
NOTE:966243.1 - How Do I Use The "ALTARCHIVELOGDEST" Parameter To Access Oracle Redo Archive Logs In An Alternate Directory Path?
NOTE:1304561.1 - Main Note - Oracle GoldenGate - Documentation and References for Upgrading OGG code
NOTE:1304564.1 - Main Note - Oracle GoldenGate - Installation
NOTE:969551.1 - How is NLS_LANG Set When You Run GoldenGate On The Superset Character Sets Database?
NOTE:1304593.1 - Main Note - Oracle GoldenGate - RAC
NOTE:1304617.1 - Main Note - Oracle GoldenGate - Checkpoints
NOTE:1304627.1 - Main Note - Oracle GoldenGate - ASM
NOTE:1307285.1 - Master Note Oracle GoldenGate Veridata
NOTE:969542.1 - Restored Archive Files To Another Location, Then Extract Failed With LOG_ARCHIVE_FORMAT Parameter Is Undefined
NOTE:969651.1 - ORA-12705: Invalid Or Unknown NLS Parameter Value Specified.
NOTE:970860.1 - How to Apply Oracle GoldenGate Patches
NOTE:971825.1 - Why Does Extract For Oracle Abend With The Error Message "Mismatched Sequences In Archive Log"?
NOTE:972954.1 - What Causes The GGS ERROR 160 Bad Column Index(xxxx) Error in Replicat?
NOTE:987379.1 - How to recover from Extract ERROR 180 encountered commit SCN that is not greater than the highest SCN already processed (GG Version 10)
NOTE:969500.1 - Parameter Options After ALTARCHIVELOGDEST Entry Are Ignored
NOTE:968614.1 - Why Does GoldenGate Report The Lag Is Unknown or a Timestamp Mismatch?
NOTE:968622.1 - Does GoldenGate Support Tables With An UNUSED Column?
NOTE:968632.1 - Does GoldenGate Support Installation Of Its Product On A Shared Disk Subsystem In A Clustered Environment?
NOTE:968769.1 - GoldenGate Errors That Occur In Teradata Extract Setting
NOTE:1304496.1 - Main Note - Oracle GoldenGate - Tracing
NOTE:1304503.1 - Main Note - Oracle GoldenGate - Supplemental Logging
NOTE:1304557.1 - Main Note - Oracle GoldenGate - Lag, Performance, Slow and Hung Processes
====================================================================================================================================================================
How to find the database SCN from OGG trails (Doc ID 1349180.1)
OGG How To Trace A Transaction From Trail Back To Redo Log In Oracle DB (Doc ID 1359141.1)
GoldenGate Trail File Attributes and Management (Doc ID 1492616.1)
How to set up basic Oracle GoldenGate(OGG) and implement high availability(HA) in Oracle Database Appliance(ODA) environment using Oracle Clusterware (Doc ID 1391398.1)
GoldenGate Not Replicating One New Table (Doc ID 1595713.1)
OGG Extract TCP/IP Performance troubleshooting (Doc ID 1428353.1)
Troubleshooting GoldenGate Extract When Reading Redo Logs on ASM, ERROR OGG-00446 Getting attributes for ASM file, ORA-15173: entry 'oramcbta' does not exist in directory (Doc ID 1315404.1)
Oracle GoldenGate - How To Use GDB To Generate Stack Trace For Troubleshooting Purpose (Doc ID 1458985.1)
GoldenGate Configuration for Stability and Recovery (Doc ID 1451514.1)
oldenGate Performance Tuning, Configuration Attributes & Monitoring (Doc ID 1455566.1)
Master Note - Oracle GoldenGate (Doc ID 1298817.1)
Oracle GoldenGate Performance Data Gathering (Doc ID 1488668.1)
How To Troubleshoot Extract Performance Issues (Doc ID 1063123.1)
What Are The Considerations in Using "Batchsql"? (Doc ID 1060546.1)
How to Optimise the OGG Replicat BATCHSQL Parameters and What are Their Limits? (Doc ID 1375506.1)
Excessive REPLICAT LAG Times (Doc ID 962592.1)
How To Setup GoldenGate To Maintain A Heartbeat With The Database (Doc ID 965415.1)
How to diagnose GoldenGate GGSCI command errors on an Oracle database (Doc ID 1575600.1)
Oracle GoldenGate database Complete Database Profile check script for Oracle DB (All Schemas) Classic Extract(Doc ID 1298562.1)
V$GOLDENGATE_MESSAGE_TRACKING,
V$GOLDENGATE_CAPTURE,
V$GOLDENGATE_TRANSACTION
http://dbasolutions.wikispaces.com/Golden+Gate (Golden Gate)
RAC
Note 966181.1 Installing GoldenGate For Oracle RAC
Note 965373.1 Installing And Configuring OGG In A RAC Environment
Note 970876.1 Oracle ASM RAC EXTRACT Hanging
Note 967390.1 Using Alternative Archived Log Destination On Oracle RAC
Note 1242965.1 Re-enabling a RAC thread got extract abend with 'begin time .. prior to oldest log in log history.'
Note 957112.1 Encountered SCN That Is Not Greater Than The Highest SCN Already Processed
Note 987379.1 How to recover from Extract ERROR 180 encountered commit SCN that is not greater than the highest
Note 1342635.1How the mapping of OGG thread will change when a RAC node is add added or remove removed?
Note 965373.1 Visual Representation of Oracle GoldenGate In An Oracle RAC Environment
Note 1476058.1 Downgrading INTEGRATED Extract to Classic Extract fails on RAC environment
Note 1313703.1 Oracle GoldenGate Best Practices: Oracle GoldenGate high availability using Oracle Clusterware
Note 1267901.1 How to configure GoldenGate extract when adding or removing redo log threads in an Oracle RAC.
Note 1059895.1 Extract Processes Running In An Oracle RAC On Linux Environment
OGG How Can I View Transaction Boundaries And Type In Logdump? (Doc ID 968618.1)
How to Stop the OGG Replicat at a Particular CSN Value (Doc ID 1368812.1)
Oracle GoldenGate - Using the GoldenGate Logdump Utility to Manually Load Balance across Multiple Processes (Doc ID 1301300.1)
How to recover GoldenGate replication after flashing back (or recovering to a precious point at) source database? (Doc ID 1626736.1)
How to Check the Records in an Encrypted Trail File by Using OGG Logdump Utility (Doc ID 1351522.1)
How to Encrypt/Decrypt Oracle GoldenGate Trail File (Doc ID 1287578.1)
GoldenGate Trail File Attributes and Management (Doc ID 1492616.1)
How to combine "before" image and "after" image update record values in the trail to a single row on target ? (Doc ID 1494488.1)
FAQ - 11.2.1 - How do extract parameters affect the data to be selected to be written to the GoldenGate trail file. (Doc ID 1478414.1)
http://www.juliandyke.com/Blog/?p=279 (Oracle GoldenGate – Trail Internals)
Oracle GoldenGate database Complete Database Profile check script for Oracle DB (All Schemas) Classic Extract (Doc ID 1298562.1)
http://myoracleproduct.blogspot.com/2013/11/oracle-goldengate-replication-oracle-to.html
OGG Displaying Incorrect Status from Inactive Node (Doc ID 1350133.1)
Controlled DR Tests Using Dataguard with Goldengate in the Mix (Doc ID 1672938.1)
Best Practices for failover during server failures (Doc ID 1323472.1)
How to Perform Hot-site Maintenance Failover with GoldenGate (Doc ID 1397455.1)
Can GoldenGate Extract process through Oracle database resetlogs?
Extract will not Start After Degradation of Oracle Goldengate Version (Doc ID 1963174.1)
Read Note:1371410.1 OGG Replicat Abends with Database Errors Such as Oracle DB Errors ORA-01403, ORA-00001, Etc.
Read Note:1329189.1 Replicat Abends With "OGG-01154 SQL Error 1403 Mapping"
If the solutions do not resolve your issue, follow the steps detailed in the document below:
Read Note:1906074.1 SRDC - Information to Collect When GoldenGate Replicat Abends with ORA-00001, ORA-01403, ORA-02291 Errors
Unable To Skip Long Running Transaction In Oracle Goldengate Using SKIPTRANS (Doc ID 1639676.1)
How to compare subset of data in veridata using 'Where' clause (Doc ID 1471441.1)
How do I skip one DML / IO / row that is a problem when there are several in the transaction? (Doc ID 1645816.1)
How to start / alter an OGG Pump Extract from a timestamp or SCN (Doc ID 1915865.1)
How to Stop the OGG Replicat at a Particular CSN Value (Doc ID 1368812.1)
Oracle GoldenGate ( OGG ) Recovery Techniques Main Note (Doc ID 1465044.1)
OGG How to Avoid Transaction Looping in an Active-Active(Bi-Directional) Environment (Doc ID 1404384.1)
Oracle GoldenGate, Best Practice: How To Handle DDL Changes in a DML Only Replication (Doc ID 1346788.1)
FAQ - Oracle GoldenGate on Oracle 12c cdb/pdb (Doc ID 1634589.1)
Master Note for Oracle GoldenGate for Filtering and Transformation Data (Doc ID 1450495.1)
Skipping transactions across different Data Bases (Doc ID 1983997.1)
How To Upgrade From Goldengate Classic Extract To Integrated Extract (Doc ID 1484313.1)
How Can I Capture Data with Datapump when Data is Split between Two Trails and Pump won't Advance to Second Trail? Datapump Will not Finish Processing Data in Trail (Doc ID 1465083.1)
Rebuild Index Online Causes Extract/Replicat Abend (Doc ID 1348226.1)
How to Resolve ORA-12154 When Extract or Replicat Abends at Startup (Doc ID 971697.1)
No Unique Key Is Defined For Table - OGG-01296 Error mapping (Doc ID 2017835.1)
Golden Gate Replicat Abending: OGG-01296 (Doc ID 1514686.1)
GoldenGate Extract abends with no error when processing DDL related to database link (Doc ID 1543892.1)
Which Information to Provide if GoldenGate Extract or Replicat Abend Without Error (Doc ID 1378446.1)
OGG-02544 Unhandled Error (ORA-00904: : Invalid Identifier) (Doc ID 1940722.1)
Comparison Between Oracle Streams and GoldenGate (Doc ID 1437736.1)
My Checkpoint Table Is Corrupted. What Do I Do? (Doc ID 965703.1)
=============================================================
Master Note - Oracle GoldenGate (Doc ID 1298817.1)
APPLIES TO:
Oracle GoldenGate - Version 4.0.0 and laterInformation in this document applies to any platform.
DETAILS
*Details
Enter details of the announcement. Enter a clear description of the major issue or topic covered by the announcement. Be descriptive. It is this section that will guide the reader to decide whether the document is for him/her.
"Supplemental logging at the table level and the database level must be enabled for the tables from the source database."
Note 1186935.1 GGS Error 500 Could Not Find Archived Log For Sequence
Note 1108953.1 What does this mean? Redo thread 1: Online log /oracle/..... on sequence# nnn has missing
Note 971825.1 Why Does Extract For Oracle Abend With Error "Mismatched Sequences In Archive Log"?
Note 1302422.1 Column Mapping Usage
Note 1277199.1 REPLICAT abend 'Error in COLMAP clause' but we aren't using COLMAP
Note 1111576.1 Replicat Abends With Can Not Process Without All Fields Or Colmap Error
Note 966211.1 How To Resync A Single Table With Minimum Impact To Other Tables' Replication?
Note 966227.1 Troubleshooting TCP/IP Errors In Open Systems
Note 972954.1 What Causes The 'Bad Column Index(xxxx)' Error In Replicat?
Note 987379.1 How to recover from Extract ERROR 180 encountered commit SCN that is not greater than the highest SCN already processed (GG Version 10)
Note 1112506.1 GoldenGate Extract Abends with "Unable to lock file" Error For Trail File
Note 1124403.1 When Replicat is Running but Not Applying Records
Note 1138409.1 EXTRACT / REPLICAT CHECKPOINT RBA IS LARGER THAN LOCAL TRAILFILE SIZE, AFTER SERVER CRASH
Note 1163073.1 When using rmthost with timeout option, there are orphaned data collector processes on target system
Note 1266389.1 Oracle GoldenGate and compressed tables
Note 1270168.1 OGG-01028 Compression Not Supported - when extract processes regular and cluster tables
Note 1276538.1Replicat Abending With Mapping Error and discard file shows Missing Key Columns
NOTE:1276058.1 - Oracle GoldenGate Best Practices: Instantiation from an Oracle Source Database
NOTE:1276538.1 - Replicat Abending With Mapping Error and discard file shows Missing Key Columns
NOTE:1277199.1 - REPLICAT abend 'Error in COLMAP clause' but we aren't using COLMAP
NOTE:1280584.1 - Where Is The List Of Supported And Unsupported Oracle Data Types (Datatypes) for GoldenGate ?
NOTE:1199561.1 - GoldenGate Replicat Characterset Conversion: Error 160 Bad column length
NOTE:972954.1 - What Causes the GGS ERROR 160 Bad Column Index(xxxx) Error in Replicat
NOTE:987379.1 - (VERSION 10 EXTRACT ONLY) How to recover from Extract ERROR 180 encountered commit SCN that is not greater than the highest SCN already processed
NOTE:1307285.1 - Master Note Oracle GoldenGate Veridata
NOTE:1271578.1 - How to Handle Tables Without Primary Keys or Unique Indexes With Oracle GoldenGate
NOTE:969500.1 - Parameter Options After ALTARCHIVELOGDEST Entry Are Ignored
NOTE:969542.1 - Restored Archive Files To Another Location, Then Extract Failed With LOG_ARCHIVE_FORMAT Parameter Is Undefined
NOTE:966181.1 - Installing GoldenGate For Oracle RAC
NOTE:968614.1 - Why Does GoldenGate Report The Lag Is Unknown or a Timestamp Mismatch?
NOTE:968622.1 - Does GoldenGate Support Tables With An UNUSED Column?
NOTE:1112325.1 - Deploying Oracle GoldenGate to Achieve Operational Reporting for Oracle E-Business Suite
NOTE:1300936.1 - Main Master Note - Oracle GoldenGate Core Product - HP NonStop (NSK, Tandem, Guardian, S-Series)
NOTE:1159684.1 - OGG Extract abends,mss: missing trailing blocks, unable to queue I/O, I/O beyond file size
NOTE:1060547.1 - How To Set NLS_LANG When You Run GoldenGate On The Superset Character Sets Database?
NOTE:1111576.1 - Replicat Abends With ERROR 222 Missing fields in compressed record for, can not process without all fields or Colmap.
NOTE:1112506.1 - GoldenGate Extract Abends with "Unable to lock file" Error For Trail File
NOTE:1300933.1 - Main Note - Oracle GoldenGate Core Product - Open Systems
NOTE:1195995.1 - Implementing GoldenGate for in conjunction with a planned or unplanned DataGuard fail overs
NOTE:1271522.1 - Oracle GoldenGate (OGG) 11.1.1.0 and Transparent Data Encryption (TDE)
NOTE:965423.1 - Is GoldenGate Compatible Between Different Releases?
NOTE:966156.1 - Why Does Replicat Abend With ORA-01461?
NOTE:1186935.1 - GGS Error 500 Could Not Find Archived Log For Sequence
NOTE:1235992.1 - How to find Patches and Updates for Oracle GoldenGate
NOTE:969651.1 - ORA-12705: Invalid Or Unknown NLS Parameter Value Specified.
NOTE:965373.1 - Visual Representation of Oracle GoldenGate In An Oracle RAC Environment
NOTE:965356.1 - OGG GGS Error 150: No Dynamic Ports Available orphan ports server collector
NOTE:1304496.1 - Main Note - Oracle GoldenGate - Tracing
NOTE:1112406.1 - Deploying Oracle GoldenGate to Achieve Operational Reporting for Oracle JD Edwards
NOTE:1293587.1 - Searching the Patch site for a particular OGG release
NOTE:965270.1 - How does GoldenGate allocates ports between Source Extract pump and Target Server/collector?
NOTE:1270168.1 - Ogg-01028 Compression Not Supported - when extract processes regular and cluster tables
NOTE:1061093.1 - Extract fail due to an ASM connection configuration issue
NOTE:1124403.1 - When Replicat is Running but Not Applying Records
NOTE:1286276.1 - Why Isn't GoldenGate Manager Purging The Trail Files?
NOTE:1302422.1 - Column Mapping Usage - COLMAP , USEDEFAULTS
NOTE:1266389.1 - Oracle GoldenGate: Compressed tables are not supported until OGG v11.2.x Integrated Extract.
NOTE:1108953.1 - What does this message mean? "Redo thread 1: Online log /oracle/..... on sequence# 8463 has missing trailing blocks."
NOTE:1300197.1 - Logger not logging cobol transactions for GGSLIB with non default AUDCFG location
NOTE:965394.1 - Installing GoldenGate Code Into An Existing Subvolume on NSK
NOTE:1273285.1 - How To Troubleshoot Oracle Redo Log Reading Extract Slow Performance Issue using TESTMAPPINGSPEED
NOTE:1292874.1 - GoldenGate Extract/Pump/Replicat Abends on Startup with Error OGG-01088 Realloc xxx Bytes Failed.
NOTE:1232303.1 - Oracle GoldenGate Best Practice: NFS Mount options for use with GoldenGate
NOTE:1060867.1 - How To Upgrade A Single Component In GoldenGate Version 10.0
NOTE:1060870.1 - ALTARCHIVELOGDEST Oracle GoldenGate Extract
NOTE:1288562.1 - OGG Data Pumps Error With OGG-01031 When Upgrading the Target Side
NOTE:1304593.1 - Main Note - Oracle GoldenGate - RAC
NOTE:1304617.1 - Main Note - Oracle GoldenGate - Checkpoints
NOTE:966227.1 - OGG Troubleshooting TCP/IP Errors In Open Systems
NOTE:966243.1 - How Do I Use The "ALTARCHIVELOGDEST" Parameter To Access Oracle Redo Archive Logs In An Alternate Directory Path?
NOTE:1304561.1 - Main Note - Oracle GoldenGate - Documentation and References for Upgrading OGG code
NOTE:1304564.1 - Main Note - Oracle GoldenGate - Installation
NOTE:1304627.1 - Main Note - Oracle GoldenGate - ASM
NOTE:970860.1 - How to Apply Oracle GoldenGate Patches
NOTE:971825.1 - Why Does Extract For Oracle Abend With The Error Message "Mismatched Sequences In Archive Log"?
NOTE:1163073.1 - When using rmthost with timeout option, there are orphaned data collector processes on target system
NOTE:957053.1 - Recovering From a GG Pump Process Abending With An Incompatible Record Error
NOTE:957112.1 - OGG Encountered SCN That Is Not Greater Than The Highest SCN Already Processed
NOTE:1307305.1 - Master Note Oracle GoldenGate Management Pack - Director
NOTE:1298548.1 - Extract not accepting CACHESIZE settings
NOTE:1300076.1 - Usage and considerations for allocation of ports and DYNAMICPORTLIST
NOTE:1300117.1 - Master Note - OGG TCP Port Usage
NOTE:964709.1 - How To Handle Oracle DDLs (add/drop/resize a Column) When not using DDL replication?
NOTE:965230.1 - How to Find GoldenGate on edelivery.oracle.com (Oracle Software Delivery Cloud)
NOTE:968769.1 - GoldenGate Errors That Occur In Teradata Extract Setting
NOTE:1304503.1 - Main Note - Oracle GoldenGate - Supplemental Logging
NOTE:1138409.1 - OGG EXTRACT / REPLICAT CHECKPOINT RBA IS LARGER THAN LOCAL TRAIL SIZE
NOTE:1112403.1 - Deploying Oracle GoldenGate to Achieve Operational Reporting for Oracle Siebel CRM
NOTE:966207.1 - What Does The HANDLECOLLISIONS Parameter Do?
NOTE:966211.1 - How To Resync A Single Table With Minimum Impact To Other Tables' Replication?
NOTE:965745.1 - OGG How To Replicate Oracle TDE (Transparent Data Encryption) Data.
NOTE:969551.1 - How is NLS_LANG Set When You Run GoldenGate On The Superset Character Sets Database?
NOTE:1114746.1 - Deploying Oracle GoldenGate to Achieve Operational Reporting for PeopleSoft
NOTE:1304557.1 - Main Note - Oracle GoldenGate - Lag, Performance, Slow and Hung Processes
=====================================================================
Enter details of the announcement. Enter a clear description of the major issue or topic covered by the announcement. Be descriptive. It is this section that will guide the reader to decide whether the document is for him/her.
Purpose
The purpose of this GoldenGate note is to act as a quick reference to
- GoldenGate functionality
- Goldengate releases
- GoldenGate installation
- GoldenGate documentation
- Commonly researched issues
This note contains information, references and notes pertaining to the Oracle GoldenGate Core Product
Notes on other Oracle GoldenGate Products can be found at
Note 1307285.1 OGG Veridata Master Note
Note: 1307305.1 OGG Management Pack/Director Master Note
Available Community
The user may also obtain information from the GoldenGate / Streams Community as documented in Note 1388537.1.
ACTIONS
Functionality:
Oracle GoldenGate (OGG) provides near real-time transactional data replication, as well as adjunct services, in a heterogeneous computing environment. The environment can consist of one or more nodes, each running one of several operating systems supporting one or more databases of one or more vendors and versions. Replication may be uni-directional, bi-directional or multi-dimensional. Any combination of environments can be active or passive throughout the replication. Replication can involve several sources and targets simultaneously and be used for, among other things, distributing data for backup, hot standby, auditing, reporting, warehousing and load distribution (etc). Data may be replicated as is, or the replicated data may be edited, transformed, split into different distributions, have metadata added, or filtered. Both DMLs and DDLs may be replicated in whole or in part.
Oracle GoldenGate Product
The Oracle GoldenGate page on Oracle.com provides product information, data sheets, product manuals, software downloads, and Communities information regarding the Oracle GoldenGate core product and other OGG offerings.
Certification, Software Downloads, and Support Coverage
Certification
Oracle GoldenGate certification information is provided under Oracle Fusion Middleware Supported System Configurations. At this site:
- OGG v12.1.2 certification can be found in the Excel spreadsheet entitled: System Requirements and Supported Platforms for Oracle Fusion Middleware 12c (12.1.2)
- For OGG v11.1.x, search on the text string 'Oracle GoldenGate' (multiple times) to locate Excel spreadsheets for System Requirements and Supported Platforms for Oracle GoldenGate 11gR2 (and 11gR1).
OGG certification information is also available on My Oracle Support's Certifications page. Under Certification Search, enter Oracle GoldenGate for product and select desired release and platform.
Software Download
Oracle GoldenGate (core) software versions 11.2.1 and 12.1.2 are available for download from the Oracle GoldenGate Downloads webpage on Oracle.com. The complete set of Oracle GoldenGate software including versions for other databases and platforms is available at the Oracle Software Delivery Cloud (eDelivery); when prompted for the product pack, select Oracle Fusion Middleware.
Support Coverage
Oracle GoldenGate is supported under the Oracle Lifetime Support lifecycle. Refer to the Lifetime Support Policy: Oracle Fusion Middleware Products (PDF; section MASTER DATA MANAGEMENT AND DATA INTEGRATOR) for support end dates for each lifecycle stage of OGG coverage.
Please note that Oracle GoldenGate version 10.4 is no longer covered under the Premier Support stage of Oracle Lifetime Support.
Patch Set Availability
Master Note for Oracle GoldenGate 11.2.1 Patch Sets (Doc ID 1645495.1)
Documentation:
Supported Databases and Platforms:
GoldenGate 11g Overview page can be found here: Overview
There is a great deal of information available on the overview page including such Product Technical Briefs such as: (note these are topic listings, not links. The link is just above).
Zero-Downtime Database Upgrades Using Oracle GoldenGate (PDF)
Best Practices for Migrating/Upgrading Oracle Database Using Oracle GoldenGate 11g (Fujitsu / Oracle GRID Center Japan) (PDF)
Real-Time Access to Real-Time Information Technical Whitepaper (PDF)
Oracle GoldenGate High Availability using Oracle Clusterware Technical Whitepaper (PDF)
Oracle GoldenGate on Sun Oracle Database Machine (PDF)
Oracle Data Integrator Changed Data Capture with Oracle GoldenGate Data Sheet (PDF)
Best Practices for Conflict Detection and Resolution in Active-Active Database Configurations Using Oracle GoldenGate (PDF)
Oracle Active Data Guard and Oracle GoldenGate
Oracle Data Integration Solutions and the Oracle Exadata Database Machine (PDF)
Best Practices for Migrating/Upgrading Oracle Database Using Oracle GoldenGate 11g (Fujitsu / Oracle GRID Center Japan) (PDF)
Real-Time Access to Real-Time Information Technical Whitepaper (PDF)
Oracle GoldenGate High Availability using Oracle Clusterware Technical Whitepaper (PDF)
Oracle GoldenGate on Sun Oracle Database Machine (PDF)
Oracle Data Integrator Changed Data Capture with Oracle GoldenGate Data Sheet (PDF)
Best Practices for Conflict Detection and Resolution in Active-Active Database Configurations Using Oracle GoldenGate (PDF)
Oracle Active Data Guard and Oracle GoldenGate
Oracle Data Integration Solutions and the Oracle Exadata Database Machine (PDF)
NB. use the above described link to access these briefs.
Tutorials:
Various tutorials with instructions and examples for replicating between various supported databases may be found here.
Educational resources including white papers, webcasts, and podcasts are available here on Oracle.com, and here on OTN (Oracle Technology Network).
@Internal Training for v11.2:
@1) @OGG 11gR2 - Conflict Detection and Resolution@4) @OGG 11gR2 - Security, Performance, Extensibility, Manageability & Monitoring
Installation:
See Individual products notes for individual links:
Note 1304564.1 Main Note - Oracle GoldenGate - Installation
Note 965230.1 How to Find GoldenGate on edelivery.oracle.com
Note 970860.1 How To Apply Oracle GoldenGate Patches
Note 965394.1 Installing GoldenGate Code Into An Existing Subvolume
Note 1060867.1 How To Upgrade A Single Component In GoldenGate
Note 968632.1 Does OGG Support Installation Of Its Product On A Shared Disk Subsystem In A Clustered Environment?
Note 966181.1 Installing GoldenGate For Oracle RAC
Note 965230.1 How to Find GoldenGate on edelivery.oracle.com
Note 970860.1 How To Apply Oracle GoldenGate Patches
Note 965394.1 Installing GoldenGate Code Into An Existing Subvolume
Note 1060867.1 How To Upgrade A Single Component In GoldenGate
Note 968632.1 Does OGG Support Installation Of Its Product On A Shared Disk Subsystem In A Clustered Environment?
Note 966181.1 Installing GoldenGate For Oracle RAC
Upgrades:
See Individual products Notes for individual links:
Note 1304561.1 Master Note - Oracle GoldenGate - Upgrading OGG code
Note : 1235992.1 How to find Patches and Updates for Oracle GoldenGate
Note : 1293587.1 Searching the Patch site for a particular OGG release
Note : 970860.1 How To Apply Oracle GoldenGate Patches
Note 1304561.1 Master Note - Oracle GoldenGate - Upgrading OGG code
Note : 1235992.1 How to find Patches and Updates for Oracle GoldenGate
Note : 1293587.1 Searching the Patch site for a particular OGG release
Note : 970860.1 How To Apply Oracle GoldenGate Patches
Note: 1112325.1 Deploying Oracle GoldenGate to Achieve Operational Reporting for Oracle E-Business Suite
Note: 1112406.1 Deploying Oracle GoldenGate to Achieve Operational Reporting for Oracle JD Edwards
Note: 1114746.1 Deploying Oracle GoldenGate to Achieve Operational Reporting for PeopleSoft
Note: 1112403.1 Deploying Oracle GoldenGate to Achieve Operational Reporting for Oracle Siebel CRM
Note: 1112406.1 Deploying Oracle GoldenGate to Achieve Operational Reporting for Oracle JD Edwards
Note: 1114746.1 Deploying Oracle GoldenGate to Achieve Operational Reporting for PeopleSoft
Note: 1112403.1 Deploying Oracle GoldenGate to Achieve Operational Reporting for Oracle Siebel CRM
Some Best Practices
1310542.1 Oracle GoldenGate Best Practices: Instantiation from a DB2 Source Database
1310946.1 Oracle GoldenGate Best Practices: Instantiation from a SQL Server Source Database
1276058.1 Oracle GoldenGate Best Practices: Instantiation from an Oracle Source Database
1312092.1 Oracle GoldenGate Best Practices: Oracle GoldenGate Veridata – Internal only - It contains info about performing back-end loading which we don't support.
1232303.1 Oracle GoldenGate Best Practices: Mount options to use when configuring GoldenGate to run on NFS mounted file system
1313703.1 Oracle GoldenGate Best Practices: Oracle GoldenGate high availability using Oracle Clusterware
1314698.1 Oracle GoldenGate Best Practices: Creating History Tables
1321696.1 Oracle GoldenGate Best Practices: Sample Parameter Files
1322547.1 Oracle GoldenGate Best Practices: Oracle GoldenGate and Oracle Data Guard - Switchover/Fail-over Operations for GoldenGate
1310946.1 Oracle GoldenGate Best Practices: Instantiation from a SQL Server Source Database
1276058.1 Oracle GoldenGate Best Practices: Instantiation from an Oracle Source Database
1312092.1 Oracle GoldenGate Best Practices: Oracle GoldenGate Veridata – Internal only - It contains info about performing back-end loading which we don't support.
1232303.1 Oracle GoldenGate Best Practices: Mount options to use when configuring GoldenGate to run on NFS mounted file system
1313703.1 Oracle GoldenGate Best Practices: Oracle GoldenGate high availability using Oracle Clusterware
1314698.1 Oracle GoldenGate Best Practices: Creating History Tables
1321696.1 Oracle GoldenGate Best Practices: Sample Parameter Files
1322547.1 Oracle GoldenGate Best Practices: Oracle GoldenGate and Oracle Data Guard - Switchover/Fail-over Operations for GoldenGate
Compatibility
Note : 965423.1 Is GoldenGate Compatible Between Different Releases?
Note : 1300936.1 NSK Specific Main Note
Note: 266043.1 Support of Linux and Oracle Products on Linux
Note : 1300936.1 NSK Specific Main Note
Note: 266043.1 Support of Linux and Oracle Products on Linux
Performance and Tuning (LAG):
Note 1304557.1 Main Note - Oracle GoldenGate - Lag, Performance, Slow and Hung Processes
Oracle GoldenGate Performance Best Practices (pdf)
- An Oracle Maximum Availability Architecture Best Practices White Paper, March 2014
- An Oracle Maximum Availability Architecture Best Practices White Paper, March 2014
Tracing:
Note 1304496.1 Main Note - Oracle GoldenGate - Tracing
FAQ: (What People Want: or "The Top Searches")
Handlecollisions
Note 966207.1 What Does The HANDLECOLLISIONS Parameter Do
NLS_LANG
Note 969551.1 How is NLS_LANG Set When You Run OGG On The Superset Character Sets Database
Note 969651.1 ORA-12705: Invalid Or Unknown NLS Parameter Value Specified.
Note 969651.1 ORA-12705: Invalid Or Unknown NLS Parameter Value Specified.
Supplemental Logging
"Supplemental logging at the table level and the database level must be enabled for the tables from the source database."
RAC
ARCHIVE LOG Sequence
Note 1186935.1 GGS Error 500 Could Not Find Archived Log For Sequence
Note 1108953.1 What does this mean? Redo thread 1: Online log /oracle/..... on sequence# nnn has missing
Note 971825.1 Why Does Extract For Oracle Abend With Error "Mismatched Sequences In Archive Log"?
CheckPoint
Note 1304617.1 Main Note - Oracle GoldenGate - Checkpoints
Note 1138409.1 EXTRACT / REPLICAT CHECKPOINT RBA IS LARGER THAN LOCAL TRAILFILE SIZE, AFTER SERVER CRASH
Note 1138409.1 EXTRACT / REPLICAT CHECKPOINT RBA IS LARGER THAN LOCAL TRAILFILE SIZE, AFTER SERVER CRASH
TCP Port Assignment and Usage:
Note 1300117.1 Main Note - OGG Port Usage and TCP
Colmap
Note 1302422.1 Column Mapping Usage
Note 1277199.1 REPLICAT abend 'Error in COLMAP clause' but we aren't using COLMAP
Note 1111576.1 Replicat Abends With Can Not Process Without All Fields Or Colmap Error
ASM
Note 1304627.1 Main Note - Oracle GoldenGate - ASM
TDE - Transparent data Encryption
Note 965745.1 How To Replicate Oracle TDE (Transparent Data Encryption) Data.
Note 1271522.1 Oracle GoldenGate (OGG) and Transparent Data Encryption (TDE)
Note 1271522.1 Oracle GoldenGate (OGG) and Transparent Data Encryption (TDE)
ALTARCHIVELOGDEST
ALTARCHIVELOGDEST " Points Extract to the archived or backup Oracle transaction logs when they reside somewhere other than the default location. Extract first checks the specified location and then checks the default location"
Note 1060870.1 ALTARCHIVELOGDEST
Note 966243.1 How Do I Use The ALTARCHIVELOGDEST ; Parameter To Access Oracle Redo Archive Logs In An Alternate Directory?
Note 969500.1 Parameter Options After ALTARCHIVELOGDEST Entry Are Ignored
Note 969542.1 Restored Archive Files To Another Location, Then Extract Failed With LOG_ARCHIVE_FORMAT Parameter Is
Note 966243.1 How Do I Use The ALTARCHIVELOGDEST ; Parameter To Access Oracle Redo Archive Logs In An Alternate Directory?
Note 969500.1 Parameter Options After ALTARCHIVELOGDEST Entry Are Ignored
Note 969542.1 Restored Archive Files To Another Location, Then Extract Failed With LOG_ARCHIVE_FORMAT Parameter Is
Top Linked Docs:
Note 966211.1 How To Resync A Single Table With Minimum Impact To Other Tables' Replication?
Note 966227.1 Troubleshooting TCP/IP Errors In Open Systems
Note 972954.1 What Causes The 'Bad Column Index(xxxx)' Error In Replicat?
Note 987379.1 How to recover from Extract ERROR 180 encountered commit SCN that is not greater than the highest SCN already processed (GG Version 10)
Note 1112506.1 GoldenGate Extract Abends with "Unable to lock file" Error For Trail File
Note 1124403.1 When Replicat is Running but Not Applying Records
Note 1138409.1 EXTRACT / REPLICAT CHECKPOINT RBA IS LARGER THAN LOCAL TRAILFILE SIZE, AFTER SERVER CRASH
Note 1163073.1 When using rmthost with timeout option, there are orphaned data collector processes on target system
Note 1266389.1 Oracle GoldenGate and compressed tables
Note 1270168.1 OGG-01028 Compression Not Supported - when extract processes regular and cluster tables
Note 1276538.1Replicat Abending With Mapping Error and discard file shows Missing Key Columns
Note 1280584.1 Where To Find The List Of Supported And Unsupported Oracle Data Types for GoldenGate
Note 1288562.1 GG Data Pumps Error With OGG-01031 When Upgrading the Target Side
Note 957112.1 Encountered SCN That Is Not Greater Than The Highest SCN Already Processed
Note 1271578.1 How to Handle Tables without Primary Keys or Unique Indexes with Oracle GoldenGate
Note 957053.1 Recovering From a GG Pump Process Abending With An Incompatible Record Error
Note 968622.1 Does GoldenGate Support Tables With An UNUSED Column?
Note 968614.1 Why Does GoldenGate Report The Lag Is Unknown or a Timestamp Mismatch?
Note 968769.1 GoldenGate Errors That Occur In Teradata Extract Setting
Note 1163073.1 When using rmthost with timeout option, there are orphaned data collector processes on target system
Note 964709.1 How To Handle Oracle DDLs (add/drop/resize a Column) 22 19 1
Note 1300076.1 Usage and considerations for allocation of ports and DYNAMICPORTLIST
Note 1232303.1 mount options to use when configuring GoldenGate to run on NFS mounted file system
Note 1298548.1 Extract not accepting CACHESIZE settings
Note 1300197.1 Logger not logging cobol transactions for GGSLIB with non default AUDCFG location
Note 1273285.1 How To Troubleshoot Oracle Redo Log Reading Extract Slow Performance Issue
Note 957053.1 Recovering From a GG Pump Process Abending With An Incompatible Record Error
Note 968622.1 Does GoldenGate Support Tables With An UNUSED Column?
Note 968614.1 Why Does GoldenGate Report The Lag Is Unknown or a Timestamp Mismatch?
Note 968769.1 GoldenGate Errors That Occur In Teradata Extract Setting
Note 1163073.1 When using rmthost with timeout option, there are orphaned data collector processes on target system
Note 964709.1 How To Handle Oracle DDLs (add/drop/resize a Column) 22 19 1
Note 1300076.1 Usage and considerations for allocation of ports and DYNAMICPORTLIST
Note 1232303.1 mount options to use when configuring GoldenGate to run on NFS mounted file system
Note 1298548.1 Extract not accepting CACHESIZE settings
Note 1300197.1 Logger not logging cobol transactions for GGSLIB with non default AUDCFG location
Note 1273285.1 How To Troubleshoot Oracle Redo Log Reading Extract Slow Performance Issue
REFERENCES
NOTE:968632.1 - Does GoldenGate Support Installation of Its Product on a Shared Disk Subsystem in a Clustered Environment?NOTE:1276058.1 - Oracle GoldenGate Best Practices: Instantiation from an Oracle Source Database
NOTE:1276538.1 - Replicat Abending With Mapping Error and discard file shows Missing Key Columns
NOTE:1277199.1 - REPLICAT abend 'Error in COLMAP clause' but we aren't using COLMAP
NOTE:1280584.1 - Where Is The List Of Supported And Unsupported Oracle Data Types (Datatypes) for GoldenGate ?
NOTE:1199561.1 - GoldenGate Replicat Characterset Conversion: Error 160 Bad column length
NOTE:972954.1 - What Causes the GGS ERROR 160 Bad Column Index(xxxx) Error in Replicat
NOTE:987379.1 - (VERSION 10 EXTRACT ONLY) How to recover from Extract ERROR 180 encountered commit SCN
NOTE:1307285.1 - Master Note Oracle GoldenGate Veridata
NOTE:1271578.1 - How to Handle Tables Without Primary Keys or Unique Indexes With Oracle GoldenGate
NOTE:969500.1 - Parameter Options After ALTARCHIVELOGDEST Entry Are Ignored
NOTE:969542.1 - Restored Archive Files To Another Location, Then Extract Failed With LOG_ARCHIVE_FORMAT Parameter Is Undefined
NOTE:966181.1 - Installing GoldenGate For Oracle RAC
NOTE:968614.1 - Why Does GoldenGate Report The Lag Is Unknown or a Timestamp Mismatch?
NOTE:968622.1 - Does GoldenGate Support Tables With An UNUSED Column?
NOTE:1112325.1 - Deploying Oracle GoldenGate to Achieve Operational Reporting for Oracle E-Business Suite
NOTE:1300936.1 - Main Master Note - Oracle GoldenGate Core Product - HP NonStop (NSK, Tandem, Guardian, S-Series)
NOTE:1159684.1 - OGG Extract abends,mss: missing trailing blocks, unable to queue I/O, I/O beyond file size
NOTE:1060547.1 - How To Set NLS_LANG When You Run GoldenGate On The Superset Character Sets Database?
NOTE:1111576.1 - Replicat Abends With ERROR 222 Missing fields in compressed record for
NOTE:1112506.1 - GoldenGate Extract Abends with "Unable to lock file" Error For Trail File
NOTE:1300933.1 - Main Note - Oracle GoldenGate Core Product - Open Systems
NOTE:1195995.1 - Implementing GoldenGate for in conjunction with a planned or unplanned DataGuard fail overs
NOTE:1271522.1 - Oracle GoldenGate (OGG) 11.1.1.0 and Transparent Data Encryption (TDE)
NOTE:965423.1 - Is GoldenGate Compatible Between Different Releases?
NOTE:966156.1 - Why Does Replicat Abend With ORA-01461?
NOTE:1186935.1 - GGS Error 500 Could Not Find Archived Log For Sequence
NOTE:1235992.1 - How to find Patches and Updates for Oracle GoldenGate
NOTE:969651.1 - ORA-12705: Invalid Or Unknown NLS Parameter Value Specified.
NOTE:965373.1 - Visual Representation of Oracle GoldenGate In An Oracle RAC Environment
NOTE:965356.1 - OGG GGS Error 150: No Dynamic Ports Available orphan ports server collector
NOTE:1304496.1 - Main Note - Oracle GoldenGate - Tracing
NOTE:1112406.1 - Deploying Oracle GoldenGate to Achieve Operational Reporting for Oracle JD Edwards
NOTE:1293587.1 - Searching the Patch site for a particular OGG release
NOTE:965270.1 - How does GoldenGate allocates ports between Source Extract pump and Target Server/collector?
NOTE:1270168.1 - Ogg-01028 Compression Not Supported - when extract processes regular and cluster tables
NOTE:1061093.1 - Extract fail due to an ASM connection configuration issue
NOTE:1124403.1 - When Replicat is Running but Not Applying Records
NOTE:1286276.1 - Why Isn't GoldenGate Manager Purging The Trail Files?
NOTE:1302422.1 - Column Mapping Usage - COLMAP , USEDEFAULTS
NOTE:1266389.1 - Oracle GoldenGate: Compressed tables are not supported until OGG v11.2.x Integrated Extract.
NOTE:1108953.1 - What does this message mean? "Redo thread 1: Online log /oracle/..... on sequence# 8463 has missing trailing blocks."
NOTE:1300197.1 - Logger not logging cobol transactions for GGSLIB with non default AUDCFG location
NOTE:965394.1 - Installing GoldenGate Code Into An Existing Subvolume on NSK
NOTE:1273285.1 - How To Troubleshoot Oracle Redo Log Reading Extract Slow Performance Issue using TESTMAPPINGSPEED
NOTE:1292874.1 - GoldenGate Extract/Pump/Replicat Abends on Startup with Error OGG-01088 Realloc xxx Bytes Failed.
NOTE:1232303.1 - Oracle GoldenGate Best Practice: NFS Mount options for use with GoldenGate
NOTE:1060867.1 - How To Upgrade A Single Component In GoldenGate Version 10.0
NOTE:1060870.1 - ALTARCHIVELOGDEST Oracle GoldenGate Extract
NOTE:1288562.1 - OGG Data Pumps Error With OGG-01031 When Upgrading the Target Side
NOTE:1304593.1 - Main Note - Oracle GoldenGate - RAC
NOTE:1304617.1 - Main Note - Oracle GoldenGate - Checkpoints
NOTE:966227.1 - OGG Troubleshooting TCP/IP Errors In Open Systems
NOTE:966243.1 - How Do I Use The "ALTARCHIVELOGDEST" Parameter To Access Oracle Redo Archive Logs In An Alternate Directory Path?
NOTE:1304561.1 - Main Note - Oracle GoldenGate - Documentation and References for Upgrading OGG code
NOTE:1304564.1 - Main Note - Oracle GoldenGate - Installation
NOTE:1304627.1 - Main Note - Oracle GoldenGate - ASM
NOTE:970860.1 - How to Apply Oracle GoldenGate Patches
NOTE:971825.1 - Why Does Extract For Oracle Abend With The Error Message "Mismatched Sequences In Archive Log"?
NOTE:1163073.1 - When using rmthost with timeout option, there are orphaned data collector processes on target system
NOTE:957053.1 - Recovering From a GG Pump Process Abending With An Incompatible Record Error
NOTE:957112.1 - OGG Encountered SCN That Is Not Greater Than The Highest SCN Already Processed
NOTE:1307305.1 - Master Note Oracle GoldenGate Management Pack - Director
NOTE:1298548.1 - Extract not accepting CACHESIZE settings
NOTE:1300076.1 - Usage and considerations for allocation of ports and DYNAMICPORTLIST
NOTE:1300117.1 - Master Note - OGG TCP Port Usage
NOTE:964709.1 - How To Handle Oracle DDLs (add/drop/resize a Column) When not using DDL replication?
NOTE:965230.1 - How to Find GoldenGate on edelivery.oracle.com (Oracle Software Delivery Cloud)
NOTE:968769.1 - GoldenGate Errors That Occur In Teradata Extract Setting
NOTE:1304503.1 - Main Note - Oracle GoldenGate - Supplemental Logging
NOTE:1138409.1 - OGG EXTRACT / REPLICAT CHECKPOINT RBA IS LARGER THAN LOCAL TRAIL SIZE
NOTE:1112403.1 - Deploying Oracle GoldenGate to Achieve Operational Reporting for Oracle Siebel CRM
NOTE:966207.1 - What Does The HANDLECOLLISIONS Parameter Do?
NOTE:966211.1 - How To Resync A Single Table With Minimum Impact To Other Tables' Replication?
NOTE:965745.1 - OGG How To Replicate Oracle TDE (Transparent Data Encryption) Data.
NOTE:969551.1 - How is NLS_LANG Set When You Run GoldenGate On The Superset Character Sets Database?
NOTE:1114746.1 - Deploying Oracle GoldenGate to Achieve Operational Reporting for PeopleSoft
NOTE:1304557.1 - Main Note - Oracle GoldenGate - Lag, Performance, Slow and Hung Processes
interesting information. This is just the kind of information that i had been looking for, i'm already your rss reader now and i would regularly watch out for the new posts,Thanks a million once again, Regardsoracle Goldengate training in hyderabad,
ReplyDeleteSay, you got a nice article post.Really thank you! Really Great.
ReplyDeleteteradata training
oracle bpm training
angular js training
sql server dba training
oracle golden gate training