Resolve kkjcre1p unable to spawn jobq slave processs, slot 0, error 1089 in oracle database.

by

Resolve kkjcre1p unable to spawn jobq slave process. We are facing this issue while doing shutdown oracle database.

Root Cause: –

This situation occurs while we fire “shutdown immediate”in oracle database. Continuously error message is coming in alert log file.

resolve kkjcre1p unable to spawn jobq slave process, slot 0, error 1089 in oracle database.

Error message: Linux-x86_64 Error: 23: Too many open files in system

Additional information: 1

Writing to the above trace file is disabled for now on.

Process J000 died, see its trace file

Process m001 died, see its trace file

Process m002 died, see its trace file

Process m001 died, see its trace file

Process m003 died, see its trace file

Most probably this will happen because of following reasons.

👉     If you have fired “SHUTDOWN IMMEDIATE” Command and press cntrl+C to cancel the session due to taking long time to shut it down.

Suppose database unable to shutdown and taking long time to shutdown then try as below.

Check the process id as ps –ef|grep oracle and kill the session LOCAL=YES only.

 
 
    [oracle@xxxprod ~]$ ps -ef|grep oracle

54323     5771     1  0 10:31 ?        00:00:00 oracleSAVIOR (LOCAL=NO)
54323      721     1  0 09:30 ?         00:00:06 oracleSAVIOR (LOCAL=NO)
54323     2079     1  1 09:47 ?        00:00:38 oracleSAVIOR (LOCAL=NO)
oracle    4266     1  0 Sep24 ?        00:00:13 ora_pmon_cdb1
oracle    4270     1  0 Sep24 ?        00:00:12 ora_psp0_cdb1

oracle    4274     1  0 Sep24 ?        00:00:00 ora_vktm_cdb1


oratest 31935 31930  0 09:33    00:00:27oraclePROD (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
 
$kill -9 31935
 
$ps –ef|grep oracle –àmake sure no oracle process, before start it again.
 
$sqlplus / as sysdba
 
SQL> startup;
 
OR

    👉    If you have memory issue and you are unable to start/stop the database.

Workaround:-
 
In case of memory issue, start it as force.
 
$sqlplus / as sysdba
 
SQL> startup force;
 
This will cause your database will be forcefully down and start it again. Shutdown abort will not work in this situation.
 
 
 
Other way.
 
If you are frequently getting kkjcre1p: unable to spawn jobq slave process and Linux-x86_64 Error: 23: Too many open files in system and don’t want to shutdown APPS Tier and DB Tier. Pls follow the below step to resolve this issue.
 
 
 
cd $ADMIN_SCRIPTS_HOME
 
[applmgr@***** scripts]$ sh adapcctl.sh status
 
You are running adapcctl.sh version 120.7.12010000.2
 
Checking status of OPMN managed Oracle HTTP Server (OHS) instance …
 
Processes in Instance: ACE_samarth.samarth.ace-cranes.com
———————————+——————–+———+———
ias-component                          | process-type       |     pid    | status
———————————+——————–+———+———
OC4JGroup:default_group          | OC4J:oafm          |    6632  | Alive
OC4JGroup:default_group          | OC4J:forms         |    6519  | Alive
OC4JGroup:default_group          | OC4J:oacore        |   34150 | Alive
OC4JGroup:default_group          | OC4J:oacore        |   33584 | Alive
OC4JGroup:default_group          | OC4J:oacore        |   33443 | Alive
HTTP_Server                             | HTTP_Server       |    6155  | Alive
 
 
adapcctl.sh: exiting with status 0
 
Kill the oacore pid. Automatically start , if not doing same. Need to be start it manually.
 
$ kill -9 34150 
$ kill -9 33584 
 
 
$ sh adapcctl.sh status
 
Here Status should be Alive.
 
 

16 thoughts on “Resolve kkjcre1p unable to spawn jobq slave processs, slot 0, error 1089 in oracle database.”

  8. At CIITN’s well-equipped Oracle DBA training center in Noida aspirants learn the skills for oracle database, Oracle 10g database, Oracle 11g dba management, tnsnames, database creation, table space management, oracle performance tuning, oracle dba Training on real time projects along with Oracle DBA placement training. Oracle DBA Training in Noida has been designed as per latest industry trends and keeping in mind the advanced Oracle DBA course content and syllabus based on the professional requirement of the student; helping them to get placement in Multinational companies and achieve their career goals.
    oracle training in noida
    oracle course duration and fees
    oracle training in delhi
    oracle dba course fees
    dba course syllabus
    oracle training institute in delhi
    oracle training institute in noida
    oracle dba training in noida
    oracle course in delhi
    best oracle training institute in delhi
    oracle certification in delhi
    oracle apps training in noida
    oracle institute in noida
    oracle certification in noida
    oracle training and placement
    database administrator training and placement

    Reply

  12. Big data is a term that describes the large volume of data – both structured and unstructured – that inundates a business on a day-to-day basis. big data projects for students But it’s not the amount of data that’s important.Project Center in Chennai

    Spring Framework has already made serious inroads as an integrated technology stack for building user-facing applications. Corporate TRaining Spring Framework the authors explore the idea of using Java in Big Data platforms.

    Spring Training in Chennai

    The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training

    Reply

  14. I was married at 32 and immediately tried to get pregnant. When I was unable to conceive I had blood tests for fertility and was told that I had an FSH (follicle stimulating hormone) of 54 and would not be able to have children. Even though the doctors knew that I had been diagnosed with Hashimoto’s thyroiditis since age 25, no one bothered to check my thyroid levels. my TSH was measured at .001. My Synthroid dosage was lowered. a friend advise me to contact a spiritualist who help with fertility with his medicine, i collected his contact and explain my situation to him he prepared for me a herbal medicine which i took as describe by him. became pregnant very quickly, I had a successful pregnancy. I have my baby august 2017. to get pregnant at age 35 with my 2nd child in september 2019, thank you sir , this is his email contact if you require his help [email protected] or Facebook at priest.babaka

    Reply

Leave a Comment