I`ve tried to start two Extract. One is started and works. But when I try start one more Extract I get error:
2020-04-06T15:27:30.549+0300 ERROR OGG-02615 Oracle GoldenGate Capture for Oracle, e_rf.prm: Login to the database as user GGADMINSRC failed because of error ORA-12549: TNS:operating system resource quota exceeded.
2020-04-06T15:27:30.550+0300 ERROR OGG-00664 Oracle GoldenGate Capture for Oracle, e_rf.prm: OCI Error ORA (status = 12549-ORA-12549: TNS:operating system resource quota exceeded
).
2020-04-06T15:27:30.561+0300 ERROR OGG-02078 Oracle GoldenGate Capture for Oracle, e_rf.prm: Extract encountered a fatal error in a processing thread and is abending.
2020-04-06T15:27:30.561+0300 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, e_rf.prm: PROCESS ABENDING.
***********************************************************************
** Run Time Messages **
***********************************************************************
Source Context :
SourceModule : [ggdb.ora.OraConnUtil]
SourceID : [../gglib/ggdbora/OraConnUtil.cpp]
SourceMethod : [initConnectionLogon]
SourceLine : [179]
ThreadBacktrace : [10] elements
: [/u02/oracle/golden_gate19/libgglog.so(CMessageContext::AddThreadContext())]
: [/u02/oracle/golden_gate19/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...))]
: [/u02/oracle/golden_gate19/libgglog.so(_MSG_LoginName_String(CSourceContext*, int, ggs::gglib::ggapp::CDBObjName<(DBObjType)11> const&, char const*, CMessageFactory::MessageDisposition))]
: [/u02/oracle/golden_gate19/extract()]
: [/u02/oracle/golden_gate19/extract(IXFormatter::initSourceDBConnection(ggs::gglib::ggocicpp::ORAConnection**))]
: [/u02/oracle/golden_gate19/extract(IXFormatter::initTLS())]
: [/u02/oracle/golden_gate19/extract(IXFormatter::FormatterThread(void*))]
: [/u02/oracle/golden_gate19/extract(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*))]
: [/lib64/libpthread.so.0()]
: [/lib64/libc.so.6(clone)]
2020-04-06 17:58:06 ERROR OGG-02615 Login to the database as user ***** failed because of error ORA-12549: TNS:operating system resource quota exceeded.
Source Context :
SourceModule : [ggdb.ora.ocicpp.err]
SourceID : [ggdbora/ocicpp/OCIErrorHandler.cpp]
SourceMethod : [dpiErr]
SourceLine : [121]
ThreadBacktrace : [15] elements
: [/u02/oracle/golden_gate19/libgglog.so(CMessageContext::AddThreadContext())]
: [/u02/oracle/golden_gate19/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...))]
: [/u02/oracle/golden_gate19/libgglog.so(_MSG_Int32_String_String(CSourceContext*, int, int, char const*, char const*, CMessageFactory::MessageDisposition))]
: [/u02/oracle/golden_gate19/extract(ggs::gglib::ggocicpp::OCIErrorHandler::dpiErr(dpi::Exception&) const)]
: [/u02/oracle/golden_gate19/extract(ggs::gglib::ggocicpp::OCIConnection::connect(ggs::gglib::ggdbconnection::DBConnectionParams const&))]
: [/u02/oracle/golden_gate19/extract(ggs::gglib::ggocicpp::OCIEnvironment::createConnection(ggs::gglib::ggdbconnection::DBConnectionParams const&))]
: [/u02/oracle/golden_gate19/extract(ggs::gglib::ggocicpp::ORAConnection::initConn(ggs::gglib::ggdbconnection::DBConnectionParams const&, ULibCharSet, ULibCharSet))]
: [/u02/oracle/golden_gate19/extract(ggs::gglib::ggocicpp::ORAConnection::createConnection(ggs::gglib::ggdbconnection::DBConnectionParams const&, ULibCharSet, ULibCharSet))]
: [/u02/oracle/golden_gate19/extract(ggs::gglib::ggdbora::OraConnUtil::initConnectionLogon(ggs::gglib::ggdbconnection::DBConnectionParams&, ggs::gglib::ggocicpp::ORAConnection**))]
: [/u02/oracle/golden_gate19/extract(IXFormatter::initSourceDBConnection(ggs::gglib::ggocicpp::ORAConnection**))]
: [/u02/oracle/golden_gate19/extract(IXFormatter::initTLS())]
: [/u02/oracle/golden_gate19/extract(IXFormatter::FormatterThread(void*))]
: [/u02/oracle/golden_gate19/extract(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*))]
: [/lib64/libpthread.so.0()]
: [/lib64/libc.so.6(clone)]
2020-04-06 17:58:06 ERROR OGG-00664 OCI Error ORA (status = 12549-ORA-12549: TNS:operating system resource quota exceeded
).
Source Context :
SourceModule : [er.redo.ora.IXFormatter]
SourceID : [er/redo/oracle/IXFormatter.cpp]
SourceMethod : [getResult]
SourceLine : [761]
ThreadBacktrace : [15] elements
: [/u02/oracle/golden_gate19/libgglog.so(CMessageContext::AddThreadContext())]
: [/u02/oracle/golden_gate19/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...))]
: [/u02/oracle/golden_gate19/libgglog.so(_MSG_(CSourceContext*, int, CMessageFactory::MessageDisposition))]
: [/u02/oracle/golden_gate19/extract()]
: [/u02/oracle/golden_gate19/extract(RedoIE::readLCR(ggs::gglib::gglcr::CommonLCR**, long&, bool&))]
: [/u02/oracle/golden_gate19/extract(ggs::er::OraTranLogDataSource::readLCR(ggs::gglib::gglcr::CommonLCR**, long&, bool&))]
: [/u02/oracle/golden_gate19/extract(ggs::er::ExtractContext::processExtractLoop())]
: [/u02/oracle/golden_gate19/extract(ggs::er::ExtractContext::run())]
: [/u02/oracle/golden_gate19/extract()]
: [/u02/oracle/golden_gate19/extract(ggs::gglib::MultiThreading::MainThread::ExecMain())]
: [/u02/oracle/golden_gate19/extract(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*))]
: [/u02/oracle/golden_gate19/extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**))]
: [/u02/oracle/golden_gate19/extract(main)]
: [/lib64/libc.so.6(__libc_start_main)]
: [/u02/oracle/golden_gate19/extract()]
2020-04-06 17:58:06 ERROR OGG-02078 Extract encountered a fatal error in a processing thread and is abending.
What resources do I need to add?