ERROR OGG-01028
You will find Extract process abends with ERROR OGG-01028 Oracle GoldenGate Capture for Oracle, <extract name>.prm: error getting item for row with ROWID
Cause :
Issue raised after upgrading from OGG v11.1.1.0.17 to v11.1.1.0.26 Long running transactions are present when this issue happens A code change in the the build v11.1.1.0.17_001 causes incorrect mining of oracle logs.
ORA-01092: ORACLE instance terminated. Disconnection forced
cd $ORACLE_HOME/rdbms/admin
sqlplus "/as sysdba"
SQL>startup upgrade;
SQL> select status from v$instance;
STATUS
------------
OPEN MIGRATE
SQL>@catupgrd.sql
SQL>shutdown immediate;
SQL>startup;
SQL>@utlrp.sql
SQL> select status from v$instance;
STATUS
------------
OPEN
Golden Gate Long Running Transaction
Golden gate is reading every transaction and if any transaction is not yet commit, golden gate will waiting and will do recovery checkpoint.
You can using this command to check the recovery checkpoint.
GGS ERROR 182 OCI Error describe for query
I found this issue in OGG version 10.4.0.78
Base on SR : suspect this is the case of server timeout. Server might have unexpectedly terminated or forced to terminate.
2011-01-04 10:56:04 GGS ERROR 182 OCI Error describe for query (bad syntax) (status = 3135-ORA-03135: connection lost contact), SQL<SELECT 1 FROM DUAL WHERE EXISTS ( SELECT 'x' FROM GG_SCHEMA.GGS_DDL_HIST WHERE OPTIME < '2010-12-15 09:56:04')>.
2011-01-04 10:56:04 GGS ERROR 190 PROCESS ABENDING.
ERROR OGG-01117
2010-12-16 11:13:24 ERROR OGG-01117 Oracle GoldenGate Command Interpreter for Oracle: Received signal: Program interrupt (2).
2010-12-16 11:13:24 ERROR OGG-01668 Oracle GoldenGate Command Interpreter for Oracle: PROCESS ABENDING.
Sollution :
Please Don't CTRL + C in ggsci>
