My Oracle Support Banner

Remote Clients Receive ORA-12160 or ORA-12561 Errors Connecting To 11GR2 RAC Via SCAN Listeners (Doc ID 1291985.1)

Last updated on JANUARY 30, 2022

Applies to:

Oracle Net Services - Version 11.2.0.2 to 11.2.0.3 [Release 11.2]
Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.2.0 [Release 11.2]
Information in this document applies to any platform.

Symptoms


You see either of the following errors reported while trying to connect to RAC database using SCAN name from remote client machines.  But able to connect via the very same SCAN Listeners directly from the RAC servers or on the local LAN as the RAC Servers as well as from the remote clients if referencing the local or physical TNS Listeners running on the VIP addresses.

Errors reported:

ORA-12160: TNS:internal error: Bad error number

or:

ORA-12561: TNS:unknown error


Changes

No known changes, but problem only affects or is reported by "remote" clients when trying to use the SCAN Addresses.

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.