Tuesday, November 29, 2016

OGG-01755 Cannot register or unregister EXTRACT error

GGSCI (javed-pc) 5> DBLOGIN USERID ggadmin PASSWORD oracle
Successfully logged into database.

GGSCI (javed-pc) 6> REGISTER EXTRACT ext1 DATABASE

ERROR   OGG-01755  Cannot register or unregister EXTRACT EXT1 because of the following SQL error: OCI Error 26,947. See Extract user privileges in the Oracle GoldenGate for Oracle Installation and Setup Guide.

You need to use OGG enable_goldengate_replication parameter is set to TRUE

SQL> show parameter enable_goldengate_replication

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
enable_goldengate_replication        boolean     FALSE

SQL> alter system set enable_goldengate_replication=true;
System altered.

GGSCI (javed-pc) 10> REGISTER EXTRACT ext1 DATABASE

INFO    OGG-02003  Extract EXT1 successfully registered with database at SCN 5336396.