troubleshooting Question

unable to spawn jobq slave process

Avatar of geotiger
geotiger asked on
Unix OSOracle Database
4 Comments2 Solutions12276 ViewsLast Modified:
I got the following errors in my alert log file:

Tue Oct 23 11:31:08 2007
Thread 1 advanced to log sequence 1136
  Current log# 1 seq# 1136 mem# 0: /opt/ora/oradata/owbprod/redo01.log
Tue Oct 23 11:41:42 2007
Process J001 died, see its trace file
Tue Oct 23 11:41:42 2007
kkjcre1p: unable to spawn jobq slave process
Tue Oct 23 11:41:42 2007
Errors in file /opt/ora/admin/owbprod/bdump/owbprod_cjq0_26396.trc:

And here is the content of the trace file:
 # more /opt/ora/admin/owbprod/bdump/owbprod_cjq0_26396.trc
Oracle Database 10g Enterprise Edition Release - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /opt/ora/product/10.2.0/db_1
System name:    SunOS
Node name:      ors2ws
Release:        5.10
Version:        Generic_118833-36
Machine:        sun4u
Instance name: owbprod
Redo thread mounted by this instance: 1
Oracle process number: 4
Unix process pid: 26396, image: oracle@ors2ws (CJQ0)

*** SERVICE NAME:(SYS$BACKGROUND) 2007-10-23 11:41:42.686
*** SESSION ID:(84.1) 2007-10-23 11:41:42.686
*** 2007-10-23 11:41:42.686
Process J001 is dead (pid=15757, state=3):


Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros