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 对于相关问题的求解与代码
  • ¥15 ubuntu子系统密码忘记
  • ¥15 信号傅里叶变换在matlab上遇到的小问题请求帮助
  • ¥15 保护模式-系统加载-段寄存器
  • ¥15 电脑桌面设定一个区域禁止鼠标操作
  • ¥15 求NPF226060磁芯的详细资料
  • ¥15 使用R语言marginaleffects包进行边际效应图绘制
  • ¥20 usb设备兼容性问题
  • ¥15 错误(10048): “调用exui内部功能”库命令的参数“参数4”不能接受空数据。怎么解决啊
  • ¥15 安装svn网络有问题怎么办