Oracle Goldengate

GoldenGate Installation 

https://memorydatabase2023.blogspot.com/2016/06/goldengate-installation.html


GoldenGate subdirectories 

https://memorydatabase2023.blogspot.com/2016/06/goldengate-subdirectories-usage-12c11g.html


Sample Extract, pump and Replicat GoldenGate process

https://memorydatabase2023.blogspot.com/2016/06/sample-manager-goldengate-extract-pump.html


Goldengate: Supplemental Logging

https://memorydatabase2023.blogspot.com/2015/11/goldengate-supplemental-logging.html


GoldenGate Checkpoint table 

https://memorydatabase2023.blogspot.com/2016/06/goldengate-checkpoint-table.html


12c: Oracle Goldengate wallet

https://memorydatabase2023.blogspot.com/2015/11/12c-oracle-goldengate-wallet.html


Oracle GoldenGate: General Monitoring

https://memorydatabase2023.blogspot.com/2015/11/ogg-general-monitoring.html


Oracle GoldenGate: logdump utility

https://memorydatabase2023.blogspot.com/2015/10/ogg-logdump-utility.html


Oracle GoldenGate: Defgen utility

https://memorydatabase2023.blogspot.com/2015/10/ogg-defgen-utility.html


12c: Integrated GoldenGate Extract

https://memorydatabase2023.blogspot.com/2016/02/12c-integrated-extract.html


converting classic Extract to Integrated Extract 

https://memorydatabase2023.blogspot.com/2016/06/classic-extract-to-integrated-extract.html


GoldenGate Integrated Replicat

http://www.databaseinmemory.com2016/06/goldengate-integrated-replicat-12c.html


Convert Classic Replicat to Integrated replicat 

https://memorydatabase2023.blogspot.com/2016/06/convert-classic-replicat-to-integrated.html


Obey files GoldenGate 

https://memorydatabase2023.blogspot.com/2016/06/obey-files-goldengate-11g12c.html


GoldenGate co-ordinate Replicat

https://memorydatabase2023.blogspot.com/2016/06/co-ordinated-replicat-in-12c.html


Delete Unused Process in Goldengate

https://memorydatabase2023.blogspot.com/2015/11/delete-unused-process-in-goldengate.html


GoldenGate Daily Patrol scripts on Servers

https://memorydatabase2023.blogspot.com/2016/02/goldengate-daily-patrol-scripts-on.html


Migrating Oracle database using Goldengate

https://memorydatabase2023.blogspot.com/2015/11/migrating-oracle-database-using.html


Query’s to monitor Integrated Extract#

https://memorydatabase2023.blogspot.com/2016/12/querys-used-to-monitor-goldengate.html


Keygen # GoldenGate Password Encryption

https://memorydatabase2023.blogspot.com/2016/10/media-recovery-terminated-with-error.html


Remove DDL replication # GoldenGate

https://memorydatabase2023.blogspot.com/2016/11/remove-ddl-replication-goldengate.html


What is lag in OGG ?

https://memorydatabase2023.blogspot.com/2015/10/what-is-lag-in-ogg.html


GoldenGate Extract : Bounded Recovery

https://memorydatabase2023.blogspot.com/2015/10/extract-bounded-recovery.html


Troubleshooting & Performance

Oracle GoldenGate: How to find out Transaction INFO?

https://memorydatabase2023.blogspot.com/2015/10/ogg-how-to-find-out-transaction-info.html


How to Trace Goldengate process?

https://memorydatabase2023.blogspot.com/2015/10/how-to-trace-goldengate-process.html


Goldengate replicat waiting for commit

https://memorydatabase2023.blogspot.com/2015/11/goldengate-replicat-waiting-for-commit.html


OGG:Replicat with Handlecollisions

https://memorydatabase2023.blogspot.com/2015/11/oggreplicat-with-handlecollisions.html


Adding Primary keys to table replicated by goldengate

https://memorydatabase2023.blogspot.com/2016/02/adding-primary-keys-to-tables.html


REPLICAT WITH HANDLECOLLISIONS

https://memorydatabase2023.blogspot.com/2015/01/replicat-with-handlecollisions.html


SPLITING OracleGoldenGate REPLICAT

https://memorydatabase2023.blogspot.com/2015/02/hey-guys-welcome-back.html


Goldengate Replicat is running very slow

https://memorydatabase2023.blogspot.com/2015/10/replicat-is-running-very-slow.html


Goldengate Replicat's blocking itself

https://memorydatabase2023.blogspot.com/2015/10/replicats-blocking-itself.html


Oracle GoldenGate: SKIP LONG RUNNING TRANSACTIONS

https://memorydatabase2023.blogspot.com/2015/03/ogg-skip-long-running-transactions.html


Goldengate Extract is not moving?

https://memorydatabase2023.blogspot.com/2015/02/extract-is-not-moving.html


ERROR OGG-00446  Missing filename opening checkpoint file

https://memorydatabase2023.blogspot.com/2015/08/error-ogg-00446.html


ERROR  OGG-00665  OCI Error calling OCITransRollback 

https://memorydatabase2023.blogspot.com/2015/08/error-ogg-00665.html


ERROR  OGG-01028 Incompatible record : Bad record on trail

https://memorydatabase2023.blogspot.com/2015/11/error-ogg-01028-incompatible-record-bad.html


ERROR OGG-00446: error 13 (Permission denied) 

https://memorydatabase2023.blogspot.com/2015/02/error-ogg-00446.html


ERROR OGG-01028 Formatting error on: table

https://memorydatabase2023.blogspot.com/2015/02/error-ogg-01028.html


ERROR OGG-01232 Receive TCP params error: TCP/IP error 73 

https://memorydatabase2023.blogspot.com/2015/02/error-ogg-01232_1.html


ERROR 0GG-01031 There is a problem in network communication, a remote file problem

https://memorydatabase2023.blogspot.com/2015/01/error-0gg-01031.html


ERROR OGG-00870  Database error 942 (ORA-00942: table or view does not exist SQL select..

https://memorydatabase2023.blogspot.com/2016/03/goldengate-error-ogg-00870.html


ERROR OGG-00446 Unable to lockfile 

https://memorydatabase2023.blogspot.com/2016/03/error-ogg-00446-unable-to-lock-file.html


ERROR OGG-10144 (ecbn.prm) line 6: Parameter [ASMPASSWORD] is not valid for this configuration.

https://memorydatabase2023.blogspot.com/2016/03/goldengate-error-ogg-10144.html


ERROR OGG-06220 Classic Extract does not support multitenant container 

https://memorydatabase2023.blogspot.com/2016/03/goldengate-error-ogg-06220.html


ERROR OGG-01224 Address already in use.

https://memorydatabase2023.blogspot.com/2016/03/goldengate-error-ogg-01224.html


ERROR OGG-01668 problem at line 103.  Bad column definition: PREV_VDSL_UP_RATE

https://memorydatabase2023.blogspot.com/2016/03/oracle-goldengate-error-ogg-01668.html


ERROR OGG-00665 OCI Error describe for query (status = 4031-ORA-04031 

https://memorydatabase2023.blogspot.com/2016/03/goldengate-error-ogg-00665.html


ERROR OGG-00730 No minimum supplemental logging is enabled 

https://memorydatabase2023.blogspot.com/2016/03/error-ogg-00730-no-minimum-supplemental.html


ERROR OGG-01755 Cannot register or unregister EXTRACT 

https://memorydatabase2023.blogspot.com/2016/04/error-ogg-01755-cannot-register-or.html


Replicat struck on trail # goldengate 

https://memorydatabase2023.blogspot.com/2016/11/replicat-struck-on-trail-goldengate.html


enable enable_goldengate_replication from 11.2.0.4

https://memorydatabase2023.blogspot.com/2016/10/enable-enablegoldengatereplication-from.html


ERROR OGG-01091 Unable to open file # Replicat Abended

https://memorydatabase2023.blogspot.com/2016/09/error-ogg-01091-unable-to-open-file.html


ERROR OGG-01031 There is a problem in network communication, a remote file problem

https://memorydatabase2023.blogspot.com/2016/09/error-ogg-01031-there-is-problem-in.html


ERROR OGG-00664 OCI Error during OCIServerAttach (status = 12162-ORA-12162:

https://memorydatabase2023.blogspot.com/2016/09/error-ogg-00664-oci-error-during.html


ERROR OGG-01161 Bad column index (17)

https://memorydatabase2023.blogspot.com/2016/08/error-ogg-01161-bad-column-index-17.html


---Nikhil Tatineni------ goldengate —


Querys to monitor RAC

following few  Query's will help to find out culprits-  Query to check long running transaction from last 8 hours  Col Sid Fo...