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日前正常运行,数据库实例死掉后,重启出现如下错误