ORA-12560: TNS: protocol adapter error.

Source: Internet
Author: User

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.