I’m currently working on integrating Oracle GoldenGate Classic (OGG Classic) with Oracle 19c and SG-KMS and I’ve run into a few issues during the initial setup phase. Here are some specifics:
Environment:
Oracle Database: 19c
GoldenGate Version: OGG Classic
OS: Linux
Problems Encountered:
During the initial extract process, I’m facing frequent disconnections.
The replicat process seems to be lagging and not applying changes in real-time.
Encountered error: OGG-02091: Operation not supported when logged into the Oracle database as SYSDBA.
Steps Taken:
Verified that the Oracle database is in ARCHIVELOG mode.
Ensured that the necessary supplemental logging is enabled.
Checked that the GoldenGate user has the required privileges.
Has anyone faced similar issues with OGG Classic and Oracle 19c? How did you resolve them?
Are there any specific configurations or settings I should check to ensure stable connectivity and real-time replication?
What are the best practices for setting up GoldenGate on Oracle 19c to avoid these issues?
Any insights or suggestions would be greatly appreciated. Thanks in advance!
Extract process log shows frequent TCP/IP connection lost messages.
Replicat process log indicates checkpoint failures.
Error stack for OGG-02091 indicates issues with SYSDBA login.
jaeyu is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.