sqlplus 连接hang

数据库版本为Oracle 10.2.0.1，运行在windows xp 32位平台上，安装好之后，出现sqlplus连接hang住的情况，sqlnet.log中显示如下错误：

引用

Fatal NI connect error 12560, connecting to:
(LOCAL=NO)

  VERSION INFORMATION:
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production
  Time: 08-10月-2011 14:56:33
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12560
    TNS-12560: TNS: 协议适配器错误
    ns secondary err code: 0
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0

尝试了重建监听，排除了listener.ora,tnsnames.ora无问题之后，进行metalink上搜索，发现有一bug与此错误类似

引用

Windows: Starting the Oracle Service Fails to Start the Database in Release 10g [ID 359428.1]
Applies to:
Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 10.1.0.4
Oracle Server - Enterprise Edition - Version: 10.2.0.1
Oracle Server - Standard Edition - Version: 10.1.0.2 to 10.1.0.4
Oracle Server - Standard Edition - Version: 10.2.0.1
z*OBSOLETE: Microsoft Windows 2000
Microsoft Windows (32-bit)
z*OBSOLETE: Microsoft Windows XP
Symptoms

Starting the Oracle instance service, either by using 'net start oracleserviceSID' or the Services panel, fails to start the database.

The key ORA_SID_AUTOSTART is set to TRUE in the registry.

In ORACLE_HOME\database\oradim.log, an ORA-12560 error is logged:

ORA-12560: TNS:protocol adapter error

In ORACLE_HOME\database\sqlnet.log, the following errors are reported:

Fatal NI connect error 12560, connecting to:

(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracle<SID>)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=v1010)(CID=(PROGRAM=D:\Oracle\Ora101\bin\oradim.exe)(HOST=<hostname>)(USER=SYSTEM))))

VERSION INFORMATION:
TNS for 32-bit Windows: Version 10.1.0.4.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.1.0.4.0 -
Production
  Time: <timestamp>
  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: 530
    TNS-530: Protocol adapter error
    nt secondary err code: 2
    nt OS err code: 0

Cause

Bug:4598734 'NET START ORACLESERVICESID' FAILS TO START THE DATABASE ON 10.1.0.4
Solution

The fix for Bug 4598734 has been included in Database Server patchset version 10.1.0.5 and in Server
patchset version 10.2.0.2, respectively for Windows 32-bit.


If running Database Server version 10.1, apply Server patchset 10.1.0.5 which can be downloaded from Metalink with Patch 4505133.


If running Database Server version 10.2, apply at least Server patchset 10.2.0.2 which can be downloaded from Metalink with Patch 4547817.


See the Readme file for patchset installation instructions.

于是将数据库升级到10.2.0.5，故障消失。