"Timed out trying to start process Jxxx" In The ALERT.LOG Followed By ORA-12012, ORA-04031 (Doc ID 469181.1)

Last updated on MARCH 01, 2017

Applies to:

Oracle Server - Enterprise Edition - Version 9.2.0.5 to 10.2.0.3 [Release 9.2 to 10.2]
Information in this document applies to any platform.
This problem can occur on any platform.
** Checked for relevance on 23-Jul-2012 **

Symptoms

The database hangs, and the following errors are reported in the alert.log:


Wed Nov 21 19:29:40 2007
Timed out trying to start process J028.
Wed Nov 21 19:31:46 2007
Timed out trying to start process J028.
Wed Nov 21 19:33:57 2007
Timed out trying to start process J028.
Wed Nov 21 19:36:03 2007
Timed out trying to start process J028.


and finally the jobs fails with the following error.

Errors in file /oracle_NVTP/rdbms/log/nvtp_ora_14120.trc:
ORA-12012: error on auto execute of job 21116
ORA-04031: unable to allocate 54136 bytes of shared memory ("shared pool","CC_EM



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