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

Last updated on OCTOBER 30, 2016

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:

[30-MAR-2009 19:46:41:208] niqme: reporting NS-12564 error as ORA-12564 
[30-MAR-2009 19:46:41:208] niqme: exit 
[30-MAR-2009 19:46:41:208] niomapnserror: exit 
[30-MAR-2009 19:46:41:208] niqme: entry 
[30-MAR-2009 19:46:41:208] niqme: reporting NSG-12504 error as ORA-12504

Changes

This is likely a new installation.

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