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