My Oracle Support Banner

Missing Log File <unknown> Read Position SCN 0 - ORA-600 Internal Error Code Arguments [17183] (Doc ID 1615826.1)

Last updated on JUNE 26, 2018

Applies to:

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

Goal

Using GoldenGate 12c from a pluggable database to another PDB, I encounter those errors when I restart my extract:

 2014-01-14 12:07:36 ERROR OGG-00868 Oracle GoldenGate Capture for Oracle, captapp.prm: Error code 1291, error message: ORA-01291: missing logfile (Missing Log File . Read Position SCN 0).

2014-01-14 12:07:36 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, captapp.prm: PROCESS ABENDING.
2014-01-14 12:07:42 ERROR OGG-00664 Oracle GoldenGate Capture for Oracle, captapp.prm: OCI Error end oci session (status = 600-ORA-00600: internal error code, arguments: [17183], [0x7FAEE73EFD78], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [729], [27280], [space leak], [], [], [], [], [], [], [], [], []).
2014-01-14 12:07:42 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, captapp.prm: PROCESS ABENDING.


In ggserr.log, we get:

2014-01-14 12:04:28 INFO OGG-06495 OGG created a session pool with SESSIONPOOLMAX 10, SESSIONPOOLMIN 2 and SESSIONPOOLINCR 2.
2014-01-14 12:04:28 WARNING OGG-01423 No valid default archive log destination directory found for thread 1.
2014-01-14 12:04:29 INFO OGG-02089 Source redo compatibility version is: 12.1.0.0.
2014-01-14 12:04:35 WARNING OGG-02045 Database does not have streams_pool_size initialization parameter configured.

Source Context :
 SourceModule : [er.redo.oraxo]
 SourceID : [/scratch/aime1/adestore/views/aime1_adc4150472/oggcore/OpenSys/src/app/er/redo/oracle/redooraix.c]
 SourceFunction : [REDOORAIX_abend_if_missing_logfile]
 SourceLine : [8206]
 ThreadBacktrace : [15] elements
  : [/app/oggsource/libgglog.so(CMessageContext::AddThreadContext()+0x1e) [0x7f601e18f7ee]]
  : [/app/oggsource/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x321) [0x7f601e18ab11]]
  : [/app/oggsource/libgglog.so(_MSG_ERR_DB_GENERIC_FAILURE(CSourceContext*, char const*, CMessageFactory::MessageDisposition)+0x31) [0x7f601e171c81]]
  : [/app/oggsource/extract(REDOORAIX_abend_if_missing_logfile(char*)+0x1b9) [0x7c3d37]]
  : [/app/oggsource/extract(REDOORAIX_attach(ggs::gglib::ggunicode::UString&, int, char (&) [2048])+0x274) [0x7b8864]]
  : [/app/oggsource/extract(REDOORAIX_validate_config()+0x4e9) [0x7bc4d9]]
  : [/app/oggsource/extract(REDO_validate_config(int, unsigned int*, int*)+0xfab) [0x72988b]]
  : [/app/oggsource/extract(redo_log_setup()+0x36) [0x5b5a56]]
  : [/app/oggsource/extract(extract_main(int, char**)+0x29e) [0x5b8ffe]]
  : [/app/oggsource/extract(ggs::gglib::MultiThreading::MainThread::ExecMain()+0x6f) [0x692c0f]]
  : [/app/oggsource/extract(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)+0x11a) [0x690a0a]]
  : [/app/oggsource/extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**)+0x128) [0x691978]]
  : [/app/oggsource/extract(main+0x3f) [0x5b8b0f]]
  : [/lib64/libc.so.6(__libc_start_main+0xfd) [0x3b2461ecdd]]
  : [/app/oggsource/extract() [0x526289]]

2014-01-14 12:07:36 ERROR OGG-00868 Error code 1291, error message: ORA-01291: missing logfile
(Missing Log File . Read Position SCN 0).

2014-01-14 12:07:36 ERROR OGG-01668 PROCESS ABENDING.

Source Context :
 SourceModule : [ggdb.ora.sess]
 SourceID : [/scratch/aime1/adestore/views/aime1_adc4150472/oggcore/OpenSys/src/gglib/ggdbora/ocisess.c]
 SourceFunction : [oci_try]
 SourceLine : [800]
 ThreadBacktrace : [29] elements
  : [/app/oggsource/libgglog.so(CMessageContext::AddThreadContext()+0x1e) [0x7f601e18f7ee]]
  : [/app/oggsource/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x321) [0x7f601e18ab11]]
  : [/app/oggsource/libgglog.so(_MSG_ERR_ORACLE_OCI_ERROR_WITH_DESC(CSourceContext*, int, char const*, char const*, CMessageFactory::MessageDisposition)+0x41) [0x7f601e17426b]]
  : [/app/oggsource/extract(OCISESS_context_def::oci_try(int, char const*, ...)+0x4e2) [0x6dd822]]
  : [/app/oggsource/extract(OCISESS_context_def::logoff()+0x3f) [0x6d9dbf]]
  : [/app/oggsource/extract(IXOCI_logoff()+0x9c) [0x6fd86c]]
  : [/app/oggsource/extract(REDOORAIX_logoff()+0x13) [0x7b9d73]]
  : [/app/oggsource/extract(REDOORAIX_detach()+0x77) [0x7bb877]]


How to solve?
 

Solution

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.