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