weixin_42129083 2019-06-26 08:29 采纳率: 0%
浏览 363

oracle 11.2.0.1版本数据库最近部署的环境数据库监听总断还无法自启;必须手动去启动服务

下边是出现这情况的alert日志
client_id='' type='UNKNOWN' level='16'
host_id='WIN-10J35UM9LGQ' host_addr='fe80::4f:8dc2:480d:d9cf%12' module=''
pid='2760'>
Errors in file i:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_lgwr_2760.trc:
ORA-00345: redo log write error block 60285 count 2048
ORA-00312: online log 3 thread 1: 'I:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO03.LOG'
ORA-27070: async read/write failed
OSD-04016: 异步 I/O 请求排队时出错。
O/S-Error: (OS 121) 信号灯超时时间已到


client_id='' type='UNKNOWN' level='16'
host_id='WIN-10J35UM9LGQ' host_addr='fe80::4f:8dc2:480d:d9cf%12' module=''
pid='2760'>
Errors in file i:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_lgwr_2760.trc:
ORA-00340: IO error processing online log 3 of thread 1
ORA-00345: redo log write error block 60285 count 2048
ORA-00312: online log 3 thread 1: 'I:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO03.LOG'
ORA-27070: async read/write failed
OSD-04016: 异步 I/O 请求排队时出错。
O/S-Error: (OS 121) 信号灯超时时间已到


client_id='' type='UNKNOWN' level='16'
host_id='WIN-10J35UM9LGQ' host_addr='fe80::4f:8dc2:480d:d9cf%12' module=''
pid='2760'>
LGWR (ospid: 2760): terminating the instance due to error 340


client_id='' type='UNKNOWN' level='16'
host_id='WIN-10J35UM9LGQ' host_addr='fe80::4f:8dc2:480d:d9cf%12' module=''
pid='6956'>
opiodr aborting process unknown ospid (6956) as a result of ORA-1092


type='UNKNOWN' level='16' host_id='WIN-10J35UM9LGQ'
host_addr='fe80::4f:8dc2:480d:d9cf%12' pid='6956'>
ORA-1092 : opitsk aborting process


client_id='' type='UNKNOWN' level='16'
host_id='WIN-10J35UM9LGQ' host_addr='fe80::4f:8dc2:480d:d9cf%12' module=''
pid='8264'>
opiodr aborting process unknown ospid (8264) as a result of ORA-1092


type='UNKNOWN' level='16' host_id='WIN-10J35UM9LGQ'
host_addr='fe80::4f:8dc2:480d:d9cf%12' pid='8264'>
ORA-1092 : opitsk aborting process


client_id='' type='UNKNOWN' level='16'
host_id='WIN-10J35UM9LGQ' host_addr='fe80::4f:8dc2:480d:d9cf%12' module='OEM.SystemPool'
pid='9968'>
opiodr aborting process unknown ospid (9968) as a result of ORA-1092

  • 写回答

1条回答 默认 最新

  • 回到未来望过去 2019-06-26 15:15
    关注

    监听你应该把network\admin下的sqlnet。log日志贴出来 你贴alert没帮助额

    评论

报告相同问题?

悬赏问题

  • ¥15 运筹学中在线排序的时间在线排序的在线LPT算法
  • ¥30 求一段fortran代码用IVF编译运行的结果
  • ¥15 深度学习根据CNN网络模型,搭建BP模型并训练MNIST数据集
  • ¥15 lammps拉伸应力应变曲线分析
  • ¥15 C++ 头文件/宏冲突问题解决
  • ¥15 用comsol模拟大气湍流通过底部加热(温度不同)的腔体
  • ¥50 安卓adb backup备份子用户应用数据失败
  • ¥20 有人能用聚类分析帮我分析一下文本内容嘛
  • ¥15 请问Lammps做复合材料拉伸模拟,应力应变曲线问题
  • ¥30 python代码,帮调试,帮帮忙吧