My Oracle Support Banner

Windows: Remote SQL*Plus Connections Hang Indefinitely (Doc ID 390400.1)

Last updated on MARCH 31, 2022

Applies to:

Oracle Net Services - Version to [Release 10.1 to 12.1]
Microsoft Windows x64 (64-bit) - Version: 2008 R2
This document is limited in scope to connections on Windows servers. The


Remote SQL*Plus connections to newly created database hang indefinitely.  Local connections are successful.  Listener and database are installed in same ORACLE_HOME.  No errors reported in listener.log.  Connection shows 'established'.  There may be no errors in a sqlnet trace, depending on the version of client.  In some versions, you may find the following stack in a client trace:


This is likely a new installation.


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

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