Extract process abends when non-owning RAC instance crash (Doc ID 1538706.1)

Last updated on MAY 17, 2017

Applies to:

Oracle GoldenGate - Version 11.2.1.0.1 to 11.2.1.0.6 [Release 11.2]
Information in this document applies to any platform.

Symptoms

If you have an Oracle RAC database with 2 or more instances and any instance of the RAC  where extract is not running abruptly crash, the extract process will abend.

Sample:


Extract process is running in node/instance 1 when instance in node 5 abruptly crashed.
As a consequence of this crash extract process abended with errors :

ERROR   OGG-00665  Oracle GoldenGate Capture for Oracle, rdw_ex01.prm:  OCI Error describe for query (status = 12805-ORA-12805: parallel query server died unexpectedly), SQL<SELECT TO_CHAR(startup_time, 'YYYY-MM-DD HH24:MI:SS') FROM gv$instance WHERE inst_id = 3>.
ERROR   OGG-00665  Oracle GoldenGate Capture for Oracle, rdw_ex01.prm:  OCI Error describe for query (status = 12805-ORA-12805: parallel query server died unexpectedly), SQL<SELECT TO_CHAR(startup_time, 'YYYY-MM-DD HH24:MI:SS') FROM gv$instance WHERE inst_id = 5>.
ERROR   OGG-00665  Oracle GoldenGate Capture for Oracle, rdw_ex01.prm:  OCI Error describe for query (status = 12805-ORA-12805: parallel query server died unexpectedly), SQL<SELECT TO_CHAR(startup_time, 'YYYY-MM-DD HH24:MI:SS') FROM gv$instance WHERE inst_id = 4>.
ERROR   OGG-00665  Oracle GoldenGate Capture for Oracle, rdw_ex01.prm:  OCI Error describe for query (status = 12805-ORA-12805: parallel query server died unexpectedly), SQL<SELECT TO_CHAR(startup_time, 'YYYY-MM-DD HH24:MI:SS') FROM gv$instance WHERE inst_id = 2>.
ERROR   OGG-00665  Oracle GoldenGate Capture for Oracle, rdw_ex01.prm:  OCI Error describe for query (status = 12805-ORA-12805: parallel query server died unexpectedly), SQL<SELECT TO_CHAR(startup_time, 'YYYY-MM-DD HH24:MI:SS') FROM gv$instance WHERE inst_id = 1>.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms