Golden Gate extracts going down with ORA error
832302Mar 9 2011 — edited Jul 29 2011Hi 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;