Skip to Main Content
  • Questions
  • GoldenGate 19c error - ORA-12549: TNS:operating system resource quota exceeded

Breadcrumb

May 4th

Question and Answer

Chris Saxon

Thanks for the question, Veronika.

Asked: April 07, 2020 - 5:17 am UTC

Last updated: April 07, 2020 - 10:19 am UTC

Version: 19 Standart Edition

Viewed 1000+ times

You Asked

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?

and Chris said...

ORA-12549: TNS:operating system resource quota exceeded.

You're blowing out some of your operating system's limits!

Check you've met the installation requirements in the docs and set kernel parameters appropriately.

Assuming these are good, work with you sysadmin to ensure that there's enough memory, swap space, etc. to run this.

Is this answer out of date? If it is, please let us know via a Comment

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database