Today My Integrated Replicat abended with error ERROR OGG-00870
Source Context :
SourceModule : [iroci]
SourceID : [/scratch/aime/adestore/views/aime_adc4150408/oggcore/OpenSys/src/gglib/ggdbora/iroci.cpp]
SourceFunction : [IROCI_init_context]
SourceLine : [991]
ThreadBacktrace : [11] elements
: [/u02/goldengate/12.1/libgglog.so(CMessageContext::AddThreadContext()+0x1b) [0x2b7de91740bb]]
: [/u02/goldengate/12.1/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x134) [0x2b7de916e254]]
: [/u02/goldengate/12.1/libgglog.so(_MSG_ERR_DB_SQL_ERROR(CSourceContext*, int, char const*, CMessageFactory::MessageDisposition)+0x3a) [0x2b7de9155cc7]]
: [/u02/goldengate/12.1/replicat(IROCI_init_context(OCISESS_context_def*, int*, int*, unsigned int, char const*)+0x1ae5) [0x75e0a5]]
: [/u02/goldengate/12.1/replicat [0x63193d]]
: [/u02/goldengate/12.1/replicat(ggs::gglib::MultiThreading::MainThread::ExecMain()+0x60) [0x6e9e10]]
: [/u02/goldengate/12.1/replicat(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)+0x14d) [0x6ead9d]]
: [/u02/goldengate/12.1/replicat(ggs::gglib::MultiThreading::MainThread::Run(int, char**)+0xb1) [0x6eae81]]
: [/u02/goldengate/12.1/replicat(main+0x3b) [0x634a5b]]
: [/lib64/libc.so.6(__libc_start_main+0xf4) [0x3aeee1d994]]
: [/u02/goldengate/12.1/replicat [0x56b119]]
2016-03-04 00:47:08 ERROR OGG-00870 Database error 942 (ORA-00942: table or view does not exist SQL select apply# from sys."_DBA_APPLY" where apply_name = :1).
2016-03-04 00:47:08 ERROR OGG-01668 PROCESS ABENDING.
Actions:
Connected to the CDB$ROOT database and alter the session to Pluggable database "CBN" and granted data dictionary privileges to goldengate user "c##gg"
[oracle@tnc2 12.1]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Mar 4 00:48:39 2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options
SQL> alter session set container=cbn;
Session altered.
SQL> grant select on sys.props$ to c##gg;
Grant succeeded.
SQL> grant select any dictionary to c##gg;
Grant succeeded.
After Replicat came-up automatically
GGSCI (tnc1.localdomain) 21> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING ECBN 00:00:07 00:00:09
REPLICAT RUNNING RCBN 00:00:00 00:00:23
--Nikhil Tatineni--
--12c GoldenGate
