h985161183
B-W
采纳率100%
2018-04-18 08:48

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

10
已采纳

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 bingzibing 3年前

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

    点赞 评论 复制链接分享
  • nannan11115 nannan11115 3年前

    sqlplus / as sysdba
    startup 然后看看具体有什么报错。

    点赞 评论 复制链接分享
  • a10170813 a10170813 3年前

    opidcl aborting process unknown ospid (2820) as a result of ORA-28056

    点赞 评论 复制链接分享

相关推荐