Goldengate Extract abend with OGG-00662 OCI Error get session (status = 1)

(Doc ID 2389484.1)

Last updated on APRIL 25, 2018

Applies to:

Oracle GoldenGate - Version 12.2.0.1.0 and later
Information in this document applies to any platform.

Symptoms

Golden Gate extract was abended with below error :

 

2018-03-27 12:03:42  INFO    OGG-06495  OGG created a session pool with SESSIONPOOLMAX 10, SESSIONPOOLMIN 2 and SESSIONPOOLINCR 2.

Source Context :
 SourceModule            : [ggdb.ora.sesspool]
 SourceID                : [/scratch/aime/adestore/views/aime_adc4150408/oggcore/OpenSys/src/gglib/ggdbora/ocisesspool.cpp]
 SourceFunction          : [execute]
 SourceLine              : [523]
 ThreadBacktrace         : [16] elements
                         : [/oracle/app/ggs/libgglog.so(CMessageContext::AddThreadContext()+0x1b) [0x7fd0461170bb]]
                         : [/oracle/app/ggs/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x134) [0x7fd046111254]]
                         : [/oracle/app/ggs/libgglog.so(_MSG_ERR_ORACLE_OCI_ERROR(CSourceContext*, int, char const*, CMessageFactory::MessageDisposition)+0x3a) [0x7fd0460fc1e7]]
                         : [/oracle/app/ggs/extract(TryOCI::execute(int, OCIError*, ULibCharSet, char const*, ...)+0x339) [0x734839]]
                         : [/oracle/app/ggs/extract(OCISESSPOOL_context_def::getSPoolSession(ggs::gglib::ggapp::CDBObjName<(DBObjType)8> const&)+0x31e) [0x734f62]]
                         : [/oracle/app/ggs/extract(OCISESS_context_def::getInstance(ggs::gglib::ggapp::CDBObjName<(DBObjType)8> const*, bool, bool)+0x464) [0x732ae4]]
                         : [/oracle/app/ggs/extract(DBOCI_prepare_file_query(file_def*, int)+0x26) [0x6f8797]]
                         : [/oracle/app/ggs/extract(gl_prepare_query(file_def*)+0x17) [0x729190]]
                         : [/oracle/app/ggs/extract(ggs::er::DatabaseDataSource::processSourceTables()+0x518) [0x5fe6e8]]
                         : [/oracle/app/ggs/extract() [0x603d24]]
                         : [/oracle/app/ggs/extract(ggs::gglib::MultiThreading::MainThread::ExecMain()+0x60) [0x6e05e0]]
                         : [/oracle/app/ggs/extract(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)+0x14d) [0x6e17cd]]
                         : [/oracle/app/ggs/extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**)+0xb1) [0x6e18b1]]
                         : [/oracle/app/ggs/extract(main+0x3b) [0x60500b]]
                         : [/lib64/libc.so.6(__libc_start_main+0xf5) [0x7fd03de27b35]]
                         : [/oracle/app/ggs/extract() [0x573069]]

2018-03-27 12:03:42  ERROR   OGG-00662  OCI Error get session (status = 1).

2018-03-27 12:03:42  ERROR   OGG-01668  PROCESS ABENDING.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms