Friday, March 4, 2016

GoldenGate ERROR OGG-06220 Classic Extract does not support multitenant container

GoldenGate Replicat Abended with "ERROR   OGG-06220"

Database Version:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
PL/SQL Release 12.1.0.2.0 - Production
CORE 12.1.0.2.0 Production
TNS for Linux: Version 12.1.0.2.0 - Production
NLSRTL Version 12.1.0.2.0 - Production
Database Language and Character Set:
NLS_LANGUAGE     = "AMERICAN" 
NLS_TERRITORY    = "AMERICA" 
NLS_CHARACTERSET = "WE8MSWIN1252" 
Source Context :
  SourceModule            : [er.redo.ora]
  SourceID                : [/scratch/aime/adestore/views/aime_adc4150408/oggcore/OpenSys/src/app/er/redo/oracle/redoora.c]
  SourceFunction          : [ce_validate_config]
  SourceLine              : [5896]
  ThreadBacktrace         : [12] elements
                          : [/u02/goldengate/12.1/libgglog.so(CMessageContext::AddThreadContext()+0x1b) [0x2abd153e40bb]]
                          : [/u02/goldengate/12.1/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x134) [0x2abd153de254]]
                          : [/u02/goldengate/12.1/libgglog.so(_MSG_ERR_CLASSIC_NOT_SUPPORT_CDB(CSourceContext*, CMessageFactory::MessageDisposition)+0x29) [0x2abd153a94e8]]
                          : [/u02/goldengate/12.1/extract(REDO_validate_config(bool, unsigned int*, bool&)+0x1339) [0x7798e9]]
                          : [/u02/goldengate/12.1/extract(ggs::er::OraTranLogDataSource::setup()+0x6c) [0x76c20c]]
                          : [/u02/goldengate/12.1/extract [0x603b76]]
                          : [/u02/goldengate/12.1/extract(ggs::gglib::MultiThreading::MainThread::ExecMain()+0x60) [0x6e05e0]]
                          : [/u02/goldengate/12.1/extract(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)+0x14d) [0x6e17cd]]
                          : [/u02/goldengate/12.1/extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**)+0xb1) [0x6e18b1]]
                          : [/u02/goldengate/12.1/extract(main+0x3b) [0x60500b]]
                          : [/lib64/libc.so.6(__libc_start_main+0xf4) [0x3aeee1d994]]
                          : [/u02/goldengate/12.1/extract [0x573069]]
2016-03-03 14:15:49  ERROR   OGG-06220  Classic Extract does not support multitenant container databases.
2016-03-03 14:15:49  ERROR   OGG-01668  PROCESS ABENDING.

Findings:
Classic Extracts are not supported on Multitenant database

Resolution: 
Delete Classic Extract and Configure Integrated Extract 

--Nikhil Tatineni--

Querys to monitor RAC

following few  Query's will help to find out culprits-  Query to check long running transaction from last 8 hours  Col Sid Fo...