Goldengate question and answer

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 

 

 

 

 

This Note accumulates those Notes specific to the interaction of Oracle GoldenGate with the Oracle database.

 

Note 1273285.1How to troubleshoot Oracle Redo log reading

Note 1060533.1How to trace transaction from trail back to redo log

Note 1060593.1Analysis of empty supplemental log key values in trail for an Oracle update

Note 1268590.1Checking for Oracle archive log corruption

Note 1273285.1How do I troubleshoot Oracle Redo Log Reading Extract Slow Performance 

Note 1127476.1Redo Thread: error 13 (Permission denied) opening redo log

Note 1054126.1  How do I change the version compatibility to 9.2 in an Oracle Database

Note 1060581.1Why is the "select any table" privilege required for extract on an Oracle Partition table

Note 1267901.1How to configure GoldenGate extract when adding or removing redo log threads in an Oracle RAC

Note 1269274.1Why does GoldenGate require DBA/SYSDBA privileges in extract/replicat

Note 1112325.1Deploying Oracle Goldengate to achieve operational reporting for Oracle E-Business Suite

Note 1112403.1Deploying Oracle Goldengate to achieve operational reporting for Oracle Siebel CRM

Note 1112406.1Deploying Oracle Goldengate to achieve operational reporting for Oracle JD Edwards

Note 1114746.1Deploying Oracle GoldenGate to achieve operational reporting for PeopleSoft

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

Note 1298562.1Oracle GoldenGate data base complete database check script (all schemas)

Note 972950.1Why do I receive the Error "ORA-12638 Credential Retrieval Failed"

Note 1059710.1GoldenGate Extract/Replicat Error in Oracle-UNIX environment

Note 1195995.1Implementing GoldenGate for DataGuard fail overs

Note 1269855.1Oracle 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.1Oracle procedure failed with ORA-12801 and ORA-01031 only when OGG DDL trigger is enabled

Note 1280584.1Where to find the list of supported and unsupported Oracle Data Types for GoldenGate

Note 1297398.1GoldenGate - Error(904, ORA-00904:: Invalid identifier)selecting data in ORAUTIL_getCurrentSCN()

Note 972950.1Why do I receive the Error "ORA-12638 Credential Retrieval Failed"

Note 1149823.1Extract cannot read database redo (Oracle) or only (SQLServer) logs on Windows 2008 or Windows 7

Note 1206737.1Extract generates a large colume of trail data for Lob updates on Oracle

Note 1296567.1Why does extract fail with Error OGG-00665: ORA-22812

Note 1297398.1GOldenGate - Erro r(904, ORA-00904:: Invalid identifier)selecting data in ORAUTIL_getCurrentSCN()

Note 972329.1Why do I get the Error message "GG ErrorNote 972946.1Why does extract/replicat on OracleNote 972950.1Why do I receive the Error "ORA-12638 Credential Retrieval Failed"

Note 973586.1Extraction of CLOB/LOB data, when do we do a DB fetch

Note 987379.1How to recover from extract ERROR

@Note 1059890.1  Positioning extract to read from the beginning of an Oracle redo/archive log

Note 1059895.1Extract processes running in an Oracle RAC on Linux environment

@Note 1059896.1Extract abends with Oracle snapshot too old message

Note 1060553.1Extract for Oracle abends with the Error "getting Last rollback item ROWID"

@Note 1060577.1  How to enable the trace for DDL Trigger

@Note 1063375.1Use threadsNote 1108953.1What 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.1ALO extract hangs on restart an error 22 (invalid argument) occurs

Note 1206737.1Extract generates a large column of trail data for Lob updates on Oracle

Note 1211806.1OGG extract abends with" cm_obj_pop_last_item: object empty: error 116 

Note 1242965.1Reenabling a RAC thread got extract abend with "begin time prior to oldest log in log history

Note 1265785.1Extract abended with ORA-01013 when processing DDL record

Note 1267048.1Extract abends as a table is considered as compresses only when with DDL parameter

Note 1270168.1OGG-01028 Compression not supported - when extract processes regular and cluster tables

Note 1273546.1Oracle export hangs when OGG extract DDL trigger enabled

Note 1274300.1Extract abended with Error "ORA-00942:table or view does not exist, SQL< select values$ from sys.props$ where name = 'NLS_LANGUAGE'

Note 1285734.1Why extract on RAC with DDL parameter, abended on a table that is not included in the parameter list

@Note 1291330.1DBLOGREADER extract fails with this versions of ORACLE does not support DBLOGREADER

Note 972962.1How do I call an Oracle function within replicat

Note 1087305.1How 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.1ERROR 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.1How do I change the version compatibility to 9.2 in an Oracle Database

Note 1059352.1How to turn on supplemental logging at the database or the table level 

Note 1059362.1How do I determine if supplemental logging is turned ON at the database or the table level

@Note 1059412.1How to support Oracle Live Reorg

@Note 1059559.1Setting the Undo segment in Oracle

@Note 1059565.1What are the MBU and LMN records in Oracle Redo log

@Note 1059578.1Replicating Index organized tables (IOT)

Note 1059583.1When GoldenGate fetches data from the database on extraction for Oracle

Note 1060437.1Why do I get the ora-00001 when doing multi-row PK/unique_key update by single statement in Oracle

Note 1060525.1Does GolenGate support the DML statement merge

Note 1060533.1How to trace transaction from trail back to redo log

Note 1060535.1Using Oracle GoldenGate in an Oracle ASM environment when a non sys user

@Note 1060544.1Oracle GoldenGate extract configuration: Connect to Oracle ASM locally without using password

Note 1060568.1GGS Error 118 OCI error creating temp LOB

Note 1060581.1Why is the "select any table" privilege required for extract on an Oracle Partition table

Note 1060794.1How to solve an Ora-02292 error in replicat for a self-referential FK when processing multi-row deletes

Note 1060870.1ALTARCHIVELOGDEST

Note 1061093.1Extract fails with Error 118 No valid Log File for current Redo sequence xxxx thread Y

Note 1063125.1Error message ORA-20782: DDL operation Failed because Recyclebin is turned on

Note 1063389.1How to turn-off Oracle Recycle bin

Note 1081322.1Configuring Oracle GoldenGate for partitioned Replication

Note 1083886.1Can I use the @RANGE Function to split data exactly by a column value

Note 1087214.1OCI error ora-01830 in OGG replicat when using sqlexec to call a procedure

Note 1265554.1OGG DDL support of ALTER TABLE move or DBMS_REDEFINITION

Note 1280235.1Oracle 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