"OGG-08221 Cannot register or unregister EXTRACT because of the following SQL error: OCI Error 1031" When HOSTNAME is > 48 Bytes

(Doc ID 2420982.1)

Last updated on JULY 12, 2018

Applies to:

Oracle GoldenGate - Version 12.2.0.1.0 and later
Information in this document applies to any platform.

Symptoms

Oracle GoldenGate Command Interpreter for Oracle
Version 12.2.0.1.170221 25896313_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Apr 18 2017 03:08:51

Source database is Oracle EE 11.2.0.4 running in an AWS RDS-Oracle instance.


GGSCI (awe-sid-gg-hub-test-02.ver-raj-internal.ggs.int.com) 3> register extract TESTEXT database

2018-06-07 09:06:34  ERROR   OGG-08221  Cannot register or unregister EXTRACT TESTEXT because of the following SQL error: OCI Error ORA (status = 1031-ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_XSTREAM_GG_INTERNAL", line 94
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 93
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 124
ORA-06512: at line 1

 

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms