Multiple extract in downstream mining database for integrated capture
edited Apr 29, 2013 8:30AM in GoldenGate, Streams and Distributed Database (MOSC) 14 commentsAnswered ✓
Hi,
I configure two extract in downstream mining database for integrated capture (real time mining), extract1 and extract2.
For both i execute REGISTER DATABASE <EXTRACT_NAME>, database and thecnical configuration is exactly the same
When i execute this query on source database, i saw there's only session from EXTRACT2, why there's no session from EXTRACT1?
FPROD> select program, MODULE from gv$session where username='GGADM';
PROGRAM MODULE
------------------------------------------------ ----------------------------------------------------------------
oracle@lmwbic5d (PZ99) OGG-EXTRACT2-OCI_META_THREAD
extract@lmwbic9z (TNS V1-V3) OGG-EXTRACT2-IXAsyncTrans
extract@lmwbic9z (TNS V1-V3) OGG-EXTRACT2-GLOPEN_DATA_SOURCE
extract@lmwbic9z (TNS V1-V3) OGG-EXTRACT2-OCI_META_THREAD
I configure two extract in downstream mining database for integrated capture (real time mining), extract1 and extract2.
For both i execute REGISTER DATABASE <EXTRACT_NAME>, database and thecnical configuration is exactly the same
When i execute this query on source database, i saw there's only session from EXTRACT2, why there's no session from EXTRACT1?
FPROD> select program, MODULE from gv$session where username='GGADM';
PROGRAM MODULE
------------------------------------------------ ----------------------------------------------------------------
oracle@lmwbic5d (PZ99) OGG-EXTRACT2-OCI_META_THREAD
extract@lmwbic9z (TNS V1-V3) OGG-EXTRACT2-IXAsyncTrans
extract@lmwbic9z (TNS V1-V3) OGG-EXTRACT2-GLOPEN_DATA_SOURCE
extract@lmwbic9z (TNS V1-V3) OGG-EXTRACT2-OCI_META_THREAD
0