LGWR (ospid: 125156): terminating the instance

oracle数据库mount时提示LGWR (ospid: 125156): terminating the instance 无法启动数据库
Trace file D:\ORACLE11G\diag\rdbms\mis\mis\trace\cdmp_20180228120943\mis_diag_49496_bucket.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Windows NT Version V6.1 Service Pack 1
CPU                 : 8 - type 8664, 8 Physical Cores
Process Affinity    : 0x0x0000000000000000
Memory (Avail/Total): Ph:5925M/8191M, Ph+PgF:11523M/16381M
VM name             : VMWare Version (6)
Instance name: mis
Redo thread mounted by this instance: 1
Oracle process number: 6
Windows thread id: 49496, image: ORACLE.EXE (DIAG)

*** 2018-02-28 12:09:43.226
*** SESSION ID:(187.1) 2018-02-28 12:09:43.226
*** CLIENT ID:() 2018-02-28 12:09:43.226
*** SERVICE NAME:() 2018-02-28 12:09:43.226
*** MODULE NAME:() 2018-02-28 12:09:43.226
*** ACTION NAME:() 2018-02-28 12:09:43.226
 
*** SESSION ID:(187.1) 2018-02-28 12:09:43.226
 
*** 2018-02-28 12:09:43.226
Process diagnostic dump for ORACLE.EXE (DIAG), OS id=49496,
pid: 6, proc_ser: 1, sid: 187, sess_ser: 1
-------------------------------------------------------------------------------
current sql: <none>
Current Wait Stack:
 1: waiting for 'process diagnostic dump'
    =0x0, =0x0, =0x0
    wait_id=10 seq_num=15 snap_id=1
    wait times: snap=0.000016 sec, exc=0.000016 sec, total=0.000016 sec
    wait times: max=30.000000 sec, heur=0.014025 sec
    wait counts: calls=0 os=0
    in_wait=1 iflags=0x520
 0: waiting for 'DIAG idle wait'
    component=0x5, where=0x1, wait time(millisec)=0x3e8
    wait_id=5 seq_num=14 snap_id=5
    wait times: snap=0.000000 sec, exc=1.078005 sec, total=1.080948 sec
    wait times: max=1.000000 sec, heur=6.149839 sec
    wait counts: calls=1 os=1
    in_wait=1 iflags=0x15a8
Wait State:
  fixed_waits=0 flags=0x22 boundary=0x0000000000000000/-1
Session Wait History:
    elapsed time of 0.000000 sec since current wait
 0: waited for 'DIAG idle wait'
    component=0x5, where=0x1, wait time(millisec)=0x3e8
    wait_id=5 seq_num=14 snap_id=5
    wait times: snap=0.002074 sec, exc=1.078005 sec, total=1.080932 sec
    wait times: max=1.000000 sec
    wait counts: calls=1 os=1
    occurred after 0.000000 sec of elapsed time
 1: waited for 'process diagnostic dump'
    =0x0, =0x0, =0x0
    wait_id=9 seq_num=13 snap_id=1
    wait times: snap=0.000581 sec, exc=0.000581 sec, total=0.000581 sec
    wait times: max=30.000000 sec
    wait counts: calls=0 os=0
    occurred after 0.000000 sec of elapsed time
 2: waited for 'DIAG idle wait'
    component=0x5, where=0x1, wait time(millisec)=0x3e8
    wait_id=5 seq_num=12 snap_id=4
    wait times: snap=0.001893 sec, exc=1.075931 sec, total=1.078277 sec
    wait times: max=1.000000 sec
    wait counts: calls=1 os=1
    occurred after 0.000000 sec of elapsed time
 3: waited for 'process diagnostic dump'
    =0x0, =0x0, =0x0
    wait_id=8 seq_num=11 snap_id=1
    wait times: snap=0.000678 sec, exc=0.000678 sec, total=0.000678 sec
    wait times: max=30.000000 sec
    wait counts: calls=0 os=0
    occurred after 0.000000 sec of elapsed time
 4: waited for 'DIAG idle wait'
    component=0x5, where=0x1, wait time(millisec)=0x3e8
    wait_id=5 seq_num=10 snap_id=3
    wait times: snap=0.004625 sec, exc=1.074038 sec, total=1.075706 sec
    wait times: max=1.000000 sec
    wait counts: calls=1 os=1
    occurred after 0.000000 sec of elapsed time
 5: waited for 'process diagnostic dump'
    =0x0, =0x0, =0x0
    wait_id=7 seq_num=9 snap_id=1
    wait times: snap=0.001054 sec, exc=0.001054 sec, total=0.001054 sec
    wait times: max=30.000000 sec
    wait counts: calls=0 os=0
    occurred after 0.000000 sec of elapsed time
 6: waited for 'DIAG idle wait'
    component=0x5, where=0x1, wait time(millisec)=0x3e8
    wait_id=5 seq_num=8 snap_id=2
    wait times: snap=0.002490 sec, exc=1.069413 sec, total=1.070027 sec
    wait times: max=1.000000 sec
    wait counts: calls=1 os=1
    occurred after 0.000000 sec of elapsed time
 7: waited for 'process diagnostic dump'
    =0x0, =0x0, =0x0
    wait_id=6 seq_num=7 snap_id=1
    wait times: snap=0.000614 sec, exc=0.000614 sec, total=0.000614 sec
    wait times: max=30.000000 sec
    wait counts: calls=0 os=0
    occurred after 0.000000 sec of elapsed time
 8: waited for 'DIAG idle wait'
    component=0x5, where=0x1, wait time(millisec)=0x3e8
    wait_id=5 seq_num=6 snap_id=1
    wait times: snap=1.066923 sec, exc=1.066923 sec, total=1.066923 sec
    wait times: max=1.000000 sec
    wait counts: calls=1 os=1
    occurred after 0.000023 sec of elapsed time
 9: waited for 'DIAG idle wait'
    component=0x5, where=0x1, wait time(millisec)=0x3e8
    wait_id=4 seq_num=5 snap_id=1
    wait times: snap=1.014037 sec, exc=1.014037 sec, total=1.014037 sec
    wait times: max=1.000000 sec
    wait counts: calls=1 os=1
    occurred after 0.000021 sec of elapsed time
Sampled Session History of session 187 serial 1
---------------------------------------------------
The sampled session history is constructed by sampling
the target session every 1 second. The sampling process
captures at each sample if the session is in a non-idle wait,
an idle wait, or not in a wait. If the session is in a
non-idle wait then one interval is shown for all the samples
the session was in the same non-idle wait. If the
session is in an idle wait or not in a wait for
consecutive samples then one interval is shown for all
the consecutive samples. Though we display these consecutive
samples  in a single interval the session may NOT be continuously
idle or not in a wait (the sampling process does not know).
 
The history is displayed in reverse chronological order.
 
sample interval: 1 sec, max history 120 sec
---------------------------------------------------
  [3 samples,                                              12:09:41 - 12:09:43]
    idle wait at each sample
-------------------------------------------------------------------------------
Process diagnostic dump actual duration=0.000000 sec
  (max dump time=30.000000 sec)
*** 2018-02-28 12:09:43.226
 
-------------------------------------------------------------------------------
Trace Bucket Dump Begin: default bucket for process 6 (osid: 49496, DIAG)
TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA
-------------------------------------------------------------------------------
2018-02-28 12:09:37.074069 :80000065:db_trace:kst.c@675:kstipg(): [10280:6:0] kst: process state object created on 02-28 12:09:37.064
2018-02-28 12:09:37.074072 :80000066:db_trace:kst.c@681:kstipg(): [10280:6:0] kst: process info: ospid=49496 pso_num=6 pso_serial#=1
2018-02-28 12:09:37.074361 :80000067:db_trace:kso.c@4291:ksonfy(): [10420:6:0] kso: new process: pid=49496 osp_idx=5 osp_ver=0 osp_pg=0 (spawn #4)
2018-02-28 12:09:37.074364 :80000068:db_trace:kso.c@4297:ksonfy(): [10420:6:0] kso: new process: first_req_pid=93688 spawner_pid=122340 sga_crt_ts=x7C84E48
2018-02-28 12:09:37.074366 :80000069:db_trace:kso.c@4301:ksonfy(): [10420:6:0] kso: new process: pso_index=6 reservation=1 time=130568687
2018-02-28 12:09:37.074368 :8000006A:db_trace:kso.c@4307:ksonfy(): [10420:6:0] kso: spawn diagnostics: queue time=0 secs
2018-02-28 12:09:37.074369 :8000006B:db_trace:kso.c@4309:ksonfy(): [10420:6:0] kso: spawn diagnostics: fork time=0 secs
2018-02-28 12:09:37.074371 :8000006C:db_trace:kso.c@4311:ksonfy(): [10420:6:0] kso: spawn diagnostics: exec time=0 secs
2018-02-28 12:09:37.074373 :8000006D:db_trace:kso.c@4313:ksonfy(): [10420:6:0] kso: spawn diagnostics: pre dbkc time=0 secs
2018-02-28 12:09:37.074375 :8000006E:db_trace:kso.c@4315:ksonfy(): [10420:6:0] kso: spawn diagnostics: post dbkc time=0 secs
2018-02-28 12:09:37.074482 :8000006F:db_trace:ksl2.c@16009:ksl_update_post_stats(): [10005:6:0] KSL POST SENT postee=149 num=1 loc='kso2.h LINE:472 ID:ksoreq_reply' id1=0 id2=0 name=   type=0
2018-02-28 12:09:37.074507 :80000070:db_trace:kso.c@5759:kso_spawn_diag_end(): [10420:6:0] kso: spawn diagnostics: init time=0 secs
-------------------------------------------------------------------------------
Trace Bucket Dump End: default bucket for process 6 (osid: 49496, DIAG)
 
求大神解答
评论 2
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值