ORACLE无法连接,报ORA-445错误,请高手帮忙分析,谢谢!

sysadm_cc 2013-10-24 12:18:35
*** 2013-10-01 15:19:40.508
Process diagnostic dump for M000, OS id=11452
-------------------------------------------------------------------------------
Memory (Avail/Total): Ph:4317M/16371M, Ph+PgF:20444M/32740M

Stack:
------------------- Call Stack Trace ---------------------
calling location entry point arg #1 arg #2 arg #3 arg #4
------------------------------------------- ------------------------------------------- ---------------- ---------------- ---------------- ----------------
0000000076D7F6FA 0000000000000000 0000000000000000 000000000994dc0f 000000001ad29ef0 00000083051ef396
000007FEFCF710AC 0000000076D7F6F0 000000002fc1f848 0000000000000042 000000002fc1fc40 0000000027e2d640
sskgmfindrealm()+37 000007FEFCF71010 000000002fc1fb30 0000000000000000 0005000200000000 00000000000001a8
skgmattach()+261 sskgmfindrealm() 0000000000032000 0000000000159000 ffffffffffffffff ffffffffffffffff
ksmlsge_phaseone()+395 skgmattach()+253 000000000d6800df 0000000000000000 000000000d680088 0000000000000049
opimai_init()+151 ksmlsge_phaseone() 0000000000000000 0000000000000000 0000000000000000 0000000000000000
opimai_real()+247 opimai_init() 01cebe7673b070ef 0000000000000000 000f0001000a07dd 0002029c00270012
opimai()+191 opimai_real() 0000000000000000 0000000000000000 0000000000000000 0000000000000000
BackgroundThreadStart()+693 opimai() 000000002fc1fe58 0000000000000001 0000000000000000 0000000000000000
0000000076C2F33D BackgroundThreadStart() 000000004e1905d0 0000000000000000 0000000000000000 0000000000000000
0000000076D62CA1 0000000076C2F330 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): 141 ms
symbol translation time: 93 ms
total time: 234 ms

-------------------------------------------------------------------------------
Process diagnostic dump actual duration=0.343000 sec
(max dump time=30.000000 sec)

*** 2013-10-01 15:19:40.851

*** 2013-10-01 15:19:56.061
Waited for process M000 to initialize for 76 seconds
...全文
1699 5 打赏 收藏 转发到动态 举报
AI 作业
写回复
用AI写文章
5 条回复
切换为时间正序
请发表友善的回复…
发表回复
  • 打赏
  • 举报
回复
这个跟你好像 http://t.askmaclean.com/thread-1093-1-1.html
sysadm_cc 2013-10-31
  • 打赏
  • 举报
回复
引用 3 楼 comerliang 的回复:
在服务器上用sqlplus也连不上?
是的
Comer 2013-10-30
  • 打赏
  • 举报
回复
在服务器上用sqlplus也连不上?
sysadm_cc 2013-10-24
  • 打赏
  • 举报
回复
Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_mmon_2276.trc Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Windows NT Version V6.1 CPU : 4 - type 8664, 4 Physical Cores Process Affinity : 0x0x0000000000000000 Memory (Avail/Total): Ph:4024M/16371M, Ph+PgF:20073M/32740M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 15 Windows thread id: 2276, image: ORACLE.EXE (MMON) *** 2013-09-13 17:45:24.007 *** SESSION ID:(190.1) 2013-09-13 17:45:24.007 *** CLIENT ID:() 2013-09-13 17:45:24.007 *** SERVICE NAME:(SYS$BACKGROUND) 2013-09-13 17:45:24.007 *** MODULE NAME:() 2013-09-13 17:45:24.007 *** ACTION NAME:() 2013-09-13 17:45:24.007 *** TRACE FILE RECREATED AFTER BEING REMOVED *** ORA-00020: No more process state objects available *** 2013-09-13 17:45:24.194 kraalac: unable to schedule MMON slave, error 3 ORA-00020: No more process state objects available *** 2013-09-13 18:33:36.081 ktte_monitor_ts: unable to schedule MMON Slave, error 3 ORA-00020: No more process state objects available ***ket_aba_spawn: unable to schedule MMON Slave, error 3 AUTO MEM: pga_aggregate_target resize. manual=0, toggle=0 AUTO MEM: pga_aggregate_target resize. manual=0, toggle=0 Waited for process M000 to initialize for 60 seconds *** 2013-10-01 15:19:40.508 Process diagnostic dump for M000, OS id=11452 ------------------------------------------------------------------------------- Memory (Avail/Total): Ph:4317M/16371M, Ph+PgF:20444M/32740M Stack: ------------------- Call Stack Trace --------------------- calling location entry point arg #1 arg #2 arg #3 arg #4 ------------------------------------------- ------------------------------------------- ---------------- ---------------- ---------------- ---------------- 0000000076D7F6FA 0000000000000000 0000000000000000 000000000994dc0f 000000001ad29ef0 00000083051ef396 000007FEFCF710AC 0000000076D7F6F0 000000002fc1f848 0000000000000042 000000002fc1fc40 0000000027e2d640 sskgmfindrealm()+37 000007FEFCF71010 000000002fc1fb30 0000000000000000 0005000200000000 00000000000001a8 skgmattach()+261 sskgmfindrealm() 0000000000032000 0000000000159000 ffffffffffffffff ffffffffffffffff ksmlsge_phaseone()+395 skgmattach()+253 000000000d6800df 0000000000000000 000000000d680088 0000000000000049 opimai_init()+151 ksmlsge_phaseone() 0000000000000000 0000000000000000 0000000000000000 0000000000000000 opimai_real()+247 opimai_init() 01cebe7673b070ef 0000000000000000 000f0001000a07dd 0002029c00270012 opimai()+191 opimai_real() 0000000000000000 0000000000000000 0000000000000000 0000000000000000 BackgroundThreadStart()+693 opimai() 000000002fc1fe58 0000000000000001 0000000000000000 0000000000000000 0000000076C2F33D BackgroundThreadStart() 000000004e1905d0 0000000000000000 0000000000000000 0000000000000000 0000000076D62CA1 0000000076C2F330 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): 141 ms symbol translation time: 93 ms total time: 234 ms ------------------------------------------------------------------------------- Process diagnostic dump actual duration=0.343000 sec (max dump time=30.000000 sec) *** 2013-10-01 15:19:40.851 *** 2013-10-01 15:19:56.061 Waited for process M000 to initialize for 76 seconds
sysadm_cc 2013-10-24
  • 打赏
  • 举报
回复
log.xml文件内容: <msg time='2013-10-01T15:20:45.591+08:00' org_id='oracle' comp_id='rdbms' msg_id='4233499900' type='INCIDENT_ERROR' level='1' host_id='RAYDA-DB' host_addr='fe80::820:2840:3f53:9014%13' prob_key='ORA 445' upstream_comp='' downstream_comp='background_proc' ecid='' errid='21721' detail_path='d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_mmon_2276.trc'> <txt>Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_mmon_2276.trc (incident=21721): ORA-00445: background process "m000" did not start after 120 seconds

3,494

社区成员

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

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