ORA-10388

ORA-10388 PQ Failure for Streams Apply Process During Instance Shutdown (Doc ID 1085283.1)


SYMPTOMS

Alert.log reports ORA-10388 for the Apply process at the time of instance shutdown.

Shutting down instance: further logons disabled
Thu May 7 10:06:58 2009
Stopping background process QMNC
Thu May 7 10:06:58 2009
Stopping background process CJQ0
Streams Apply Server P001 pid=29 OS id=18628 stopped
Thu May 7 10:06:58 2009
Errors in file /oracle/g01/admin/TEST/bdump/trsp101_p001_18628.trc:
ORA-10388: parallel query server interrupt (failure)
Streams Apply Reader P000 pid=28 OS id=18626 stopped
Thu May 7 10:06:58 2009
Errors in file /oracle/g01/admin/TEST/bdump/trsp101_p000_18626.trc:
ORA-10388: parallel query server interrupt (failure)
Thu May 7 10:06:58 2009
Streams APPLY A001 with pid=25, OS id=18624 stopped
Thu May 7 10:06:59 2009
Streams CAPTURE C001 with pid=33, OS id=18630 stopped

CAUSE

Issue reported in the Bug 8610234, closed as not a bug.
The ORA-10388 is not really an error. It is being used as a signal by the coordinator process to terminate the slaves as quickly as possible on shutdown immediate. We do not see the ORA-10388 errors being reported on a normal stop_apply.

So we are using the ORA-10388 to end the Apply Reader and Apply Server(s) rather than there being an underlying error which causes the ORA-10388 to be reported. The fact that we log a message in the alert.log of the form :
ORA-10388: parallel query server interrupt (failure) is just because this signal has been used.

SOLUTION

This is expected behavior and there is no way to avoid these messages.
The good news is they are not errors nor warnings, but just messages
 (like the ones reporting background processes are being stopped as per shutdown).


********************************************************************



ORA-10388 "parallel query server interrupt (failure)" Reference Note (Doc ID 2010592.1)

PURPOSE

This is a brief reference note to show the meaning of database error "ORA-10388". 
It includes the error text, "Cause" and "Action" from message files for each database version from 9.2 onwards, 
along with search links and details of any database bug issues related to the error.

SCOPE

This note is intended for general audience as a starting point to check the meaning of "ORA-10388". 
It does not give detailed information about the error and does not give error message text for versions below 9.2 .
DETAILS

Error Text, Cause and Action from Message File/s for ORA-10388

Versions 9.2, 10.1, 10.2, 11.1, 11.2, 12.1

Error:  ORA-10388 parallel query server interrupt (failure) 
---------------------------------------------------------------------------
Cause:  internal use only 

Action: this event should never be set externally *Comment: commands a slave 
to leave the server group (query failed) 


Database Bugs Related to ORA-10388

Errors are usually due to usage, application or configuration issues but in some cases they may be caused by a bug issue. This section lists any database bugs that have been linked to error "ORA-10388" .
You can restrict the list below to issues likely to affect one of the following versions 
by clicking the relevant button: 

10.2.0.2 
10.2.0.3 
10.2.0.4 
10.2.0.5
11.1.0.6 
11.1.0.7 
11.2.0.1 
11.2.0.2 
11.2.0.3 
11.2.0.4 
12.1.0.1 
12.1.0.2 
Show all Bugs 



No comments:

ORA-01552: cannot use system rollback segment for non-system tablespace 'TEMP'

 ORA-01552: cannot use system rollback segment for non-system tablespace "string" Cause: Used the system rollback segment for non...