B-W 2018-04-18 08:48 采纳率: 100%
浏览 4739
已采纳

Oracle数据库启动实例出现:错误1053,服务没有及时响应或控制请求)

oracle监听可以正常启动:
cmd: Lsnrctl status
出现如下信息:
图片说明

oracle的alert日志提示如下信息:
type='UNKNOWN' level='16' host_id='WINDOWS-07WTF9D'
host_addr='fe80::15bb:1d0:8d13:5301%17'>

Fatal NI connect error 12638, connecting to:
(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))


type='UNKNOWN' level='16' host_id='WINDOWS-07WTF9D'
host_addr='fe80::15bb:1d0:8d13:5301%17'>

VERSION INFORMATION:
TNS for 32-bit Windows: Version 11.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 11.2.0.1.0 - Production


type='UNKNOWN' level='16' host_id='WINDOWS-07WTF9D'
host_addr='fe80::15bb:1d0:8d13:5301%17'>
Time: 15-4月 -2018 07:02:54


type='UNKNOWN' level='16' host_id='WINDOWS-07WTF9D'
host_addr='fe80::15bb:1d0:8d13:5301%17'>
Tracing not turned on.


type='UNKNOWN' level='16' host_id='WINDOWS-07WTF9D'
host_addr='fe80::15bb:1d0:8d13:5301%17'>
Tns error struct:


type='UNKNOWN' level='16' host_id='WINDOWS-07WTF9D'
host_addr='fe80::15bb:1d0:8d13:5301%17'>
ns main err code: 12638


type='UNKNOWN' level='16' host_id='WINDOWS-07WTF9D'
host_addr='fe80::15bb:1d0:8d13:5301%17'>




type='UNKNOWN' level='16' host_id='WINDOWS-07WTF9D'
host_addr='fe80::15bb:1d0:8d13:5301%17'>
TNS-12638: 身份证明检索失败


type='UNKNOWN' level='16' host_id='WINDOWS-07WTF9D'
host_addr='fe80::15bb:1d0:8d13:5301%17'>
ns secondary err code: 0


type='UNKNOWN' level='16' host_id='WINDOWS-07WTF9D'
host_addr='fe80::15bb:1d0:8d13:5301%17'>
nt main err code: 0


type='UNKNOWN' level='16' host_id='WINDOWS-07WTF9D'
host_addr='fe80::15bb:1d0:8d13:5301%17'>
nt secondary err code: 0


type='UNKNOWN' level='16' host_id='WINDOWS-07WTF9D'
host_addr='fe80::15bb:1d0:8d13:5301%17'>
nt OS err code: 0


client_id='' type='UNKNOWN' level='16'
host_id='WINDOWS-07WTF9D' host_addr='fe80::15bb:1d0:8d13:5301%17' module=''
pid='3084'>
AUD: OS Error = 1717 encountered while writing audit record


client_id='' type='UNKNOWN' level='16'
host_id='WINDOWS-07WTF9D' host_addr='fe80::15bb:1d0:8d13:5301%17' module=''
pid='3084'>
opidcl aborting process unknown ospid (3084) as a result of ORA-28056


client_id='' type='UNKNOWN' level='16'
host_id='WINDOWS-07WTF9D' host_addr='fe80::15bb:1d0:8d13:5301%17' module=''
pid='2820'>
AUD: OS Error = 1717 encountered while writing audit record


client_id='' type='UNKNOWN' level='16'
host_id='WINDOWS-07WTF9D' host_addr='fe80::15bb:1d0:8d13:5301%17' module=''
pid='2820'>
opidcl aborting process unknown ospid (2820) as a result of ORA-28056

运行环境:windows server 2008r2
数据库在2018年04月15日前正常运行,数据库实例死掉后,重启出现如下错误
图片说明

  • 写回答

3条回答 默认 最新

  • bingzibing 2018-04-18 09:16
    关注

    到cmd窗口下执行启动 sqlplus / as sysdba
    startup 从而找到具体报错的信息,因为服务器里面是看不到报错的信息的。

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(2条)

报告相同问题?

悬赏问题

  • ¥15 有偿求码,CNN+LSTM实现单通道脑电信号EEG的睡眠分期评估
  • ¥15 没有证书,nginx怎么反向代理到只能接受https的公网网站
  • ¥50 成都蓉城足球俱乐部小程序抢票
  • ¥15 yolov7训练自己的数据集
  • ¥15 esp8266与51单片机连接问题(标签-单片机|关键词-串口)(相关搜索:51单片机|单片机|测试代码)
  • ¥15 电力市场出清matlab yalmip kkt 双层优化问题
  • ¥30 ros小车路径规划实现不了,如何解决?(操作系统-ubuntu)
  • ¥20 matlab yalmip kkt 双层优化问题
  • ¥15 如何在3D高斯飞溅的渲染的场景中获得一个可控的旋转物体
  • ¥88 实在没有想法,需要个思路