很可能Oracle服务尚未启动。请打开powershell并使用检查
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...
当安装了Oracle数据库和ODAC后,用PL\SQL dev可以正常连接数据库,但是在SQLplus中连接时会提示"ORA-12560:TNS:协议适配器错误",解决此问题的方法为:将环境变量path中的dbhome_1\BIN放到client_1\bin的前面即可,即将图1改为图2。 修改前: 修改后:
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主服务和监听器服务已经启动,使用SQL Plus能够正常连接,使用PL SQL Developer连接报次错误:ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务。如图: 解决: 打开H:\Oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN(不同机器目录可能不同)目录下的listener.ora文件,发现此文件内容如下: ...
Oracle Database - Enterprise Edition - Version 10.1.0.2 and later: Local SQL*Plus Connection failing with ORA-12560: TNS:protocol adapter error
远程访问tnsping和sqlplus报错TNS-12560: TNS:protocol adapter error,说明可能两台机器之间的连接有问题而不是监听自身的问题。 3. telnet报错是No route to host,不是Connection refused,不可轻易认为是网络端口未开。因为此时表示可以正常访问到另一台远程机器了,应该考虑到是否是防火墙的问题。此时可以通过关闭防火墙...
Listener refused the connection with the following error: 1. 1. ORA-12514, TNS:listener does not currently know of service requested in connect descriptor 1. 1. 供应商代码 12514 1. 几年前写过一篇关于”ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务“的案例文章,现在看来当时写的...
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) ) ) Trying to connect from OS, in order to shutdown and start up database, but no success: C:\>SET ORACLE_SID=OPINT C:\>sqlplus /nolog SQL*Plus: Release 10.1.0.4.0 - Production on Tue Sep 12 14:36:30 2006 ...
SQL> >>> cx.connect('username','password','TNS_LSNR') Traceback (most recent call last): File "", line 1, in 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 ...