Sqlplus / As Sysdba Hangs Using Local Beq Connection on Windows (Doc ID 473630.1)

Last updated on APRIL 20, 2015

Applies to:

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


Symptoms

Sqlplus hangs when you try to logon as an administrative user using OS authentication with the NTS adapter.

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)
 
  
  

Diagnostic analysis reveals the following Call Stack Trace of the client sqlplus.exe program:

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

Changes

You have set the following parameter in the sqlnet.ora file:

SQLNET.OUTBOUND_CONNECT_TIMEOUT = 10

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms