*** 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
oracle

解决方案 »

  1.   

    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 &quot;m000&quot; did not start after 120 seconds
      

  2.   

    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
      

  3.   

    在服务器上用sqlplus也连不上?
      

  4.   

    这个跟你好像
    http://t.askmaclean.com/thread-1093-1-1.html