【翻译自mos文章】在windows上sqlplus / as sysdba 挂起

在windows上sqlplus / as sysdba 挂起

来源于：
Sqlplus / As Sysdba Hangs Using Local Beq Connection on Windows (文档 ID 473630.1)

适用于：
Oracle Server - Enterprise Edition - Version 10.2.0.3 and later
Microsoft Windows (32-bit)
Cheecked for relevance on 13-Sep-2012

症状：
当使用操作系统身份验证（NTS）登陆sqlplus时， sqlplus hang住。

c:\>sqlplus / as sysdba
SQL*Plus: Release 10.2.0.3 - Production on Fri Jan 11 10:16:13 2008
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
_
_
_
_
 
(at this point the hang occurs)

诊断分析揭示了sqlplus.exe程序的 Call Stack Trace:

ztcrprocfini <- ztvull <- nsevwait <- nsevwtsg <- niotns 
 <- osncon <- kpuatch <- upicui2 <- upikgt <- upiah0 
 <- kpuatch <- OCIServerAttach

原因：
在sqlnet.ora文件里边设置了

SQLNET.OUTBOUND_CONNECT_TIMEOUT = 10

原因:
该问题的精确的原因依然未知，该问题被归结为bug 6743100
SQLNET.OUTBOUND_CONNECT_TIMEOUT CAUSES SQLPLUS TO HANG WITH NTS AUTHENTICATION

More information may be provided in the bug report as information becomes available.

解决方案：
从sqlnet.ora文件里边移除SQLNET.OUTBOUND_CONNECT_TIMEOUT

参考：
BUG:6743100 - SQLNET.OUTBOUND_CONNECT_TIMEOUT CAUSES SQLPLUS TO HANG WITH NTS AUTHENTICATION