Windows: Local or Bequeath Connections As Sysdba Fail With TNS-12557 or TNS-12560
Last updated on JULY 01, 2016
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 to 188.8.131.52 [Release 8.1.7 to 11.2]
Oracle Net Services - Version 184.108.40.206 to 220.127.116.11 [Release 8.1.7 to 11.2]
Microsoft Windows x64 (64-bit)
Microsoft Windows (32-bit)
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:
SQL*Plus: Release 10.1.0.4.2 - Production on Mon Oct 16 08:44:52 2006
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> connect sys/**** as sysdba
ORA-12557: TNS:protocol adapter not loadable
You might also see the following error ORA-12560:D:\oracle\product\18.104.22.168.0\database>set ORACLE_SID=mysid
SQL*Plus: Release 22.214.171.124.0 - Production on Fri Jul 18 04:48:54 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter user-name: / as sysdba
ORA-12560: TNS:protocol adapter error
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.
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