马上登录到服务器里查看监听状态,发现有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.
最近开发环境的oracle数据库经常ORA-12541: TNS:no listener error错误，让人很头疼。
LSNRCTL> tatus Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=oel.oracle.com)(PORT=1521)) TNS-12541: TNS:...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...LSNRCTL> status Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=oel.oracle.com)(PORT=1521)) TNS-12541: TNS...refused Connecting to (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)) startTNS-12541: TNS:no listener TNS-12560
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 查看主机名
OracleServiceORCL服务 1.首先查看oracle12c监听服务是否启动 2. ping 本地id是否能ping通 3.检测配置监听是否有错误: 找到 Oracle 监听配置文件（listener.ora）和TNS...192.168.1.139)(PORT = 1521)) ) ) 4.重新配置监听器Net Configuration Assistant 具体配置参考【oracle常见错误】oracle监听程序配置/“ORA-12541...: TNS: 无监听程序” - yxtic - 博客园 5.之后重启OracleServiceORCL服务 基本情况就以上几种 我也踩过一次坑 所以就记录下来了
在 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 启动监听
s2gamebbs.test.com)(PORT = 1528)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = gamebbs))) TNS...-12541: TNS:no listener 是监听没启动吗，查看监听进程存在，确实是启动了，但是查看监听状态却抛出了错误 LSNRCTL> status listener_1528 Connecting...to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=s2gamebbs.test.com)(PORT=1528))) TNS-12541: TNS:no listener...TNS-12560: TNS:protocol adapter error TNS-00511: No listener Linux Error: 111: Connection refused
LSNRCTL for Linux...-12541: TNS:no listener TNS-12560: TNS:protocol...Linux Error: 111: Connection refused Connecting to (DESCRIPTION...=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC))) TNS-12541: TNS:no listener...TNS-12560: TNS:protocol adapter error TNS-00511: No listener
2015-09-15 22:06:19.0 Log Transport ServicesErrorError 12541 received logging on to the standby 2015-...Error is 12541. 看样子是心跳的检测失败了，看来主库和备库之间的网络可能出现了延迟之类的问题，在最大性能模式下，这个还是能够接受的，当时就没有在意。...lsnrctl start listener LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 14-SEP-2015 23:27:38 Copyright...TNS-12547: TNS:lost contact TNS-12560: TNS:protocol adapter error TNS-00517: Lost contact Linux
1.问题描述 在linux服务器centos7上新安装的oracle 19c，结果发现客户端怎么都连不上。...Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.161.120)(PORT=1521))) TNS-12541: TNS:...no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener Linux Error: 111: Connection...Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.161.120)(PORT=1521))) TNS-12541: TNS:...no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener Linux Error: 111: Connection
处理 1.登陆到oracle数据库服务器 [root@lzdk ~]# su - oracle 2.查看监听状态 [oracle@lzdk ~]$ lsnrctl status LSNRCTL for Linux...Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.91.116)(PORT=1521))) TNS-12541: TNS:no...listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener Linux Error: 111: Connection refused...3.发现监听状态异常，先尝试手动启动监听 [oracle@lzdk ~]$ lsnrctl start LSNRCTL for Linux: Version 11.2.0.4.0 - Production...TNSLSNR for Linux: Version 11.2.0.4.0 - Production System parameter file is /u01/app/oracle/product/11.2.0
杨大师(http://space.itpub.net/4227/viewspace-663069)介绍过TWO_TASK环境变量的作用，指出“在Unix和Linux环境下，可以设置TWO_TASK环境变量...此时关闭本地库bisal的监听： LSNRCTL> stop bisal 验证监听状态： [oracle@liu Desktop]$ tnsping bisal TNS Ping Utility...for Linux: Version 10.2.0.1.0 - Production on 11-AUG-2013 15:06:18 Copyright (c) 1997, 2005, Oracle...-12541: TNS:no listener 再次连接bisal库： [oracle@liu Desktop]$ sqlplus bisal/xxx@bisal SQL*Plus: Release...ERROR: ORA-12541: TNS:no listener Enter user-name: 打开监听，再用@bisal的方式连接bisal本地库： [oracle@liu Desktop
1、ORA-12560：TNS：协议适配器错误 OracleService服务没有启动 2、 ORA-12541：TNS：无监听程序 OracleTNSListener...服务没有启动 3、ORA-12514：TNS：监听程序当前无法识别连接描述符中请求的服务 一般出现在TNSListener刚刚启动之后。
'TEST' and job_name='LOAD_PEIPING' and rownum<10 1662118 02-MAR-16 02.00.00.512815 AM +08:00 ORA-12541...: TNS:no listener ORA-06512: at line 2 1661601 01-MAR-16 02.00.00.416300 AM +08:00 ORA-12541: TNS...:no listener 信息显示在最近两天JOB确实都执行了，但是抛出了ORA-12541的错误，相关联的一个错误是TNS的错误。...TCP)(HOST = 10.127.xxxxx)(PORT = 1529))) (CONNECT_DATA = (SERVICE_NAME = gcdb)(server=dedicated))) TNS...-12541: TNS:no listener ORA-06512: at line 2 明白了这一点之后，问题的分析就很顺畅了。
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
当我们更换ip地址时，会遇到这样的报错，这是由于ip地址改变引起的“ORA-12541:TNS:无监听程序”错误。
-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...-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...c、对于上述该类错误，应同时检查及分析监听器日志 d、对于客户端出现TNS-12545，TNS-00515等，考虑客户端能否将主机转换成对应的IP(客户端tnsnames.ora使用主机名的情形时
Windows 8.1 以上及 Windows Server 2012 以上版本，没办法都已经下载了，那就安装一下折腾折腾看具体会出现什么问题吧（PS：这里墙裂建议使用 Windows 10 或者 Linux...正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=JiekeXu)(PORT=1521) TNS-12541: TNS: 无监听程序 TNS-12560:...TNS: 协议适配器错误 TNS-00511: 无监听程序 64-bit Windows Error: 61: Unknown error 正在连接到 (DESCRIPTION=(ADDRESS...=(PROTOCOL=IPC)(KEY=EXTPROC1521))) TNS-12557: TNS: 协议适配器不可加载 TNS-12560: TNS: 协议适配器错误 TNS-00527: 协议适配器不可加载
TNS-12531: TNS: 无法分配内存 解决方案 针对故障信息： 22-3月 -2019 06:21:54 * 12531 TNS-12531: TNS: 无法分配内存 解决优化方案： 方案一
for Linux: Version 11.2.0.1.0 - Production Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.1.0...Tns error struct: ns main err code: 12537 TNS-12537: TNS:connection closed ns secondary err code...for Linux: Version 11.2.0.1.0 - Production Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.1.0...Tns error struct: ns main err code: 12537 TNS-12537: TNS:connection closed ns secondary err code...Tns error struct: ns main err code: 12537 TNS-12537: TNS:connection closed ns secondary err code
领取专属 10元无门槛券
手把手带您无忧上云
云服务器
ICP备案
实时音视频
即时通信 IM
对象存储
