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个回答

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

h985161183
B-W 回复hulidada: 已经解决,由于服务器上的360杀毒软件,将oracle数据库批处理文件误认为是木马,将其进行隔离,导致oracle实例无法启动。谢谢你的回答
一年多之前 回复
hulidada
胡达达 回复h985161183: 在listener.ora配置文件 LISTENER_ORCL = (ADDRESS = (PROTOCOL = TCP)(HOST = “服务器的IP”)(PORT = 1521));然后再去修改Windows的hosts文件,添加服务器IP WINDOWS-07WTF9D
一年多之前 回复
hulidada
胡达达 回复h985161183: 在你的基础上可以这样修改:
一年多之前 回复
h985161183
B-W 提示 ORA-12560: TNS 协议适配器错误,在listener.ora配置文件 LISTENER_ORCL = (ADDRESS = (PROTOCOL = TCP)(HOST = “当前计算名”)(PORT = 1521))
一年多之前 回复

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

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

h985161183
B-W ORA-12560: TNS 协议适配器错误
一年多之前 回复
Csdn user default icon
上传中...
上传图片
插入图片
抄袭、复制答案,以达到刷声望分或其他目的的行为,在CSDN问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!