Investigating Oracle errors
It is impossible to discuss every eventuality. However, should an Oracle error cause the Manager, Extract, or Replicat process to ABEND, their corresponding report files will contain the Oracle error number and message.
The following log message shows an ORA-01466 error and the corresponding error description from a failed Extract process:
2015-04-11 10:14:24 ERROR OGG-00663 Oracle GoldenGate Capture for Oracle, eload01.prm: OCI Error ORA-01466: unable to read data - table definition has changed (status = 1466), SQL <SELECT x."DEPTNO",x."DNAME",x."LOC" FROM "SRC"."DEPT" AS OF SCN 141984 x>.
This is useful in determining the root cause, but in some cases, it doesn't provide sufficient detail on how to progress the issue. Luckily, help is at hand; every Oracle Home contains an error code lookup utility, which nine times out of ten provides additional information about the error and instruction on how to fix it. The utility is oerr, which is located...
