GoldenGate Extract in Build-stage Abended with errors
SourceModule : [ggparam.util]
SourceID : [/scratch/aime/adestore/views/aime_adc4150408/oggcore/OpenSys/src/gglib/ggparam/paramutil.cpp]
SourceFunction : [generate_msg]
SourceLine : [895]
ThreadBacktrace : [14] elements
: [/u02/goldengate/12.1/libgglog.so(CMessageContext::AddThreadContext()+0x1b) [0x2b3be3a620bb]]
: [/u02/goldengate/12.1/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x134) [0x2b3be3a5c254]]
: [/u02/goldengate/12.1/libgglog.so(_MSG_ERR_GGPARAM_NO_MATCH(CSourceContext*, char const*, unsigned int, char const*, CMessageFactory::M
essageDisposition)+0x41) [0x2b3be3a2056a]]
: [/u02/goldengate/12.1/libggparam.so(ggs::ggparam::error::generate_msg(unsigned long)+0xfaf) [0x2b3be2d52e27]]
: [/u02/goldengate/12.1/libggparam.so(ggs::ggparam::error::issue(bool)+0x90) [0x2b3be2d50bc0]]
: [/u02/goldengate/12.1/libggparam.so(ggs::ggparam::dict::read(ggs::ggparam::config, char const*, bool, bool, bool)+0x643) [0x2b3be2d49ce
3]]
: [/u02/goldengate/12.1/extract(get_infile_params(time_elt_def*, time_elt_def*, char**, ggs::gglib::ggdatasource::DataSourceParams&, ggs:
:Heartbeat::MapGeneratorParams&)+0x1ff) [0x5d089f]]
: [/u02/goldengate/12.1/extract [0x6038ea]]
: [/u02/goldengate/12.1/extract(ggs::gglib::MultiThreading::MainThread::ExecMain()+0x60) [0x6e05e0]]
: [/u02/goldengate/12.1/extract(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)+0x14d) [0x
6e17cd]]
: [/u02/goldengate/12.1/extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**)+0xb1) [0x6e18b1]]
: [/u02/goldengate/12.1/extract(main+0x3b) [0x60500b]]
: [/lib64/libc.so.6(__libc_start_main+0xf4) [0x3aeee1d994]]
: [/u02/goldengate/12.1/extract [0x573069]]
2016-03-03 15:16:18 ERROR OGG-10144 (ecbn.prm) line 6: Parameter [ASMPASSWORD] is not valid for this configuration.
Analysis:
When we configure Oracle GoldenGate on 12c Multitenant database. Classic capture is not loaded or supported on 12c Multitenant database. Here extracts runs integrated mode, extracts collects LCR from Log Mining server.
Extract Parameter file with Tranlogoptions
extract ecbn
SETENV (ORACLE_HOME = "/u01/app/oracle/product/12.1.0.2/db_1/")
SETENV (ORACLE_SID = “P1TNCD”)
TRANLOGOPTIONS ASMUSER ggsasm@ASM, ASMPASSWORD oracle
USERID c##gg@P1TNCD password oracle
DISCARDFILE /u02/goldengate/12.1/dirdsc/ecbn.dsc,PURGE, MEGABYTES 100
SOURCECATALOG CBN
TABLE police.persons;
Extract Parameter file After:
extract ecbn
SETENV (ORACLE_HOME = "/u01/app/oracle/product/12.1.0.2/db_1/")
SETENV (ORACLE_SID = “P1TNCD”)
USERID c##gg@P1TNCD password oracle
DISCARDFILE /u02/goldengate/12.1/dirdsc/ecbn.dsc,PURGE, MEGABYTES 100
SOURCECATALOG CBN
TABLE police.persons;
Resolution:
Removed TRANLOGOPTIONS ASMUSER param file from extract and restart it
GGSCI (tnc1.localdomain) 50> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT STARTING ECBN 00:00:08 00:00:46
--Nikhil Tatineni--
--12c GoldenGate--
