1

Topic: ORA-00445: background process "J000" did not start later 120 seconds

HELP!
Viewed http://www.sql.ru/forum/actualthread.as … ra%2000445

No... If the place, it so and  ended.
The most probable variant, without considering a bug, it is a mode  in the absence of automatic . 

At me Oracle 11.2.0.1.0 ( whether it is necessary to roll a patch till 11.2.0.2? ).
Windows 2008 r2.
More recently, on August, 26th there was  a history, the DB rose (or more correctly to write that  laid down).
DB in archivelog.
Fulfilled:

 archive log list; 

Automatic  it is included.
In alertlog the following:

 Errors in file c:\oracle\diag\rdbms\orcl\orcl\trace\orcl_cjq0_3044.trc (incident=196872):
ORA-00445: background process "J000" did not start later 120 seconds
Incident details in: c:\oracle\diag\rdbms\orcl\orcl\incident\incdir_196872\orcl_cjq0_3044_i196872.trc
Fri Aug 26 11:06:57 AM 2011
kkjcre1p: unable to spawn jobq slave process
Errors in file c:\oracle\diag\rdbms\orcl\orcl\trace\orcl_cjq0_3044.trc:
Fri Aug 26 11:06:57 AM 2011
Trace dumping is performing id = [cdmp_20110826110657]
Fri Aug 26 11:09:02 AM 2011
Errors in file c:\oracle\diag\rdbms\orcl\orcl\trace\orcl_cjq0_3044.trc (incident=196873):
ORA-00445: background process "J000" did not start later 120 seconds
Incident details in: c:\oracle\diag\rdbms\orcl\orcl\incident\incdir_196873\orcl_cjq0_3044_i196873.trc
Fri Aug 26 11:09:32 AM 2011
kkjcre1p: unable to spawn jobq slave process
Errors in file c:\oracle\diag\rdbms\orcl\orcl\trace\orcl_cjq0_3044.trc:
Fri Aug 26 11:09:32 AM 2011
Trace dumping is performing id = [cdmp_20110826110932]
Fri Aug 26 11:11:08 AM 2011
Errors in file c:\oracle\diag\rdbms\orcl\orcl\trace\orcl_mmon_2712.trc (incident=196712):
ORA-00445: background process "m000" did not start later 120 seconds
Incident details in: c:\oracle\diag\rdbms\orcl\orcl\incident\incdir_196712\orcl_mmon_2712_i196712.trc
Fri Aug 26 11:11:23 AM 2011
Trace dumping is performing id = [cdmp_20110826111123]
Fri Aug 26 11:13:13 AM 2011
Errors in file c:\oracle\diag\rdbms\orcl\orcl\trace\orcl_cjq0_3044.trc (incident=196874):
ORA-00445: background process "J000" did not start later 120 seconds
Incident details in: c:\oracle\diag\rdbms\orcl\orcl\incident\incdir_196874\orcl_cjq0_3044_i196874.trc
Fri Aug 26 11:13:40 AM 2011
Trace dumping is performing id = [cdmp_20110826111340]
Fri Aug 26 11:13:40 AM 2011
kkjcre1p: unable to spawn jobq slave process
Errors in file c:\oracle\diag\rdbms\orcl\orcl\trace\orcl_cjq0_3044.trc:
Fri Aug 26 11:15:19 AM 2011
Errors in file c:\oracle\diag\rdbms\orcl\orcl\trace\orcl_mmon_2712.trc (incident=196713):
ORA-00445: background process "m000" did not start later 120 seconds
Incident details in: c:\oracle\diag\rdbms\orcl\orcl\incident\incdir_196713\orcl_mmon_2712_i196713.trc
Fri Aug 26 11:15:20 AM 2011
Trace dumping is performing id = [cdmp_20110826111520]
Fri Aug 26 11:17:24 AM 2011
Errors in file c:\oracle\diag\rdbms\orcl\orcl\trace\orcl_cjq0_3044.trc (incident=196875):
ORA-00445: background process "J000" did not start later 120 seconds
kkjcre1p: unable to spawn jobq slave process
Errors in file c:\oracle\diag\rdbms\orcl\orcl\trace\orcl_cjq0_3044.trc:
Fri Aug 26 11:19:30 AM 2011
Errors in file c:\oracle\diag\rdbms\orcl\orcl\trace\orcl_smco_836.trc (incident=196992):
ORA-00445: background process "W000" did not start later 120 seconds
Fri Aug 26 11:21:35 AM 2011
Errors in file c:\oracle\diag\rdbms\orcl\orcl\trace\orcl_cjq0_3044.trc (incident=196876):
ORA-00445: background process "J000" did not start later 120 seconds
kkjcre1p: unable to spawn jobq slave process
Errors in file c:\oracle\diag\rdbms\orcl\orcl\trace\orcl_cjq0_3044.trc:
Fri Aug 26 11:23:13 AM 2011
Thread 1 cannot allocate new log, sequence 31514
Private strand flush not complete
Current log# 7 seq# 31513 mem# 0: C:\ORACLE\ORADATA\ORCL\REDO07.LOG
Current log# 7 seq# 31513 mem# 1: E:\ORACLE\ORADATA\ORCL\REDO07.LOG
Thread 1 advanced to log sequence 31514 (LGWR switch)
Current log# 8 seq# 31514 mem# 0: C:\ORACLE\ORADATA\ORCL\REDO08.LOG
Current log# 8 seq# 31514 mem# 1: E:\ORACLE\ORADATA\ORCL\REDO08.LOG
Fri Aug 26 11:23:17 AM 2011
Archived Log entry 30152 added for thread 1 sequence 31513 ID 0x4b55880b dest 1:
Fri Aug 26 11:23:41 AM 2011
Errors in file c:\oracle\diag\rdbms\orcl\orcl\trace\orcl_smco_836.trc (incident=196993):
ORA-00445: background process "W000" did not start later 120 seconds
Fri Aug 26 11:25:47 AM 2011
Errors in file c:\oracle\diag\rdbms\orcl\orcl\trace\orcl_cjq0_3044.trc (incident=196877):
ORA-00445: background process "J000" did not start later 120 seconds
kkjcre1p: unable to spawn jobq slave process
Errors in file c:\oracle\diag\rdbms\orcl\orcl\trace\orcl_cjq0_3044.trc:
Fri Aug 26 11:26:53 AM 2011
Thread 1 cannot allocate new log, sequence 31515
Private strand flush not complete
Current log# 8 seq# 31514 mem# 0: C:\ORACLE\ORADATA\ORCL\REDO08.LOG
Current log# 8 seq# 31514 mem# 1: E:\ORACLE\ORADATA\ORCL\REDO08.LOG
Thread 1 advanced to log sequence 31515 (LGWR switch)
Current log# 1 seq# 31515 mem# 0: C:\ORACLE\ORADATA\ORCL\REDO01.LOG
Current log# 1 seq# 31515 mem# 1: E:\ORACLE\ORADATA\ORCL\REDO01.LOG
Fri Aug 26 11:26:56 AM 2011
Archived Log entry 30153 added for thread 1 sequence 31514 ID 0x4b55880b dest 1:
Fri Aug 26 11:27:52 AM 2011
Errors in file c:\oracle\diag\rdbms\orcl\orcl\trace\orcl_smco_836.trc (incident=196994):
ORA-00445: background process "W000" did not start later 120 seconds 

In c:\oracle\diag\rdbms\orcl\orcl\trace\orcl_cjq0_3044.trc:

 Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
Waited for process J000 to initialize for 60 seconds
*** 2011-08-26 11:05:16.480
Process diagnostic dump for J000, OS id=7360
-------------------------------------------------------------------------------
Memory (Avail/Total): Ph:3925M/12278M, Ph+PgF:14654M/24556M
Stack:
------------------- Call Stack Trace---------------------
calling location entry point arg #1 arg #2 arg #3 arg #4
------------------------------------------- ------------------------------------------- ---------------- ---------------- ---------------- ----------------
0000000077BEFEFA 0000000000000000 2020202020202020 000000000a0a2020 00000000071f2fc4 0000000025a5b160
000007FEFDC510AC 0000000077BEFEF0 000000008edef808 0000000000000042 000000008edefc28 0000000000000000
sskgmfindrealm () +37 000007FEFDC51010 000000008edefb00 0000000000000000 0005000200000000 00000000000001a8
skgmattach () +261 sskgmfindrealm () 0000000000032000 0000000000159000 ffffffffffffffff ffffffffffffffff
ksmlsge_phaseone () +328 skgmattach () +253 000000004627d88c 0000000075867571 0000000046268940 000000000734a680
opimai_init () +151 ksmlsge_phaseone () 0000000000000000 0000000000000000 0000000000000000 0000000000000000
opimai_real () +247 opimai_init () 01cc63be5dd9f46e 0000000000000000 000b001a000807db 00050280000f0004
opimai () +191 opimai_real () 0000000000000000 0000000000000000 0000000000000000 0000000000000000
BackgroundThreadStart () +693 opimai () 000000008edefe58 0000000000000001 0000000000000000 0000000000000000
0000000077A9F56D BackgroundThreadStart () 000000001bc56a90 0000000000000000 0000000000000000 0000000000000000
0000000077BD3281 0000000077A9F560 0000000000000000 0000000000000000 0000000000000000 0000000000000000
---------------- End of Call Stack Trace-----------------
Call stack acquisition performance stats:
setup time (lock acquis., memory alloc.): 0 ms
frame get time (time the target proc was suspended): 109 ms
symbol translation time: 47 ms
total time: 156 ms
-------------------------------------------------------------------------------
Process diagnostic dump actual duration=0.265000 sec
(max dump time=30.000000 sec)
*** 2011-08-26 11:05:16.745
*** 2011-08-26 11:05:31.955
Waited for process J000 to initialize for 76 seconds
*** 2011-08-26 11:05:31.955
Process diagnostic dump for J000, OS id=7360
-------------------------------------------------------------------------------
Memory (Avail/Total): Ph:3935M/12278M, Ph+PgF:14663M/24556M
Stack:
------------------- Call Stack Trace---------------------
calling location entry point arg #1 arg #2 arg #3 arg #4
------------------------------------------- ------------------------------------------- ---------------- ---------------- ---------------- ----------------
0000000077BEFEFA 0000000000000000 2020202020202020 000000000a0a2020 00000000071f2fc4 0000000025a5b160
000007FEFDC510AC 0000000077BEFEF0 000000008edef808 0000000000000042 000000008edefc28 0000000000000000
sskgmfindrealm () +37 000007FEFDC51010 000000008edefb00 0000000000000000 0005000200000000 00000000000001a8
skgmattach () +261 sskgmfindrealm () 0000000000032000 0000000000159000 ffffffffffffffff ffffffffffffffff
ksmlsge_phaseone () +328 skgmattach () +253 000000004627d88c 0000000075867571 0000000046268940 000000000734a680
opimai_init () +151 ksmlsge_phaseone () 0000000000000000 0000000000000000 0000000000000000 0000000000000000
opimai_real () +247 opimai_init () 01cc63be5dd9f46e 0000000000000000 000b001a000807db 00050280000f0004
opimai () +191 opimai_real () 0000000000000000 0000000000000000 0000000000000000 0000000000000000
BackgroundThreadStart () +693 opimai () 000000008edefe58 0000000000000001 0000000000000000 0000000000000000
0000000077A9F56D BackgroundThreadStart () 000000001bc56a90 0000000000000000 0000000000000000 0000000000000000
0000000077BD3281 0000000077A9F560 0000000000000000 0000000000000000 0000000000000000 0000000000000000
---------------- End of Call Stack Trace-----------------
Call stack acquisition performance stats:
setup time (lock acquis., memory alloc.): 0 ms
frame get time (time the target proc was suspended): 32 ms
symbol translation time: 0 ms
total time: 32 ms
-------------------------------------------------------------------------------
Process diagnostic dump actual duration=0.141000 sec
(max dump time=30.000000 sec)
*** 2011-08-26 11:05:32.096
*** 2011-08-26 11:05:47.306
Waited for process J000 to initialize for 91 seconds
*** 2011-08-26 11:05:47.306
Process diagnostic dump for J000, OS id=7360
-------------------------------------------------------------------------------
Memory (Avail/Total): Ph:3934M/12278M, Ph+PgF:14659M/24556M
Stack:
------------------- Call Stack Trace---------------------
calling location entry point arg #1 arg #2 arg #3 arg #4
------------------------------------------- ------------------------------------------- ---------------- ---------------- ---------------- ----------------
0000000077BEFEFA 0000000000000000 2020202020202020 000000000a0a2020 00000000071f2fc4 0000000025a5b160
000007FEFDC510AC 0000000077BEFEF0 000000008edef808 0000000000000042 000000008edefc28 0000000000000000
sskgmfindrealm () +37 000007FEFDC51010 000000008edefb00 0000000000000000 0005000200000000 00000000000001a8
skgmattach () +261 sskgmfindrealm () 0000000000032000 0000000000159000 ffffffffffffffff ffffffffffffffff
ksmlsge_phaseone () +328 skgmattach () +253 000000004627d88c 0000000075867571 0000000046268940 000000000734a680
opimai_init () +151 ksmlsge_phaseone () 0000000000000000 0000000000000000 0000000000000000 0000000000000000
opimai_real () +247 opimai_init () 01cc63be5dd9f46e 0000000000000000 000b001a000807db 00050280000f0004
opimai () +191 opimai_real () 0000000000000000 0000000000000000 0000000000000000 0000000000000000
BackgroundThreadStart () +693 opimai () 000000008edefe58 0000000000000001 0000000000000000 0000000000000000
0000000077A9F56D BackgroundThreadStart () 000000001bc56a90 0000000000000000 0000000000000000 0000000000000000
0000000077BD3281 0000000077A9F560 0000000000000000 0000000000000000 0000000000000000 0000000000000000
---------------- End of Call Stack Trace-----------------
Call stack acquisition performance stats:
setup time (lock acquis., memory alloc.): 0 ms
frame get time (time the target proc was suspended): 31 ms
symbol translation time: 0 ms
total time: 31 ms
-------------------------------------------------------------------------------
Process diagnostic dump actual duration=0.140000 sec
(max dump time=30.000000 sec)
*** 2011-08-26 11:05:47.446
*** 2011-08-26 11:06:02.656
Waited for process J000 to initialize for 107 seconds
*** 2011-08-26 11:06:02.656
Process diagnostic dump for J000, OS id=7360
-------------------------------------------------------------------------------
Memory (Avail/Total): Ph:3929M/12278M, Ph+PgF:14656M/24556M
Stack:
------------------- Call Stack Trace---------------------
calling location entry point arg #1 arg #2 arg #3 arg #4
------------------------------------------- ------------------------------------------- ---------------- ---------------- ---------------- ----------------
0000000077BEFEFA 0000000000000000 2020202020202020 000000000a0a2020 00000000071f2fc4 0000000025a5b160
000007FEFDC510AC 0000000077BEFEF0 000000008edef808 0000000000000042 000000008edefc28 0000000000000000
sskgmfindrealm () +37 000007FEFDC51010 000000008edefb00 0000000000000000 0005000200000000 00000000000001a8
skgmattach () +261 sskgmfindrealm () 0000000000032000 0000000000159000 ffffffffffffffff ffffffffffffffff
ksmlsge_phaseone () +328 skgmattach () +253 000000004627d88c 0000000075867571 0000000046268940 000000000734a680
opimai_init () +151 ksmlsge_phaseone () 0000000000000000 0000000000000000 0000000000000000 0000000000000000
opimai_real () +247 opimai_init () 01cc63be5dd9f46e 0000000000000000 000b001a000807db 00050280000f0004
opimai () +191 opimai_real () 0000000000000000 0000000000000000 0000000000000000 0000000000000000
BackgroundThreadStart () +693 opimai () 000000008edefe58 0000000000000001 0000000000000000 0000000000000000
0000000077A9F56D BackgroundThreadStart () 000000001bc56a90 0000000000000000 0000000000000000 0000000000000000
0000000077BD3281 0000000077A9F560 0000000000000000 0000000000000000 0000000000000000 0000000000000000
---------------- End of Call Stack Trace-----------------
Call stack acquisition performance stats:
setup time (lock acquis., memory alloc.): 0 ms
frame get time (time the target proc was suspended): 32 ms
symbol translation time: 0 ms
total time: 32 ms
-------------------------------------------------------------------------------
Process diagnostic dump actual duration=0.141000 sec
(max dump time=30.000000 sec)
*** 2011-08-26 11:06:02.797
*** 2011-08-26 11:06:15.651
Killing process (ospid 7360): (reason=KSOREQ_WAIT_CANCELLED error=0)
Dump file c:\oracle\diag\rdbms\orcl\orcl\trace\orcl_cjq0_3044.trc
Fri Aug 26 11:06:21 AM 2011
ORACLE V11.2.0.1.0 - 64bit Production vsnsta=0
vsnsql=16 vsnxtr=3
*** 2011-08-26 11:06:21.143 ssthreadkillsafe: about to forcefully terminate tid=7360, dumping call stack:
------------------- Call Stack Trace---------------------
*** 2011-08-26 11:06:21.189
calling location entry point arg #1 arg #2 arg #3 arg #4
------------------------------------------- ------------------------------------------- ---------------- ---------------- ---------------- ----------------
0000000077BEFEFA 0000000000000000 0000000000000000 0000000000000009 000000002504b548 0000000000000009
000007FEFDC510AC 0000000077BEFEF0 000000008edef808 0000000000000042 000000008edefc28 0000000000000000
sskgmfindrealm () +37 000007FEFDC51010 000000008edefb00 0000000000000000 0005000200000000 00000000000001a8
skgmattach () +261 sskgmfindrealm () 0000000000032000 0000000000159000 ffffffffffffffff ffffffffffffffff
ksmlsge_phaseone () +328 skgmattach () +253 000000004627d88c 0000000075867571 0000000046268940 000000000734a680
opimai_init () +151 ksmlsge_phaseone () 0000000000000000 0000000000000000 0000000000000000 0000000000000000
opimai_real () +247 opimai_init () 01cc63be5dd9f46e 0000000000000000 000b001a000807db 00050280000f0004
opimai () +191 opimai_real () 0000000000000000 0000000000000000 0000000000000000 0000000000000000
BackgroundThreadStart () +693 opimai () 000000008edefe58 0000000000000001 0000000000000000 0000000000000000
0000000077A9F56D BackgroundThreadStart () 000000001bc56a90 0000000000000000 0000000000000000 0000000000000000
0000000077BD3281 0000000077A9F560 0000000000000000 0000000000000000 0000000000000000 0000000000000000
---------------- End of Call Stack Trace-----------------
Call stack acquisition performance stats:
setup time (lock acquis., memory alloc.): 0 ms
frame get time (time the target proc was suspended): 47 ms
symbol translation time: 0 ms
total time: 47 ms
*** 2011-08-26 11:06:21.439
Incident 196872 created, dump file: c:\oracle\diag\rdbms\orcl\orcl\incident\incdir_196872\orcl_cjq0_3044_i196872.trc
ORA-00445: background process "J000" did not start later 120 seconds
*** 2011-08-26 11:07:57.848
Waited for process J000 to initialize for 60 seconds
*** 2011-08-26 11:07:57.848
Process diagnostic dump for J000, OS id=6364
-------------------------------------------------------------------------------
Memory (Avail/Total): Ph:3913M/12278M, Ph+PgF:14629M/24556M
Stack:
------------------- Call Stack Trace---------------------
calling location entry point arg #1 arg #2 arg #3 arg #4
------------------------------------------- ------------------------------------------- ---------------- ---------------- ---------------- ----------------
0000000077BEFEFA 0000000000000000 2020202020202020 000000000a0a2020 00000000071f2fc4 0000000025a5b160
000007FEFDC510AC 0000000077BEFEF0 000000008edef808 0000000000000042 000000008edefc28 0000000000000000
sskgmfindrealm () +37 000007FEFDC51010 000000008edefb00 0000000000000000 0005000200000000 00000000000001a8
skgmattach () +261 sskgmfindrealm () 0000000000032000 0000000000159000 ffffffffffffffff ffffffffffffffff
ksmlsge_phaseone () +328 skgmattach () +253 0000000045b6bafc 0000000075867571 0000000045b56bb0 000000000734a680
opimai_init () +151 ksmlsge_phaseone () 0000000000000000 0000000000000000 0000000000000000 0000000000000000
opimai_real () +247 opimai_init () 01cc63bebe08abd6 0000000000000000 000b001a000807db 0005000700390006
opimai () +191 opimai_real () 0000000000000000 0000000000000000 0000000000000000 0000000000000000
BackgroundThreadStart () +693 opimai () 000000008edefe58 0000000000000001 0000000000000000 0000000000000000
0000000077A9F56D BackgroundThreadStart () 000000001bc56a60 0000000000000000 0000000000000000 0000000000000000
0000000077BD3281 0000000077A9F560 0000000000000000 0000000000000000 0000000000000000 0000000000000000
---------------- End of Call Stack Trace-----------------
Call stack acquisition performance stats:
setup time (lock acquis., memory alloc.): 0 ms
frame get time (time the target proc was suspended): 47 ms
symbol translation time: 0 ms
total time: 47 ms
-------------------------------------------------------------------------------
Process diagnostic dump actual duration=0.156000 sec
(max dump time=30.000000 sec)
*** 2011-08-26 11:07:58.004
*** 2011-08-26 11:08:13.214
Waited for process J000 to initialize for 76 seconds 

2

Re: ORA-00445: background process "J000" did not start later 120 seconds

Prompt as to me to be in my situation?

3

Re: ORA-00445: background process "J000" did not start later 120 seconds

I learn;
You tried a DB simply "purely" ?
That is

 SQL> shu immediate
SQL> startup 

And then

 SQL> show parameter job 

4

Re: ORA-00445: background process "J000" did not start later 120 seconds

pravednik wrote:

I learn;
You tried a DB simply "purely" ?
That is

 SQL> shu immediate
SQL> startup 

And then

 SQL> show parameter job 

Thanks for council!
On Monday it I will use.
Such problems with a copy are watched with periodicity of times in a month.
I had a thought, after your answer that problem ORA-00445: background process "J000" did not start later 120 seconds
Can be, because what that of job' ceased to be fulfilled (in connection with an error any).
Or I completely not correctly think? Simply your answer directed me on this thought.
And to view jobs which ceased to be fulfilled to us it is necessary to look at representation dba_scheduler_jobs?

5

Re: ORA-00445: background process "J000" did not start later 120 seconds

pravednik wrote:

I learn;
You tried a DB simply "purely" ?
That is

 SQL> shu immediate
SQL> startup 

And then

 SQL> show parameter job 
 job_queue_processes integer 1000