Unable to register or unregister golden gate extract with OCI Error 4,063.

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.