My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.