Book Image

Oracle Goldengate 12c Implementers Guide

By : John P Jeffries
Book Image

Oracle Goldengate 12c Implementers Guide

By: John P Jeffries

Overview of this book

The book is aimed at Oracle database administrators, project managers, and solution architects who wish to extend their knowledge of GoldenGate. The reader is assumed to be familiar with Oracle databases. No knowledge of GoldenGate is required.
Table of Contents (16 chapters)
12
A. GGSCI Commands
13
B. GoldenGate Installed Components
14
C. Acronyms
15
Index

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...