Remote Oracle Net Connections Hang at Authentication Point (Doc ID 1302367.1)

Last updated on SEPTEMBER 06, 2017

Applies to:

Oracle Net Services - Version 11.1.0.7 and later
Information in this document applies to any platform.
***Checked for relevance on 23-OCT-2013***

Symptoms

Something may occur where there is a connectivity problem between clients or servers and a remote Database such as a Standby or DR site. What happens with a SQL*Plus test is that any attempt to connect results in a hang while a local loopback on the Database server using the same TNS connect string and listener works fine.
For example, on the remote client or server:
sqlplus username/password@Remote_sid --> hangs

On the local Database:
sqlplus username/password@Remote_sid --> connects

An interesting fact is when the wrong username or password is deliberately given (for test purposes), then the ORA-1017 is returned, indicating that the Listener has, in fact, located a Database and handed off the client connection.

Changes

This may be a new installation but no changes have been observed from an Oracle standpoint

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