RAC - Connections Intermittently Fail With: ORA-12502: no CONNECT_DATA from client
(Doc ID 2550216.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Net Services - Version 11.2.0.4 and laterInformation in this document applies to any platform.
Symptoms
Remote connections using SQL*Plus are intermittently failing with the following error:
ORA-12502: TNS:listener received no CONNECT_DATA from client
For example:
SQLPLUS username@<TNS _ALIAS>
Password:
SQL*Plus: Release 11.2.0.1.0 Production on Thu May 16 14:59:48 2019
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Enter password:
ERROR: ORA-12502: no CONNECT_DATA from client
Changes
This is either a new implementation of RAC or some configuration changes have taken place.
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 |