TNS-12537: TNS:connection closed TNS-12560: TNS:protocol adapter error TNS-00507: Connection closed...Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) TNS-12541: TNS:no listener TNS...-12560: TNS:protocol adapter error TNS-00511: No listener Linux Error: 111: Connection refused Connecting...to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))) TNS-12541: TNS:no listener TNS...-12560: TNS:protocol adapter error TNS-00511: No listener Linux Error: 111: Connection refused 查看主机名
1 [oracle@localhost ~]$ lsnrctl start 2 3 LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 06...All rights reserved. 6 7 Starting /opt/oracle/11g/bin/tnslsnr: please wait... 8 9 TNSLSNR for Linux...listener/alert/log.xml 12 Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) 13 TNS...-12555: TNS:permission denied 14 TNS-12560: TNS:protocol adapter error 15 TNS-00525: Insufficient...privilege for operation 16 Linux Error: 1: Operation not permitted 17 18 Listener failed to start
马上登录到服务器里查看监听状态,发现有TNS-12541 ,TNS-12560等错误 手动把监听服务启动,这时候服务状态上显示为已启动,但在CMD窗口执行lsnrctl status的时候依然返回错误信息...正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=john-PC)(PORT= TNS-12541: TNS: 无监听程序 TNS-12560: TNS:...协议适配器错误 TNS-00511: 无监听程序 32-bit Windows Error: 61: Unknown error 正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL...三、解决方案步骤 **网上有个解决TNS-12535错误的案例,平台和版本都很类似,如下: 1、在 sqlnet.ora文件中 增加如下行: DIAG_ADR_ENABLED = OFF 2、在listener.ora...LSNRCTL>set log_file mylog Will yield: TNS-01251: Cannot set trace/log directory under ADR.
-12545: Connect failed because target host or object does not exist TNS-12560: TNS:protocol adapter...error TNS-00515: Connect failed because target host or object does not exist Linux Error: 99: Cannot...12560 12560, 00000, "TNS:protocol adapter error" // *Cause: A generic protocol adapter error occurred...-12543: TNS:destination host unreachable TNS-12560: TNS:protocol adapter error TNS-00513: Destination...4、小结 a、对于TNS-12545,TNS-00515应首先考虑是否使用了合适的IP,主机名,应检查服务器host文件,网络配置等 b、Step a检查完后应考虑是否正确的配置了监听以及tnsnames
windows平台个一如下操作:开始---程序---管理工具---服务,打开服务面板,启动oraclehome92TNSlistener服务。
for Linux: Version 11.2.0.1.0 - Production Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.1.0...: 12560 nt main err code: 0 nt secondary err code: 0 nt OS err code: 0 opiodr aborting process...: 12560 nt main err code: 0 nt secondary err code: 0 nt OS err code: 0 opiodr aborting process...: 12560 nt main err code: 0 nt secondary err code: 0 nt OS err code: 0 opiodr aborting process...: 12560 nt main err code: 0 nt secondary err code: 0 nt OS err code: 0 opiodr aborting process
no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener Linux Error: 111: Connection...refused Connecting to (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)) start TNS-12541: TNS:no listener TNS-12560...-12555: TNS:permission denied TNS-12560: TNS:protocol adapter error TNS-00525: Insufficient privilege...:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener Linux Error: 111: Connection...refused Connecting to (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)) startTNS-12541: TNS:no listener TNS-12560
前言 我在控制台重启oracle服务端监听lsnrctl start的时候 报错:ORA-12560: TNS: 协议适配器错误 解决方法 一:检查监听口是否开启。
在 Linux下启动Oracle服务需要下面两步: 启动lsnrctl监听。 启动数据库实例。...Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=wl1)(PORT=1521))) TNS-12541: TNS:no listener...TNS-12560: TNS:protocol adapter error TNS-00511: No listener Linux Error: 111: Connection refused...Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) TNS-12541: TNS:no listener TNS...-12560: TNS:protocol adapter error TNS-00511: No listener Linux Error: 111: Connection refused 启动监听
LSNRCTL for Linux...oracle@test ~]$ lsnrctl stop listener_demo92 LSNRCTL for Linux...-12541: TNS:no listener TNS-12560: TNS:protocol...Linux Error: 111: Connection refused Connecting to (DESCRIPTION...TNS-12560: TNS:protocol adapter error TNS-00511: No listener
使用tnsping dcsopen测试,报错: ora11g>tnsping dcsopen TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production...检查监听器状态, ora11g>lsnrctl status LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 08-JAN-2015 01...-12560: TNS:protocol adapter error 执行sqlplus ......ERROR: ORA-12560: TNS:protocol adapter error 于是先看看端口是否开通,执行telnet报错: ora10g@localhost.localdomain$telnet...远程访问tnsping和sqlplus报错TNS-12560: TNS:protocol adapter error,说明可能两台机器之间的连接有问题而不是监听自身的问题。
应用服务器:Windows Server 2008 R2 Enterprise 故障现象:项目侧同事反映应用服务器上的程序连接数据库报错:ORA-12560: TNS: 协议适配器错误 1.故障重现...2.定位问题 3.解决问题 1.故障重现 在应用服务器上使用sqlplus和PL/SQL工具登录 连接数据库服务器均报错: ``` ORA-12154: TNS: 无法解析指定的连接标识符 ```...-12560:TNS:协议适配器错误 C:\Users\Administrator>tnsping 192.168.1.100 TNS Ping Utility for 32-bit Windows:...-12560: TNS: 协议适配器错误 2.3 登录数据库主机 SecureCRT工具登录数据库主机服务器报错: An operation on a socket could not be performed...3.解决问题 3.1 两个ORA错误的官方解释 ORA-12560 $ oerr ora 12560 12560, 00000, "TNS:protocol adapter error" // *
带着疑问我根据他提供的基本信息定位到了数据库服务端的端口,查看监听器的日志,发现下面的一段内容: 09-JUN-2017 10:06:46 * * 12537 TNS...-12537: TNS:connection closed TNS-12560: TNS:protocol adapter error TNS-00507: Connection closed...Linux Error: 115: Operation now in progress 09-JUN-2017 10:06:54 * * 12537 TNS...-12537: TNS:connection closed TNS-12560: TNS:protocol adapter error TNS-00507: Connection closed...Linux Error: 115: Operation now in progress 这是一个12c的环境,这个CDB里面有大概8个PDB,所以我得定位到具体的PDB继续测试。
VERSION INFORMATION: TNS for Linux: Version 12.2.0.1.0 - Production Oracle Bequeath NT Protocol Adapter...for Linux: Version 12.2.0.1.0 - Production TCP/IP NT Protocol Adapter for Linux: Version 12.2.0.1.0...12560 nt main err code: 505 TNS-00505: Operation timed out nt secondary err code: 110 nt OS err code...VERSION INFORMATION: TNS for Linux: Version 12.2.0.1.0 - Production Oracle Bequeath NT Protocol Adapter...12560 nt main err code: 505 TNS-00505: Operation timed out nt secondary err code: 110 nt OS err code
[root@web02 ~]# su - oracle [oracle@web02 ~]$ lsnrctl start 出现如下错误提示信息: LSNRCTL for Linux: Version...Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=web02)(PORT=1521))) TNS-12535: TNS:operation... timed out TNS-12560: TNS:protocol adapter error TNS-00505: Operation timed out Connecting to...---------------------- Alias LISTENER Version TNSLSNR for Linux...listener supports no services The command completed successfully 这样启动后远程连接会报错: oracle ORA-12514:TNS
listener日志中出现TNS-12518: TNS:listener could not hand off client connection。即Listener无法分发客户端连接。...network/log> tail listener_sywgmr.log TNS-12547: TNS:lost contact TNS-12560: TNS:protocol adapter...error TNS-00517: Lost contact Linux Error: 32: Broken pipe 27-MAR-2014 11:02:38 * (CONNECT_DATA...-12518: TNS:listener could not hand off client connection TNS-12547: TNS:lost contact TNS-12560: TNS...:protocol adapter error TNS-00517: Lost contact Linux Error: 32: Broken pipe oracle@SZDB:~> oerr
Keyword: ORA-12560 ORA-12557 BEQ 数据库连接 登录 ##问题: Windows环境下进行数据库登陆时,发生ORA-12560/ORA-12557错误。...> oerr ora 12560 12560, 00000, "TNS:protocol adapter error" // *Cause: A generic protocol adapter error...> oerr ora 12557 12557, 00000, "TNS:protocol adapter not loadable" // *Cause: On some platforms...通常来讲,ORA-12560和ORA-12557错误常常是由于环境变量等设置不正确引起, 本文介绍连接错误基本的解决思路和方法。...错误 TNS-12537: TNS:connection closed ns secondary err code: 12560 nt main err code: 0 nt
排错-windows下_ORA-12560 TNS 协议适配器错误解决方法 by:授客 问题描述: 修改SQL*Plus窗口属性后,重新打开SQL*Plus时出现ORA-12560: TNS:...协议适配器错误 原因分析: ORA-12560: TNS: 协议适配器错误的问题的原因有三个: 1.
LSNRCTL> status 正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) TNS-12541: TNS: 无监听程序...TNS-12560: TNS: 协议适配器错误 TNS-00511: 无监听程序 64-bit Windows Error: 2: No such file or directory 正在连接到...-12560: TNS: 协议适配器错误 TNS-00515: 因目标主机或对象不存在, 连接失败 64-bit Windows Error: 1001: Unknown error LSNRCTL...-12545: 因目标主机或对象不存在, 连接失败 TNS-12560: TNS: 协议适配器错误 TNS-00515: 因目标主机或对象不存在, 连接失败 64-bit Windows Error...-12545: 因目标主机或对象不存在, 连接失败 TNS-12560: TNS: 协议适配器错误 TNS-00515: 因目标主机或对象不存在, 连接失败 64-bit Windows Error
一、确认故障 1.1 服务器尝试sysdb登录 1.2 服务器尝试通过网络连接 二、排查原因 2.1 ORA-12560错误初步排查原因 2.2 ORA-12518错误排查原因 2.3 ORA-12560...ERROR: ORA-12560: TNS: 协议适配器错误 1.2 服务器尝试通过网络连接 PS C:\Users\Administrator> sqlplus system/oracle@xxoradb...ERROR: ORA-12518: TNS: 监听程序无法分发客户机连接 二、排查原因 2.1 ORA-12560错误初步排查原因 ORA-12560错误官方说明: $ oerr ora 12560...12560, 00000, "TNS:protocol adapter error" // *Cause: A generic protocol adapter error occurred....ERROR: ORA-12560: TNS: 协议适配器错误 请输入用户名: 这时候就怀疑可能是机器上安装了多个Oracle程序导致,也就是说这个sqlplus命令可能是某个客户端的sqlplus程序
领取专属 10元无门槛券
手把手带您无忧上云