Oracle Goldengate Related Packages (DBMS_CAPTURE_ADM_INTERNAL,DBMS_CAPTURE_PROCESS) Are In Invalid State After Applying Database Patch (Doc ID 2452876.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

 GoldenGate process abended with below error.

2018-09-25 09:12:38  ERROR   OGG-02030  Failed to set logmining server parameters back to default values.

Source Context :
 SourceModule            : [ggdb.ora.ixoci]
 SourceID                : [/scratch/aime1/adestore/views/aime1_adc4150384/oggcore/OpenSys/src/gglib/ggdbora/ixoci.c]
 SourceFunction          : [IXOCI_resetParameters]
 SourceLine              : [3791]
 ThreadBacktrace         : [15] elements
                         : [/u01/app/oracle/GG/libgglog.so(CMessageContext::AddThreadContext()+0x1e) [0x7fbb068e8dce]]
                         : [/u01/app/oracle/GG/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x340) [0x7fbb068e3ae0]]
                         : [/u01/app/oracle/GG/libgglog.so(_MSG_ERR_OIX_OCI_ERROR(CSourceContext*, int, CMessageFactory::MessageDisposition)+0x2f) [0x7fbb068ba927]]
                         : [/u01/app/oracle/GG/extract(IXOCI_resetParameters(OCISESS_context_def*, ggs::gglib::ggunicode::UString const&)+0x219) [0x717f09]]
                         : [/u01/app/oracle/GG/extract(REDOORAIX_set_outbound_params()+0x9d) [0x7d2a6d]]
                         : [/u01/app/oracle/GG/extract(REDOORAIX_validate_config()+0x465) [0x7d8b05]]
                         : [/u01/app/oracle/GG/extract(REDO_validate_config(int, unsigned int*, int*)+0x1334) [0x74a754]]
                         : [/u01/app/oracle/GG/extract(redo_log_setup()+0x36) [0x5b2be6]]
                         : [/u01/app/oracle/GG/extract(extract_main(int, char**)+0x2aa) [0x5b693a]]
                         : [/u01/app/oracle/GG/extract(ggs::gglib::MultiThreading::MainThread::ExecMain()+0x4f) [0x6a1e2f]]
                         : [/u01/app/oracle/GG/extract(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)+0x104) [0x6a2334]]
                         : [/u01/app/oracle/GG/extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**)+0x8b) [0x6a26fb]]
                         : [/u01/app/oracle/GG/extract(main+0x3f) [0x5b643f]]
                         : [/lib64/libc.so.6(__libc_start_main+0xfd) [0x7fbb01fdfd1d]]
                         : [/u01/app/oracle/GG/extract() [0x52ad09]]

2018-09-25 09:12:38  ERROR   OGG-02042  OCI Error 600.

2018-09-25 09:12:38  ERROR   OGG-01668  PROCESS ABENDING.

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Upon checking the invalid objects in the DB, found two packages related to sys in INVALID state which are critical to logminer.  This is commonly caused by post patch install scripts not being run.

OBJECT_NAME                   OBJECT_TYPE     OWNER       STATUS
---------------------- ------------------- ------------ -----------------
DBMS_CAPTURE_ADM_INTERNAL     PACKAGE BODY     SYS        INVALID
DBMS_CAPTURE_PROCESS          PACKAGE BODY     SYS        INVALID

Cause

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