Root Cause: –
This situation occurs while we fire “shutdown immediate”in oracle database. Continuously error message are coming in alert log file.
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 happened 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.
[[email protected] ~]$ 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
👉 If you have memory issue and you are unable to start/stop the database.
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.
If your 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.
[[email protected]***** 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 process, slot 0, error 1089 in oracle database.”
Usually I never comment on blogs but your article is so convincing that I never stop myself to say something about it. This paragraph gives clear idea for the new viewers of blogging, Thanks you. You’re doing a great job Man, Keep it up.
Oracle Training in Noida
Thank you for your valuable comment.
Thanks for your information,nice blog.Oracle DBA Training in Hyderabad
Nice information thank you
SQL DBA Training in Hyderabad
Thank you for sharing this Blog, It includes very well information.
iphone job Oriented course
Mobile App Training Institutes
Thanks for sharing Good Information
Sql server DBA Online Course
It's so nice article thank you for sharing a valuable content. SQL server dba Online Training Bangalore
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
Thanks For sharing a nice post about Oracle DBA Training Course.It is very helpful and Oracle DBA useful for us.Oracle DBA Training in Bangalore
Very nice information, it is valuable and useful to so many people. It gives the beautiful knowledge especially to the technical people.
oracle training institutes in bangalore
oracle training in bangalore
best oracle training institutes in bangalore
oracle training course content
oracle training interview questions
oracle training & placement in bangalore
oracle training center in bangalore
شركة نقل عفش بحائل
شركة تنظيف منازل وفلل بحائل
شركة رش مبيدات بحائل
شركة عزل خزانات بحائل
شركة تنظيف بحائل
شركة تنظيف مجالس بحائل
شركة نقل اثاث بحائل
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
Thank you for taking the time and sharing this information with us. It was indeed very helpful and insightful while being straight forward and to the point.
Data Science Training in Gurgaon
Bigdata Hadoop Training in Gurgaon
Spark Training in Gurgaon
Machine Learning Training in Gurgaon
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
Awesome informative blog ,Very good information thanks for sharing such wonderful blog with us after long time came across such knowledgeble blog. keep sharing such informative blog with us.
SQL Server DBA Training in Bangalore
nice post.oracle dba training
oracle dba online training