ORA-00445: 后台进程 "J000" 在 120 秒之后仍没有启动

futian_187 2015-08-18 08:54:48
windows server2008 系统,ORACLE版本11.2.0.2.0,中间件weblogic10。问题原因:隔一段时间数据库就会宕机,重启机器或者服务能解决,以下为报错详细信息,请各路大神帮忙解决啊。
Dump file D:\APP\ORACLE\diag\rdbms\nsdb\nsdb\incident\incdir_344545\nsdb_cjq0_5724_i344545.trc
Oracle Database 11g Release 11.2.0.2.0 - 64bit Production
Windows NT Version V6.1
CPU : 24 - type 8664, 12 Physical Cores
Process Affinity : 0x0x0000000000000000
Memory (Avail/Total): Ph:8400M/16362M, Ph+PgF:21508M/32722M
Instance name: nsdb
Redo thread mounted by this instance: 1
Oracle process number: 21
Windows thread id: 5724, image: ORACLE.EXE (CJQ0)


*** 2015-08-18 07:18:40.423
*** SESSION ID:(1345.5) 2015-08-18 07:18:40.423
*** CLIENT ID:() 2015-08-18 07:18:40.423
*** SERVICE NAME:(SYS$BACKGROUND) 2015-08-18 07:18:40.423
*** MODULE NAME:() 2015-08-18 07:18:40.423
*** ACTION NAME:() 2015-08-18 07:18:40.423

Dump continued from file: D:\APP\ORACLE\diag\rdbms\nsdb\nsdb\trace\nsdb_cjq0_5724.trc
ORA-00445: 后台进程 "J000" 在 120 秒之后仍没有启动

========= Dump for incident 344545 (ORA 445) ========
----- Beginning of Customized Incident Dump(s) -----
-------------------------------------------------------------------------------
Trace Bucket Dump Begin: default bucket for process 21 (osid: 5724, CJQ0)
TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA
-------------------------------------------------------------------------------
2015-08-18 07:16:18.805297 :8823444A:db_trace:ksb.c@1755:ksbcti(): [10254:21:1345] KSBCTI: (CJQ0) : (interrupt action) : acnum=[332] comment=[Check for async messages from other instances]
2015-08-18 07:16:19.818925 :88234505:db_trace:ksb.c@1755:ksbcti(): [10254:21:1345] KSBCTI: (CJQ0) : (interrupt action) : acnum=[2] comment=[KSB action for X-instance calls]
2015-08-18 07:16:19.818928 :88234506:db_trace:ksb.c@1755:ksbcti(): [10254:21:1345] KSBCTI: (CJQ0) : (interrupt action) : acnum=[18] comment=[KSB action for ksbxic() calls]
2015-08-18 07:16:19.818928 :88234507:db_trace:ksb.c@1755:ksbcti(): [10254:21:1345] KSBCTI: (CJQ0) : (interrupt action) : acnum=[104] comment=[Scumnt mount lock]
2015-08-18 07:16:19.818929 :88234508:db_trace:ksb.c@1755:ksbcti(): [10254:21:1345] KSBCTI: (CJQ0) : (interrupt action) : acnum=[105] comment=[Poll system events broadcast channel]
2015-08-18 07:16:19.818929 :88234509:db_trace:ksb.c@1755:ksbcti(): [10254:21:1345] KSBCTI: (CJQ0) : (interrupt action) : acnum=[332] comment=[Check for async messages from other instances]
2015-08-18 07:16:19.818934 :8823450A:db_trace:ksb.c@1781:ksbcti(): [10254:21:1345] KSBCTI: (CJQ0) : (timeout action) : acnum=[0] comment=[Monitor Cleanup]
2015-08-18 07:16:19.818935 :8823450B:db_trace:ksb.c@1781:ksbcti(): [10254:21:1345] KSBCTI: (CJQ0) : (timeout action) : acnum=[3] comment=[KSB action for bast checking]
2015-08-18 07:16:19.818935 :8823450C:db_trace:ksb.c@1781:ksbcti(): [10254:21:1345] KSBCTI: (CJQ0) : (timeout action) : acnum=[205] comment=[Job Queue Timout]
2015-08-18 07:16:19.819665 :8823450D:db_trace:ksb.c@1755:ksbcti(): [10254:21:1345] KSBCTI: (CJQ0) : (interrupt action) : acnum=[2] comment=[KSB action for X-instance calls]
2015-08-18 07:16:19.819667 :8823450E:db_trace:ksb.c@1755:ksbcti(): [10254:21:1345] KSBCTI: (CJQ0) : (interrupt action) : acnum=[18] comment=[KSB action for ksbxic() calls]
2015-08-18 07:16:19.819668 :8823450F:db_trace:ksb.c@1755:ksbcti(): [10254:21:1345] KSBCTI: (CJQ0) : (interrupt action) : acnum=[104] comment=[Scumnt mount lock]
2015-08-18 07:16:19.819668 :88234510:db_trace:ksb.c@1755:ksbcti(): [10254:21:1345] KSBCTI: (CJQ0) : (interrupt action) : acnum=[105] comment=[Poll system events broadcast channel]
2015-08-18 07:16:19.819669 :88234511:db_trace:ksb.c@1755:ksbcti(): [10254:21:1345] KSBCTI: (CJQ0) : (interrupt action) : acnum=[332] comment=[Check for async messages from other instances]
2015-08-18 07:16:20.832960 :8823458B:db_trace:ksb.c@1755:ksbcti(): [10254:21:1345] KSBCTI: (CJQ0) : (interrupt action) : acnum=[2] comment=[KSB action for X-instance calls]
2015-08-18 07:16:20.832988 :8823458C:db_trace:ksb.c@1755:ksbcti(): [10254:21:1345] KSBCTI: (CJQ0) : (interrupt action) : acnum=[18] comment=[KSB action for ksbxic() calls]
2015-08-18 07:16:20.832992 :8823458D:db_trace:ksb.c@1755:ksbcti(): [10254:21:1345] KSBCTI: (CJQ0) : (interrupt action) : acnum=[104] comment=[Scumnt mount lock]
2015-08-18 07:16:20.832992 :8823458E:db_trace:ksb.c@1755:ksbcti(): [10254:21:1345] KSBCTI: (CJQ0) : (interrupt action) : acnum=[105] comment=[Poll system events broadcast channel]
2015-08-18 07:16:20.832993 :8823458F:db_trace:ksb.c@1755:ksbcti(): [10254:21:1345] KSBCTI: (CJQ0) : (interrupt action) : acnum=[332] comment=[Check for async messages from other instances]
2015-08-18 07:16:20.832998 :88234590:db_trace:ksb.c@1781:ksbcti(): [10254:21:1345] KSBCTI: (CJQ0) : (timeout action) : acnum=[0] comment=[Monitor Cleanup]
2015-08-18 07:16:20.832998 :88234591:db_trace:ksb.c@1781:ksbcti(): [10254:21:1345] KSBCTI: (CJQ0) : (timeout action) : acnum=[3] comment=[KSB action for bast checking]
2015-08-18 07:16:20.832999 :88234592:db_trace:ksb.c@1781:ksbcti(): [10254:21:1345] KSBCTI: (CJQ0) : (timeout action) : acnum=[205] comment=[Job Queue Timout]
2015-08-18 07:16:20.833561 :88234593:db_trace:ksb.c@1755:ksbcti(): [10254:21:1345] KSBCTI: (CJQ0) : (interrupt action) : acnum=[2] comment=[KSB action for X-instance calls]
2015-08-18 07:16:20.833563 :88234594:db_trace:ksb.c@1755:ksbcti(): [10254:21:1345] KSBCTI: (CJQ0) : (interrupt action) : acnum=[18] comment=[KSB action for ksbxic() calls]
2015-08-18 07:16:20.833564 :88234595:db_trace:ksb.c@1755:ksbcti(): [10254:21:1345] KSBCTI: (CJQ0) : (interrupt action) : acnum=[104] comment=[Scumnt mount lock]
2015-08-18 07:16:20.833564 :88234596:db_trace:ksb.c@1755:ksbcti(): [10254:21:1345] KSBCTI: (CJQ0) : (interrupt action) : acnum=[105] comment=[Poll system events broadcast channel]
2015-08-18 07:16:20.833565 :88234597:db_trace:ksb.c@1755:ksbcti(): [10254:21:1345] KSBCTI: (CJQ0) : (interrupt action) : acnum=[332] comment=[Check for async messages from other instances]
2015-08-18 07:16:21.846926 :8823461A:db_trace:ksb.c@1755:ksbcti(): [10254:21:1345] KSBCTI: (CJQ0) : (interrupt action) : acnum=[2] comment=[KSB action for X-instance calls]
2015-08-18 07:16:21.846947 :8823461B:db_trace:ksb.c@1755:ksbcti(): [10254:21:1345] KSBCTI: (CJQ0) : (interrupt action) : acnum=[18] comment=[KSB action for ksbxic() calls]
2015-08-18 07:16:21.846948 :8823461C:db_trace:ksb.c@1755:ksbcti(): [10254:21:1345] KSBCTI: (CJQ0) : (interrupt action) : acnum=[104] comment=[Scumnt mount lock]
2015-08-18 07:16:21.846948 :8823461D:db_trace:ksb.c@1755:ksbcti(): [10254:21:1345] KSBCTI: (CJQ0) : (interrupt action) : acnum=[105] comment=[Poll system events broadcast channel]
2015-08-18 07:16:21.846949 :8823461E:db_trace:ksb.c@1755:ksbcti(): [10254:21:1345] KSBCTI: (CJQ0) : (interrupt action) : acnum=[332] comment=[Check for async messages from other instances]
2015-08-18 07:16:21.846952 :8823461F:db_trace:ksb.c@1781:ksbcti(): [10254:21:1345] KSBCTI: (CJQ0) : (timeout action) : acnum=[0] comment=[Monitor Cleanup]
2015-08-18 07:16:21.846953 :88234620:db_trace:ksb.c@1781:ksbcti(): [10254:21:1345] KSBCTI: (CJQ0) : (timeout action) : acnum=[3] comment=[KSB action for bast checking]
2015-08-18 07:16:21.846953 :88234621:db_trace:ksb.c@1781:ksbcti(): [10254:21:1345] KSBCTI: (CJQ0) : (timeout action) : acnum=[205] comment=[Job Queue Timout]
2015-08-18 07:16:21.847419 :88234622:db_trace:ksb.c@1755:ksbcti(): [10254:21:1345] KSBCTI: (CJQ0) : (interrupt action) : acnum=[2] comment=[KSB action for X-instance calls]
2015-08-18 07:16:21.847421 :88234623:db_trace:ksb.c@1755:ksbcti(): [10254:21:1345] KSBCTI: (CJQ0) : (interrupt action) : acnum=[18] comment=[KSB action for ksbxic() calls]
2015-08-18 07:16:21.847421 :88234624:db_trace:ksb.c@1755:ksbcti(): [10254:21:1345] KSBCTI: (CJQ0) : (interrupt action) : acnum=[104] comment=[Scumnt mount lock]
2015-08-18 07:16:21.847422 :88234625:db_trace:ksb.c@1755:ksbcti(): [10254:21:1345] KSBCTI: (CJQ0) : (interrupt action) : acnum=[105] comment=[Poll system events broadcast channel]
2015-08-18 07:16:21.847422 :88234626:db_trace:ksb.c@1755:ksbcti(): [10254:21:1345] KSBCTI: (CJQ0) : (interrupt action) : acnum=[332] comment=[Check for async messages from other instances]
2015-08-18 07:16:22.861179 :882346BC:db_trace:ksb.c@1755:ksbcti(): [10254:21:1345] KSBCTI: (CJQ0) : (interrupt action) : acnum=[2] comment=[KSB action for X-instance calls]
2015-08-18 07:16:22.861186 :882346BE:db_trace:ksb.c@1755:ksbcti(): [10254:21:1345] KSBCTI: (CJQ0) : (interrupt action) : acnum=[18] comment=[KSB action for ksbxic() calls]
2015-08-18 07:16:22.861187 :882346BF:db_trace:ksb.c@1755:ksbcti(): [10254:21:1345] KSBCTI: (CJQ0) : (interrupt action) : acnum=[104] comment=[Scumnt mount lock]
2015-08-18 07:16:22.861187 :882346C0:db_trace:ksb.c@1755:ksbcti(): [10254:21:1345] KSBCTI: (CJQ0) : (interrupt action) : acnum=[105] comment=[Poll system events broadcast channel]
2015-08-18 07:16:22.861188 :882346C1:db_trace:ksb.c@1755:ksbcti(): [10254:21:1345] KSBCTI: (CJQ0) : (interrupt action) : acnum=[332] comment=[Check for async messages from other instances]
2015-08-18 07:16:22.861191 :882346C2:db_trace:ksb.c@1781:ksbcti(): [10254:21:1345] KSBCTI: (CJQ0) : (timeout action) : acnum=[0] comment=[Monitor Cleanup]
2015-08-18 07:16:22.861191 :882346C3:db_trace:ksb.c@1781:ksbcti(): [10254:21:1345] KSBCTI: (CJQ0) : (timeout action) : acnum=[3] comment=[KSB action for bast checking]
2015-08-18 07:16:22.861192 :882346C4:db_trace:ksb.c@1781:ksbcti(): [10254:21:1345] KSBCTI: (CJQ0) : (timeout action) : acnum=[205] comment=[Job Queue Timout]
...全文
1157 回复 打赏 收藏 转发到动态 举报
写回复
用AI写文章
回复
切换为时间正序
请发表友善的回复…
发表回复

3,491

社区成员

发帖
与我相关
我的任务
社区描述
Oracle 高级技术相关讨论专区
社区管理员
  • 高级技术社区
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧