Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Golden Gate extracts going down with ORA error

832302Mar 9 2011 — edited Jul 29 2011
Hi everyone,

My GG extracts are going down as soon as I up them with below error. I gave GGS_OWNER user DBA privilege as well for testing purpose but it did not rectify the problem. I am pasting the extract prm files and the error.

2011-03-10 11:15:56 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT EXT1 starting.
2011-03-10 11:15:57 INFO OGG-00992 Oracle GoldenGate Capture for Oracle, ext1.prm: EXTRACT EXT1 starting.
2011-03-10 11:15:57 ERROR OGG-00665 Oracle GoldenGate Capture for Oracle, ext1.prm: OCI Error describe for query (bad syntax) (status = 942-ORA-00942: table or view does not exist), SQL<SELECT db.name, i.instance_name, i.version FROM v$database db, v$instance i>.
2011-03-10 11:15:57 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, ext1.prm: PROCESS ABENDING.



2011-03-10 11:16:55 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT EXT2 starting.
2011-03-10 11:16:55 INFO OGG-00992 Oracle GoldenGate Capture for Oracle, ext2.prm: EXTRACT EXT2 starting.
2011-03-10 11:16:55 ERROR OGG-00665 Oracle GoldenGate Capture for Oracle, ext2.prm: OCI Error describe for query (bad syntax) (status = 942-ORA-00942: table or view does not exist), SQL<SELECT db.name, i.instance_name, i.version FROM v$database db, v$instance i>.
2011-03-10 11:16:55 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, ext2.prm: PROCESS ABENDING.




EXTRACT FILES:-

EXTRACT ext1
USERID ggs_owner, PASSWORD ggs_owner
EXTTRAIL /goldengate/dirdat/lt
TRANLOGOPTIONS ASMUSER sys@+ASM, ASMPASSWORD oracle
DISCARDFILE /goldengate/dirdat/capt.dsc, PURGE
RMTHOST orkxd1dmodidb01, MGRPORT 7841
TABLE SRC_FC.ch_acct_cust_xref;
TABLE SRC_FC.ci_custmast;
TABLE SRC_FC.ci_custrel;
TABLE SRC_FC.cop_applicant_details;
TABLE SRC_FC.cop_cust_changed_information;
TABLE SRC_FC.cop_applicant_state;
TABLE SRC_FC.CS_HO_CUSTACCTXREF;


EXTRACT ext2
USERID ggs_owner@DEVODI, PASSWORD ggs_owner
EXTTRAIL /goldengate/dirdat/mt
TRANLOGOPTIONS ASMUSER sys@+ASM, ASMPASSWORD oracle
DISCARDFILE /goldengate/dirdat/capt.dsc, PURGE
RMTHOST orkxd1dmodidb01, MGRPORT 7841
TABLE SRC_FC.BA_BRN_BSB_XREF;
TABLE SRC_FC.TD_PROD_MAST;
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 26 2011
Added on Mar 9 2011
7 comments
3,679 views