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 10.1.0.3 to 12.1.0.2 [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

Symptoms

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:

Changes

This is likely a new installation.

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.