My Oracle Support Banner

Connected to an idle instance, while database instance is running (Process J000 died, see its trace file kkjcre1p: unable to spawn jobq slave process ) (Doc ID 1578491.1)

Last updated on AUGUST 04, 2018

Applies to:

Linux OS - Version Oracle Linux 6.0 to Oracle Linux 6.0 [Release OL6]
Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.
***Checked for relevance on 07-Aug-2017***

Symptoms

 

connecting to database says "Connected to an idle instance" while database is running.

SQL*Plus: Release 11.2.0.3.0 Production on Thu Aug 22 05:32:03 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Enter user-name: / as sysdba
Connected to an idle instance.

SQL> exit

Running any SQL or taking system statedump gives below error

ORA-01034: ORACLE not available
ORA-27123: unable to attach to shared memory segment
Linux-x86_64 Error: 22: Invalid argument

sysresv shows Instance not alive

[oracle@node2 ~]$ sysresv

IPC Resources for ORACLE_SID "DBM2" :
Shared Memory
ID              KEY
No shared memory segments used
Semaphores:
ID              KEY
2326531         0x802cd454
2359300         0x802cd455
2392069         0x802cd456
2424838         0x802cd457
2457607         0x802cd458
2490376         0x802cd459
2523145         0x802cd45a
2555914         0x802cd45b
2588683         0x802cd45c
2621452         0x802cd45d
2654221         0x802cd45e
2686990         0x802cd45f
2719759         0x802cd460
2752528         0x802cd461
2785297         0x802cd462
2818066         0x802cd463
2850835         0x802cd464
Oracle Instance not alive for sid "DBM2"

 

The database instance alert log shows processes spawn failure message.

Thu Aug 22 04:06:51 2013
Process J000 died, see its trace file
kkjcre1p: unable to spawn jobq slave process
Errors in file /u01/app/oracle/diag/rdbms/pnsp/DBM2/trace/DBM2_cjq0_25503.trc:
Process J000 died, see its trace file

  

Changes

 SGA size is 786 GB

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!


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