>> >>Scenario # Tried to enable supplemental logging at schema level on 11.2.0.4 database triggered with following error << <<
GGSCI (dg1.localdomain) 2> dblogin userid ggsuser password oracle
Successfully logged into database.
GGSCI (dg1.localdomain as ggsuser@DB11G) 3> add schematrandata oxford
ERROR: Operation not supported because enable_goldengate_replication is not set to true.
Resolution # logged into the database, enabled parameter
SQL> alter system set enable_goldengate_replication=true scope=both;
System altered.
* Note > If you are upgrading database to 11.2.0.4. make sure you enable parameter "enable_goldengate_replication=true" to support goldengate replication
>> >> again it's failed with error >
GGSCI (dg1.localdomain as ggsuser@DB11G) 3> add schematrandata oxford
2016-10-10 12:50:38 ERROR OGG-01790 Failed to ADD SCHEMATRANDATA on schema oxford because of the following SQL error: ORA-06550: line 1, column 7:
PLS-00201: identifier 'SYS.DBMS_CAPTURE_ADM' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored SQL BEGIN sys.dbms_capture_adm.PREPARE_SCHEMA_INSTANTIATION('oxford','ALLKEYS_ON'); END;.
Root cause: ggsuser doesn't have enough privileges to run package
Resolution: logged into the database, grant dba to ggsuser during installation
sql> grant dba to ggsuser;
>>>>
Nikhil Tatineni--
Oracle DBA --
