Had a trouble in registering extract in
golden gate 12c.. it’s due to invalid streams package in db
Tried below option it worked well
GGSCI> register extract XUGGTEST database
ERROR: Cannot register or unregister EXTRACT
XUGGTEST because of the following SQL error: OCI Error 4,063.
Check ggserr.log:
2018-11-20 02:11:04 INFO
OGG-02096 Oracle GoldenGate
Command Interpreter for Oracle: ERROR:
Cannot register or unregister EXTRACT XUGGTEST because of the following SQL
error: OCI Error 4,063.
Check any invalid objects in db
related to replication
SQL> select OWNER,OBJECT_NAME,OBJECT_TYPE
from dba_objects where STATUS='INVALID';
OWNER
OBJECT_NAME OBJECT_TYPE
----------------------
------------------------ -------------------
SYS
DBMS_STREAMS_ADM PACKAGE BODY
If the object is invalid, try
SQL> ALTER PACKAGE DBMS_STREAMS_ADM
COMPILE BODY;
If this error out check error
details
SQL> show error
Errors for PACKAGE BODY DBMS_STREAMS_ADM:
LINE/COL ERROR
--------
-----------------------------------------------------------------
3408/30
PL/SQL: Item ignored
3408/30
PLS-00201: identifier 'SYS.STREAMS$TRANSFORMATION_INFO' must be
declared
3496/5
PL/SQL: Statement ignored
3496/5
PLS-00320: the declaration of the type of this expression is
incomplete or malformed
Run below scripts and verify
invalid details
SQL> @catalog.sql
SQL> @catproc.sql
SQL> @utlrp.sql
SQL> select OWNER,OBJECT_NAME,OBJECT_TYPE
from dba_objects where STATUS='INVALID';
no rows selected
Now try to register extract ,it
works well
GGSCI>
dblogin USERID ggs_admin, PASSWORD ggs_ggtest
Successfully logged into database.
GGSCI> register extract XUGGTEST database
Extract XUGGTEST successfully registered with
database at SCN 1190892.