很可能Oracle服务尚未启动。请打开powershell并使用检查
Oracle Database - Enterprise Edition - Version 10.1.0.2 and later: Local SQL*Plus Connection failing with ORA-12560: TNS:protocol adapter error
12560, 00000, "TNS:protocol adapter error" // *Cause: A generic protocol adapter error occurred. // *Action: Check addresses used for proper protocol specification. Before // reporting this error, look at the error stack and check for lower level // transport errors. For further details, t...
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 ...
当安装了Oracle数据库和ODAC后,用PL\SQL dev可以正常连接数据库,但是在SQLplus中连接时会提示"ORA-12560:TNS:协议适配器错误",解决此问题的方法为:将环境变量path中的dbhome_1\BIN放到client_1\bin的前面即可,即将图1改为图2。 修改前: 修改后:
12560, 00000, "TNS:protocol adapter error" // *Cause: A generic protocol adapter error occurred. // *Action: Check addresses used for proper protocol specification. Before // reporting this error, look at the error stack and check for lower level ...
TNS-12560: TNS:protocol adapter error SOLUTION techji membership Create a free account to see this answer Signing up is free and takes 30 seconds.No credit card required. See answer ASKER >modify your listener.ora to this - >SID_LIST_LISTENER = ...
远程访问tnsping和sqlplus报错TNS-12560: TNS:protocol adapter error,说明可能两台机器之间的连接有问题而不是监听自身的问题。 3. telnet报错是No route to host,不是Connection refused,不可轻易认为是网络端口未开。因为此时表示可以正常访问到另一台远程机器了,应该考虑到是否是防火墙的问题。此时可以通过关闭防火墙...
ERROR: ORA-12560: TNS:protocol adapter error 于是先看看端口是否开通,执行telnet报错: ora10g@localhost.localdomain$telnet 172.101.19.57 1521 Trying 172.101.19.57... telnet: connect to address 172.101.19.57:No route to host 如果端口未开,实际报错: ...
cx_Oracle.DatabaseError: ORA-12560: TNS:protocol adapter error System information: Oracle 12c Protocol: TCPS Instant client Version: 12_1 Local system type: MAC cx_Oracle Version : 5.3 Member anthony-tuininga commented on Mar 28, 2017 I see you have already opened this in cx_Oracle issues...