My Oracle Support Banner

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 OCTOBER 08, 2018

Applies to:

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

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

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
Symptoms
Cause
Solution
 Goal


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