Most Common Goldengate Errors and Issues

QUESTIONS AND ANSWERS

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

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
comment the following until it is republished

Note: 965356.1 GGS Error 150: No Dynamic Ports Available

Note: 1199561.1 Characterset Conversion: Error 160 Bad column length

Note: 1159684.1 Extract abends,mss: missing trailing blocks, unable to queue I/O, I/O beyond file size

Note: 1292874.1 GoldenGate Extract Abends on Startup with Error OGG-01088 Realloc xxx Bytes Failed.

Note: 1271522.1 Oracle GoldenGate (OGG) 11.1>>> .1>>> .0 and Transparent Data Encryption (TDE)

Note: 965270.1 How does the Manager Allocate TCPIP Ports?

Note: 1195995.1 Implementing GoldenGate for DataGuard fail overs

Note: 965373.1 Installing And Configuring GoldenGate In An Oracle RAC Environment

Note: 1276058.1 Oracle GoldenGate Best Practices: Instantiation from an Oracle Source Database

Note: 971264.1 How To Upgrade GGS Objects In A DDL Replication Environment

REFERENCES

NOTE:1298548.1 - Extract not accepting CACHESIZE settings
NOTE:1300076.1 - Usage and considerations for allocation of ports and DYNAMICPORTLIST
NOTE:1300197.1 - Logger not logging cobol transactions for GGSLIB with non default AUDCFG location
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 - OGG EXTRACT / REPLICAT CHECKPOINT RBA IS LARGER THAN LOCAL TRAIL SIZE
NOTE:966227.1 - OGG Troubleshooting TCP/IP Errors In Open Systems
NOTE:1276538.1 - Replicat Abending With Mapping Error and discard file shows Missing Key Columns
NOTE:1280584.1 - Where Is The List Of Supported And Unsupported Oracle Data Types (Datatypes) for GoldenGate ?
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:1292874.1 - GoldenGate Extract/Pump/Replicat Abends on Startup with Error OGG-01088 Realloc xxx Bytes Failed.
NOTE:965270.1 - How does GoldenGate allocates ports between Source Extract pump and Target Server/collector?
NOTE:965356.1 - OGG GGS Error 150: No Dynamic Ports Available orphan ports server collector
NOTE:965373.1 - Visual Representation of Oracle GoldenGate In An Oracle RAC Environment
NOTE:966211.1 - How To Resync A Single Table With Minimum Impact To Other Tables' Replication?
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) When not using DDL replication?
NOTE:1159684.1 - OGG Extract abends,mss: missing trailing blocks, unable to queue I/O, I/O beyond file size
NOTE:1163073.1 - When using rmthost with timeout option, there are orphaned data collector processes on target system
NOTE:1195995.1 - Implementing GoldenGate for in conjunction with a planned or unplanned DataGuard fail overs
NOTE:1199561.1 - GoldenGate Replicat Characterset Conversion: Error 160 Bad column length
NOTE:1232303.1 - Oracle GoldenGate Best Practice: NFS Mount options for use with 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:1271522.1 - Oracle GoldenGate (OGG) 11.1.1.0 and Transparent Data Encryption (TDE)
NOTE:1271578.1 - How to Handle Tables Without Primary Keys or Unique Indexes With Oracle GoldenGate
NOTE:1273285.1 - How To Troubleshoot Oracle Redo Log Reading Extract Slow Performance Issue using TESTMAPPINGSPEED
NOTE:1276058.1 - Oracle GoldenGate Best Practices: Instantiation from an Oracle Source Database
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:968769.1 - GoldenGate Errors That Occur In Teradata Extract Setting
NOTE:971264.1 - How to Upgrade Oracle GoldenGate Objects in a DDL Replication Environment?
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