Добро пожаловать в форум, Guest  >>   Войти | Регистрация | Поиск | Правила | В избранное | Подписаться
Все форумы / Oracle Новый топик    Ответить
 ORA-00445: фоновый процесс "J000" не стартовал спустя 120 секунд  [new]
учу
Guest
HELP!

просмотрел https://www.sql.ru/forum/actualthread.aspx?tid=545117&hl=ora%2000445

нет...если бы закончилось место, то оно так бы и ругнулось.
Наиболее вероятный вариант, не считая бага, это режим архивлог при отсутствии автоматического архивирования. 

У меня Oracle 11.2.0.1.0 (не надо ли накатить патч до 11.2.0.2?).
Windows 2008 r2.

Совсем недавно, 26 августа случилась принеприятнейшая история, БД встала (или правильнее написать, что инстанс лёг).
БД в archivelog.

выполнил:
archive log list;
автоматическое архивирование включено.


в alertlog следующее:

Errors in file c:\oracle\diag\rdbms\orcl\orcl\trace\orcl_cjq0_3044.trc  (incident=196872):
ORA-00445: фоновый процесс "J000" не стартовал спустя 120 секунд
Incident details in: c:\oracle\diag\rdbms\orcl\orcl\incident\incdir_196872\orcl_cjq0_3044_i196872.trc
Fri Aug 26 11:06:57 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 2011
Trace dumping is performing id=[cdmp_20110826110657]
Fri Aug 26 11:09:02 2011
Errors in file c:\oracle\diag\rdbms\orcl\orcl\trace\orcl_cjq0_3044.trc  (incident=196873):
ORA-00445: фоновый процесс "J000" не стартовал спустя 120 секунд
Incident details in: c:\oracle\diag\rdbms\orcl\orcl\incident\incdir_196873\orcl_cjq0_3044_i196873.trc
Fri Aug 26 11:09:32 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 2011
Trace dumping is performing id=[cdmp_20110826110932]
Fri Aug 26 11:11:08 2011
Errors in file c:\oracle\diag\rdbms\orcl\orcl\trace\orcl_mmon_2712.trc  (incident=196712):
ORA-00445: фоновый процесс "m000" не стартовал спустя 120 секунд
Incident details in: c:\oracle\diag\rdbms\orcl\orcl\incident\incdir_196712\orcl_mmon_2712_i196712.trc
Fri Aug 26 11:11:23 2011
Trace dumping is performing id=[cdmp_20110826111123]
Fri Aug 26 11:13:13 2011
Errors in file c:\oracle\diag\rdbms\orcl\orcl\trace\orcl_cjq0_3044.trc  (incident=196874):
ORA-00445: фоновый процесс "J000" не стартовал спустя 120 секунд
Incident details in: c:\oracle\diag\rdbms\orcl\orcl\incident\incdir_196874\orcl_cjq0_3044_i196874.trc
Fri Aug 26 11:13:40 2011
Trace dumping is performing id=[cdmp_20110826111340]
Fri Aug 26 11:13:40 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 2011
Errors in file c:\oracle\diag\rdbms\orcl\orcl\trace\orcl_mmon_2712.trc  (incident=196713):
ORA-00445: фоновый процесс "m000" не стартовал спустя 120 секунд
Incident details in: c:\oracle\diag\rdbms\orcl\orcl\incident\incdir_196713\orcl_mmon_2712_i196713.trc
Fri Aug 26 11:15:20 2011
Trace dumping is performing id=[cdmp_20110826111520]
Fri Aug 26 11:17:24 2011
Errors in file c:\oracle\diag\rdbms\orcl\orcl\trace\orcl_cjq0_3044.trc  (incident=196875):
ORA-00445: фоновый процесс "J000" не стартовал спустя 120 секунд
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 2011
Errors in file c:\oracle\diag\rdbms\orcl\orcl\trace\orcl_smco_836.trc  (incident=196992):
ORA-00445: фоновый процесс "W000" не стартовал спустя 120 секунд
Fri Aug 26 11:21:35 2011
Errors in file c:\oracle\diag\rdbms\orcl\orcl\trace\orcl_cjq0_3044.trc  (incident=196876):
ORA-00445: фоновый процесс "J000" не стартовал спустя 120 секунд
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 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 2011
Archived Log entry 30152 added for thread 1 sequence 31513 ID 0x4b55880b dest 1:
Fri Aug 26 11:23:41 2011
Errors in file c:\oracle\diag\rdbms\orcl\orcl\trace\orcl_smco_836.trc  (incident=196993):
ORA-00445: фоновый процесс "W000" не стартовал спустя 120 секунд
Fri Aug 26 11:25:47 2011
Errors in file c:\oracle\diag\rdbms\orcl\orcl\trace\orcl_cjq0_3044.trc  (incident=196877):
ORA-00445: фоновый процесс "J000" не стартовал спустя 120 секунд
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 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 2011
Archived Log entry 30153 added for thread 1 sequence 31514 ID 0x4b55880b dest 1:
Fri Aug 26 11:27:52 2011
Errors in file c:\oracle\diag\rdbms\orcl\orcl\trace\orcl_smco_836.trc  (incident=196994):
ORA-00445: фоновый процесс "W000" не стартовал спустя 120 секунд

в 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 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: фоновый процесс "J000" не стартовал спустя 120 секунд


*** 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 сен 11, 15:08    [11218956]     Ответить | Цитировать Сообщить модератору
 Re: ORA-00445: фоновый процесс "J000" не стартовал спустя 120 секунд  [new]
учу
Guest
подскажите как мне быть в моей ситуации?
2 сен 11, 19:48    [11220865]     Ответить | Цитировать Сообщить модератору
 Re: ORA-00445: фоновый процесс "J000" не стартовал спустя 120 секунд  [new]
pravednik
Member

Откуда: Jacksonville, FL
Сообщений: 16268
учу,

вы пробовали БД просто "чисто" ребутнуть?
То есть
SQL> shu immediate
SQL> startup

а потом
SQL> show parameter job
2 сен 11, 22:40    [11221611]     Ответить | Цитировать Сообщить модератору
 Re: ORA-00445: фоновый процесс "J000" не стартовал спустя 120 секунд  [new]
учу
Guest
pravednik
учу,

вы пробовали БД просто "чисто" ребутнуть?
То есть
SQL> shu immediate
SQL> startup

а потом
SQL> show parameter job


спасибо за совет!
В понедельник им воспользуюсь.
Такие проблемы с экземпляром наблюдаются с периодичностью раз в месяц.

У меня возникла мысль, после вашего ответа, что проблема ORA-00445: фоновый процесс "J000" не стартовал спустя 120 секунд
может быть, потому что какие то из job'ов перестали выполняться ( в связи с ошибкой какой-нибудь).

или я совсем не правильно думаю? просто ваш ответ навёл меня на эту мысль.
А чтобы просмотреть задания, которые перестали выполняться нам надо посмотреть представление dba_scheduler_jobs?
2 сен 11, 23:09    [11221729]     Ответить | Цитировать Сообщить модератору
 Re: ORA-00445: фоновый процесс "J000" не стартовал спустя 120 секунд  [new]
учу
Guest
pravednik
учу,

вы пробовали БД просто "чисто" ребутнуть?
То есть
SQL> shu immediate
SQL> startup

а потом
SQL> show parameter job



job_queue_processes  integer  1000  
5 сен 11, 11:36    [11227088]     Ответить | Цитировать Сообщить модератору
Все форумы / Oracle Ответить