GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

goldengate errors with trandata

edited Mar 3, 2016 4:06AM in GoldenGate, Streams and Distributed Database (MOSC) 3 commentsAnswered
when we add schematrandata using goldenagte to configure database to log table key values for schemas we are seeing the below errors

ADD SCHEMATRANDATA testuser

output on 10.2.0.5 database on AIX 5.3

2013-08-28 12:39:39 ERROR OGG-01783 Cannot verify existence of table function that is required to enable schema level supplemental logging, failed to find function.

output  on 11.2.0.3 database on AIX 6.1

2013-08-28 16:53:39 ERROR OGG-01790 Failed to ADD SCHEMATRANDATA on schema testuser 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('RARRA','ALLKEYS_ON'); END;.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center