ERROR OGG-01264 The call to the cm_param_set() function from line 378 in cm_sp_init_common() returned an unexpected value.

2016-11-30 18:25:47 INFO OGG-01851 filecaching started: thread ID: 140714592524032.

2016-11-30 18:25:47 WARNING OGG-01262 The call to the ggDirIsWritable() function from line 2673 in cm_cachedir_add() failed with reason 'The directory /u01/goldengate/data
/mydb/cache to hold temporary cachefiles does not exist or is not writable'.

2016-11-30 18:25:47 WARNING OGG-01278 cm_param_dir: cm_memdir_add: /u01/goldengate/data/mydb/cache size: default.

2016-11-30 18:25:47 WARNING OGG-01276 cm_param_arg: BAD DIRECTORY PARAMETER: CACHEDIRECTORY /u01/goldengate/data/mydb/cache.

2016-11-30 18:25:47 WARNING OGG-01271 cm_param_parse: Bad Parameter Argument: CACHEDIRECTORY /u01/goldengate/data/mydb/cache.

2016-11-30 18:25:47 WARNING OGG-01270 cm_param_set: Bad Parameter: CACHEMGR CACHEDIRECTORY /u01/goldengate/data/mydb/cache.

Source Context :
 SourceModule : [ggapp.cachemgr]
 SourceID : [/scratch/aime/adestore/views/aime_adc4150408/oggcore/OpenSys/src/gglib/ggapp/cachemgr/cmgr_restore.c]
 SourceFunction : [cm_sp_init_common]
 SourceLine : [378]
 ThreadBacktrace : [12] elements
 : [/u01/goldengate/oracle/OGG/libgglog.so(CMessageContext::AddThreadContext()+0x1b) [0x7ffac1709f1b]]
 : [/u01/goldengate/oracle/OGG/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x134) [0x7ffac17040a4]]
 : [/u01/goldengate/oracle/OGG/libgglog.so(_MSG_ERR_CACHEOBJ_FUNCTION_FAILED(CSourceContext*, char const*, CMessageFactory::MessageDispos
ition)+0x30) [0x7ffac16e5d6e]]
 : [/u01/goldengate/oracle/OGG/extract() [0x6a189d]]
 : [/u01/goldengate/oracle/OGG/extract(CM_cache_init(pool_info*, char const*, extract_vals*)+0x58) [0x6a2718]]
 : [/u01/goldengate/oracle/OGG/extract() [0x5f3a5a]]
 : [/u01/goldengate/oracle/OGG/extract(ggs::gglib::MultiThreading::MainThread::ExecMain()+0x60) [0x6d05b0]]
 : [/u01/goldengate/oracle/OGG/extract(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)+0x1
4d) [0x6d179d]]
 : [/u01/goldengate/oracle/OGG/extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**)+0xb1) [0x6d1881]]
 : [/u01/goldengate/oracle/OGG/extract(main+0x3b) [0x5f50eb]]
 : [/lib64/libc.so.6(__libc_start_main+0xfd) [0x3409a1ed1d]]
 : [/u01/goldengate/oracle/OGG/extract() [0x563159]]

2016-11-30 18:25:47 ERROR OGG-01264 The call to the cm_param_set() function from line 378 in cm_sp_init_common() returned an unexpected value.

2016-11-30 18:25:47 ERROR OGG-01668 PROCESS ABENDING.

Create the mising directory for Cache and restart the process

[gguser@newhost01 OGG] $ pwd
/u01/goldengate/oracle/OGG
[gguser@newhost01 OGG] $ mkdir -p /u01/goldengate/data/mydb/cache

#abending, #cache, #cachedirectory, #cachefiles, #cachemgr, #cm_param_set, #extract, #goldengate, #ogg-01264, #pump, #replicat

ERROR OGG-02077 Extract encountered a read error in the asynchronous reader thread and is abending: Error code 3113, error message: ORA-03113: end-of-file on communication channel

Integrated Extracts are often abending with the error “ERROR   OGG-02077  Extract encountered a read error in the asynchronous reader thread and is abending: Error code 3113, error message: ORA-03113: end-of-file on communication channel”.

Simply restarting the extract process worked.

Will update this post after further research..

#3133, #apply, #asynchronous, #cature, #channel, #communication, #end, #end-of-file, #error, #extract, #file, #ggsci, #goldengate, #integrated, #integrated-apply, #integrated-capture, #ogg, #ogg-02077, #ora-03113, #oracle, #oracle-goldengate, #pump, #replicat

OGG-00303 Invalid version found in DEFGEN file: 5.0.

Recently came across an issue with the replicats abending with  when the source system Goldengate version is 12.2.0.1.1 whereas the target Goldengate version is 12.1.2.1.2.

OGG-00303  Invalid version found in DEFGEN file: 5.0.
OGG-01668  PROCESS ABENDING.

The source Goldengate version is higher than the target Goldengate version. The DEFGEN file created on 12.2 version cannot be interpreted by 12.1 version of Goldengate. In this situation, create the DEFSFILE using FORMAT RELEASE to specify the version of target Goldengate.

DEFSFILE ./dirdef/dnfsd.def, PURGE, FORMAT RELEASE 12.1
USERID ggadm@testdb, PASSWORD ******
TABLE SAMPLE.MYTABLE;

Refer to Oracle Support (Doc ID 2155977.1) for more information.

#00303, #12-1, #12-2, #5-0, #defgen, #extract, #file, #format, #found, #ggsci, #goldengate, #invalid, #ogg, #ogg-00303, #oracle-goldengate, #pump, #release, #replicat, #version

DBLOGIN – OGG-01117 Received signal: Segmentation violation (11) / Memory fault(coredump)

Encountered “OGG-01117  Received signal: Segmentation violation (11)” when trying to login into database from GGSCI.

Figured out this is because my ORACLE_HOME and LD_LIBRARY_PATH are not set appropriately.

#coredump, #dblogin, #fault, #ggsci, #goldengate, #ld_library_path, #memory, #memory-faultcoredump, #ogg-01117, #oracle, #oracle-goldengate, #password, #received-signal-segmentation-violation