Windows: Local or Bequeath Connections As Sysdba Fail With TNS-12557 or TNS-12560
(Doc ID 397231.1)
Last updated on MARCH 31, 2022
Applies to:
Oracle Database Backup Service - Version N/A and laterOracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 8.1.7.0 to 11.2.0.4 [Release 8.1.7 to 11.2]
Oracle Net Services - Version 8.1.7.4 to 11.2.0.4 [Release 8.1.7 to 11.2]
Microsoft Windows x64 (64-bit)
Microsoft Windows (32-bit)
Symptoms
With a single installation of an older version Oracle database it was possible to use SQL*Plus with "connect / as sysdba" to make a local connection to the database. Since installing a higher version of product into a separate Oracle home, this method has started to fail with the following error:
Changes
This problem can arise when another installation of Oracle products into a separate ORACLE_HOME would cause this problem as it has changed the environment.
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 |