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 求解 yolo算法问题
  • ¥15 虚拟机打包apk出现错误
  • ¥30 最小化遗憾贪心算法上界
  • ¥15 用visual studi code完成html页面
  • ¥15 聚类分析或者python进行数据分析
  • ¥15 三菱伺服电机按启动按钮有使能但不动作
  • ¥15 js,页面2返回页面1时定位进入的设备
  • ¥50 导入文件到网吧的电脑并且在重启之后不会被恢复
  • ¥15 (希望可以解决问题)ma和mb文件无法正常打开,打开后是空白,但是有正常内存占用,但可以在打开Maya应用程序后打开场景ma和mb格式。
  • ¥20 ML307A在使用AT命令连接EMQX平台的MQTT时被拒绝