My Oracle Support Banner

Dbms_defer_sys.push Receiving ORA-12805 Errors (Doc ID 1301626.1)

Last updated on MARCH 07, 2011

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.2.0.1 - Release: 10.2 to 11.2
Information in this document applies to any platform.

Symptoms

You may see sometimes Oracle logging error ORA-12805 either in the alert log file or RDBMS background process job trace (j00n) for the Advanced Replication push call (DBMS_DEFER_SYS.PUSH).

Alert log will show something like this:

Thu Jun 17 08:51:14 2010
Errors in file <path>/<sid>_j000_19461.trc:
ORA-12805: parallel query server died unexpectedly
Errors in file <path>/<sid>_j000_19461.trc:

ORA-12012: error on auto execute of job 23
ORA-12805: parallel query server died unexpectedly
ORA-06512: at "SYS.DBMS_DEFER_SYS", line 1717
ORA-06512: at "SYS.DBMS_DEFER_SYS", line 1805
ORA-06512: at line 1

While j00n trace will have something similar to this:

----- Error Stack Dump -----
ORA-12805: parallel query server died unexpectedly
----- Current SQL Statement for this session (sql_id=0rdfzjvxzjs46) -----
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN declare rc binary_integer; begin rc := sys.dbms_defer_sys.push(destination=>'dest', stop_on_error=>FALSE, delay_seconds=>0, parallelism=>3); end; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
3a7678998 493 package body SYS.DBMS_ASYNCRPC_PUSH
3a7678998 677 package body SYS.DBMS_ASYNCRPC_PUSH
3a76a2f10 1686 package body SYS.DBMS_DEFER_SYS
3a76a2f10 1805 package body SYS.DBMS_DEFER_SYS
3a76a6fb0 1 anonymous block

----- Call Stack Trace -----
kxfpqidqr
kxfpssg
kxfpqsod_qc_sod
kxfpqsod
knpc_pricd
...

Changes

No changes, only the fact of using Advanced Replication push job feature might trigger the ORA-12805.

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
  Symptoms
  Changes
  Cause
  Solution
  References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.