问题描述
朋友最近遇到一个问题，一个单实例 oracle 11.2.0.1 windows x64bit平台的库，在服务器端用sqlplus可以连接数据库，但是用任何客户端连接都失败。alert日志中的重复出现如下报错
|
Fatal NI connect error 12560, connecting to: (LOCAL=NO)
VERSION INFORMATION: TNS for 64-bit Windows: Version 11.2.0.1.0 - Production Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.1.0 - Production Time: 08-JAN-2010 12:01:23 Tracing not turned on. Tns error struct: ns main err code: 12560
TNS-12560: TNS:protocol adapter error ns secondary err code: 0 nt main err code: 0 nt secondary err code: 0 nt OS err code: 0
ORA-609 : opiodr aborting process unknown ospid (2580_4036) |
让朋友检查了一下监听的状态，服务器防火墙状态，客户端配置是否正确。检查结果是 监听状态正常，防火墙关闭状态，客户端配置没有问题。
在mos上查了下，找到一篇 文档 ID987162.1 与该问题描述相符的文章。
适用环境
|
Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.2.0.4 [Release 11.1 to 11.2] Microsoft Windows (32-bit) Microsoft Windows x64 (64-bit) |
原因分析
|
The 'Log on as' credentials were not changed for the Listener Service, so it did not match the account being used by the Database Service leading to the messages being written. |
启动数据库服务和启动监听服务不是同一个用户造成的
解决方法
|
Change the 'Log on as' credentials of the Listener Service to match those of the Database Service and then Restart the Service. |
使用启动数据库的用户来重启监听服务即可