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 APRIL 03, 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.

  

Changes

 SGA size is 786 GB

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