Sqlplus login to oracle error ORA-12560: TNS: protocol adapter Error
C: \ Users \ Administrator> setORACLE_SID = DDBC
C: \ Users \ Administrator> SQLPLUS/AS SYSDBA
SQL * Plus: Release 11.2.0.1.0 Production on Monday September 9 16: 41: 392013
Copyright (c) 1982,201 0, Oracle. All rights reserved.
ERROR:
ORA-12560: TNS: protocol adapter error.
Enter the User Name:
First, check oracle's official explanation of 12560:
ORA-12560: TNS: protocol adapter error
Cause:A generic protocol adapter error occurred.
Action:Check addresses used for proper protocolspecification. before reporting this error, look at the error stack and checkfor lower level transport errors. for further details, turn on tracing andreexecute the operation. turn off tracing when the operation is complete.
So check the current database. Because the database server has an oracle client installed at the same time, when setORACLE_SID = sid, it should be in the client Directory, so you can confirm, directly go to the server directory to view:
C: \ Users \ Administrator> cdC: \ app \ Administrator \ product \ 11.2.0 \ dbhome_1 \ BIN
C: \ app \ Administrator \ product \ 11.2.0 \ dbhome_1 \ BIN> setORACLE_SID = DDBC
C: \ app \ Administrator \ product \ 11.2.0 \ dbhome_1 \ BIN> sqlplus/as sysdba
SQL * Plus: Release 11.2.0.1.0 Production on Monday September 9 16:47:002013
Copyright (c) 1982,201 0, Oracle. All rights reserved.
Connect:
OracleDatabase 11g Enterprise Edition Release 11.2.0.1.0-64bit Production
With thePartitioning, OLAP, Data Mining and Real Application Testing options
SQL> selectstatus from v $ instance;
STATUS
------------
OPEN
SQL>
This indicates that the client is used for logon to sqlplus, but the server variable is SET in the environment variable administrator, but it still does not work. Check the environment variable SET:
Path = E: \ app \ Administrator \ product \ 11.2.0 \ client_1 \ bin; C: \ app \ Administrator \ product \ 11.2.0 \ dbhome_1 \ bin ;..................
It turns out that this problem occurs only when the path is set in the system with a high priority. You can modify the path.
Also want to say is to search for ORA-1256090 on the Internet % are that 4 steps, but 99% did not solve the problem. Therefore, we must think carefully to solve the problem.
This article is from the bug blog, please be sure to keep this source http://worms.blog.51cto.com/969144/1293265