CASE:DBshutdown/open过程中发生异常导致JOB不能自动执行(二)

2014-11-24 15:34:30 · 作者: · 浏览: 3
-05-07 09:12:19.739
Received ORADEBUG command 'unlimit' from process Unix process pid: 30143, image:
Received ORADEBUG command 'event 10046 trace name context forever,level 12' from process Unix process pid: 30143, image:
WAIT #0: nam='rdbms ipc message' ela= 23719 timeout=237 p2=0 p3=0 obj#=-1 tim=1335829238050367
WAIT #0: nam='rdbms ipc message' ela= 2295845 timeout=235 p2=0 p3=0 obj#=-1 tim=1335829240346359
WAIT #0: nam='rdbms ipc message' ela= 2930432 timeout=300 p2=0 p3=0 obj#=-1 tim=1335829243276873
Received ORADEBUG command 'tracefile_name' from process Unix process pid: 30143, image:
WAIT #0: nam='rdbms ipc message' ela= 1843426 timeout=300 p2=0 p3=0 obj#=-1 tim=1335829245120391
WAIT #0: nam='rdbms ipc message' ela= 1084937 timeout=111 p2=0 p3=0 obj#=-1 tim=1335829246205459
*** 2013-05-07 09:12:31.115
WAIT #0: nam='rdbms ipc message' ela= 2930461 timeout=300 p2=0 p3=0 obj#=-1 tim=1335829249136013
WAIT #0: nam='rdbms ipc message' ela= 2930386 timeout=300 p2=0 p3=0 obj#=-1 tim=1335829252066575
WAIT #0: nam='rdbms ipc message' ela= 2930460 timeout=300 p2=0 p3=0 obj#=-1 tim=1335829254997126
WAIT #0: nam='rdbms ipc message' ela= 2931251 timeout=300 p2=0 p3=0 obj#=-1 tim=1335829257928469

并作了system dump:

=== ODM Data Collection ===

PROCESS 13:
----------------------------------------
SO: 0x1f218b2f0, type: 2, owner: (nil), flag: INIT/-/-/0x00
(process) Oracle pid=13, calls cur/top: 0x1f62141c0/0x1f62141c0, flag: (2) SYSTEM
int error: 0, call error: 0, sess error: 0, txn error 0
(post info) last post received: 0 0 33
last post received-location: ksrpublish
last process to post me: 1f41b0ab0 224 0
last post sent: 0 0 48
last post sent-location: ksoreq_reply
last process posted by me: 1fe1dc698 1 0
(latch info) wait_event=0 bits=0
Process Group: DEFAULT, pseudo proc: 0x1f31ae220
O/S info: user: oracle, term: UNKNOWN, ospid: 11984
OSD pid info: Unix process pid: 11984, image: oracle@IMG_PIDB (CJQ0)
Short stack dump: ksdxfstk()+32<-ksdxcb()+1547<-sspuser()+90<-<0x3d0180eb10>

----------------------------------------
SO: 0x1f220f3b8, type: 4, owner: 0x1f218b2f0, flag: INIT/-/-/0x00
(session) sid: 544 trans: (nil), creator: 0x1f218b2f0, flag: (51) USR/- BSY/-/-/-/-/-
DID: 0000-0000-00000000, short-term DID: 0000-0000-00000000
txn branch: (nil)
oct: 0, prv: 0, sql: (nil), psql: (nil), user: 0/SYS
waiting for 'rdbms ipc message' blocking sess=0x(nil) seq=47 wait_time=0 seconds since wait started=0
timeout=39, =0, =0
Dumping Session Wait History
for 'rdbms ipc message' count=1 wait_time=2373861
timeout=12c, =0, =0
for 'rdbms ipc message' count=1 wait_time=2930517
timeout=12c, =0, =0
for 'rdbms ipc message' count=1 wait_time=2930558
timeout=12c, =0, =0
for 'rdbms ipc message' count=1 wait_time=2930496
timeout=12c, =0, =0
for 'rdbms ipc message' count=1 wait_time=2930497
timeout=12c, =0, =0
for 'rdbms ipc message' count=1 wait_time=2930666
timeout=12c, =0, =0
for 'rdbms ipc message' count=1 wait_time=2930559
timeout=12c, =0, =0
for 'rdbms ipc message' count=1 wait_time=2931411
timeout=12c, =0, =0
for 'rdbms ipc message' count=1 wait_time=2930440
timeout=12c, =0, =0
for 'rdbms ipc message' count=1 wait_time=2930679
timeout=12c, =0, =0
temporary object counter: 0

还是没有一丝线索。
Step6,查看Metalink上是否有相关的BUG或者案例(搜索job start)。
Note = Jobs Not Executing Automatically [ID 313102.1]
==>
11) Check for unsuccessful shutdowns:

A shutdown immediate may get canceled because acti