Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=oel.oracle.com)(PORT=1521)) TNS-12541: TNS:no listener TNS...to (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)) start TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter...=1521))) Error listening on: (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)) TNS-12555: TNS:permission denied TNS...Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=oel.oracle.com)(PORT=1521)) TNS-12541: TNS:no listener TNS...to (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)) startTNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter
Oracle启动监听报错,提示 连接中断 [oracle@localhost ~]$ lsnrctl start LSNRCTL for Linux: Version 11.2.0.1.0 - Production...TNS-12537: TNS:connection closed TNS-12560: TNS:protocol adapter error TNS-00507: Connection closed...LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 06-AUG-2014 20:02:48 Copyright (c) 1991, 2009...Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) TNS-12541: TNS:no listener TNS...to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))) TNS-12541: TNS:no listener TNS
在 Linux下启动Oracle服务需要下面两步: 启动lsnrctl监听。 启动数据库实例。.../lsnrctl status LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 22-AUG-2018 20:28:21 Copyright...Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=wl1)(PORT=1521))) TNS-12541: TNS:no listener TNS...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...(PORT=1521))) TNS-12541: TNS:no listener TNS...TNS-00511: No listener Linux...EXTPROC))) TNS-12541: TNS:no listener TNS
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...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
,发现下面的一段内容: 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
@SZDB:/users/oracle/OraHome10g/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...* 12518 TNS-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
1.问题描述 在linux服务器centos7上新安装的oracle 19c,结果发现客户端怎么都连不上。...login: Thu Jul 21 16:50:06 CST 2022 on pts/0 查看监听状态: [oracle@mv161p120 ~]$ lsnrctl status LSNRCTL for Linux...(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.161.120)(PORT=1521))) TNS-12541: TNS:no listener TNS...(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.161.120)(PORT=1521))) TNS-12541: TNS:no listener TNS...TNSLSNR for Linux: Version 19.0.0.0.0 - Production System parameter file is /opt/oracle/product/19c/dbhome
LSNRCTL for Linux: Version 10.2.0.3.0 - Production on 08-JUL-2014 17:05:49 Copyright (c) 1991, 2006,...TNSLSNR for Linux: Version 10.2.0.3.0 - Production System parameter file is /users/oracle/OraHome10g/...=10.101.1.106)(PORT=1520))) TNS-12545: Connect failed because target host or object does not exist TNS...#故障环境 oracle@sysreportDB:/users/oracle> cat /etc/issue Welcome to SUSE Linux Enterprise Server 10 SP4...(ADDRESS=(PROTOCOL=TCP)(HOST=sysreportDB)(PORT=1520))) TNS-12543: TNS:destination host unreachable TNS
[root@web02 ~]# su - oracle [oracle@web02 ~]$ lsnrctl start 出现如下错误提示信息: LSNRCTL for Linux: Version...DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=web02)(PORT=1521))) TNS-12535: TNS:operation timed out TNS...---------------------- Alias LISTENER Version TNSLSNR for Linux
处理 1.登陆到oracle数据库服务器 [root@lzdk ~]# su - oracle 2.查看监听状态 [oracle@lzdk ~]$ lsnrctl status LSNRCTL for Linux...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 on 22-FEB...TNSLSNR for Linux: Version 11.2.0.4.0 - Production System parameter file is /u01/app/oracle/product/11.2.0
Windows 8.1 以上及 Windows Server 2012 以上版本,没办法都已经下载了,那就安装一下折腾折腾看具体会出现什么问题吧(PS:这里墙裂建议使用 Windows 10 或者 Linux...正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=JiekeXu)(PORT=1521) TNS-12541: TNS: 无监听程序 TNS-12560:...Unknown error 正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) TNS-12557: TNS: 协议适配器不可加载 TNS
马上登录到服务器里查看监听状态,发现有TNS-12541 ,TNS-12560等错误 手动把监听服务启动,这时候服务状态上显示为已启动,但在CMD窗口执行lsnrctl status的时候依然返回错误信息...正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=john-PC)(PORT= TNS-12541: TNS: 无监听程序 TNS-12560: TNS:
LSNRCTL> status 正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) TNS-12541: TNS: 无监听程序 TNS...正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=Admin.JAVA)(PORT=1521))) TNS-12545: 因目标主机或对象不存在, 连接失败 TNS...监听该对象时出错: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=Admin.JAVA)(PORT=1521))) TNS-12545: 因目标主机或对象不存在, 连接失败 TNS...监听该对象时出错: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=Admin.JAVA)(PORT=1521))) TNS-12545: 因目标主机或对象不存在, 连接失败 TNS
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 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
,丢失 = 0 (0% 丢失), 往返行程的估计时间(以毫秒为单位): 最短 = 0ms,最长 = 0ms,平均 = 0ms 2.2 tnsping测试端口 tnsping 数据库IP地址,报错:TNS...DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST =192.168.1.100)(PORT=1521))) TNS
DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=s3nstatdb.test.com)(PORT=1528))) TNS-12547: TNS:lost contact TNS...-12560: TNS:protocol adapter error TNS-00517: Lost contact Linux Error: 104: Connection reset by
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))) TNS-12541: TNS:no listener TNS-12560...在Linux上调用truss跟踪一个操作非常简单,以下跟踪了lsnrctl start操作的过程: truss lsnrctl start execve("/usr/bin/lsnrctl", 0x2FF22BF8...listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))) TNS-12555: TNS:permission denied TNS
检查监听器状态, ora11g>lsnrctl status LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 08-JAN-2015 01...------------------------ Alias LISTENER Version TNSLSNR for Linux...启动监听,提示: ora11g>lsnrctl status LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 08-JAN-2015 01...= (PROTOCOL = TCP)(HOST = 172.101.19.57)(PORT = 1521))) (CONNECT_DATA = (service_name = dcsopen))) TNS...远程访问tnsping和sqlplus报错TNS-12560: TNS:protocol adapter error,说明可能两台机器之间的连接有问题而不是监听自身的问题。
领取专属 10元无门槛券
手把手带您无忧上云