作者:路勇 南京恩瑞特有限公司 近日公司软件应用客户端连接数据库时不时出现ORA-12560错误,通过PL/SQL工具、NetManager工具测试连接数据服务器都正常,上网查找ORA-12560方法解决尝试以后都没有成功...在sqlnet.ora文件中开启日志记录功能 文件位置,”D:\app\lenovo\product\11.2.0\client_1\network\admin”,根据自己按照路径获取修改。...分析OracleLog日志 产生ORA-12560日志如下: connection refused - trying again in 16 seconds....nserror: nsres: id=0, op=65, ns=12560, ns2=0; nt[0]=530, nt[1]=55, nt[2]=0; ora[0]=0, ora[1]=0, ora[2
应用服务器:Windows Server 2008 R2 Enterprise 故障现象:项目侧同事反映应用服务器上的程序连接数据库报错:ORA-12560: TNS: 协议适配器错误 1.故障重现...= 0 (0% 丢失), 往返行程的估计时间(以毫秒为单位): 最短 = 0ms,最长 = 0ms,平均 = 0ms 2.2 tnsping测试端口 tnsping 数据库IP地址,报错:TNS-12560...DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST =192.168.1.100)(PORT=1521))) TNS-12560...3.解决问题 3.1 两个ORA错误的官方解释 ORA-12560 $ oerr ora 12560 12560, 00000, "TNS:protocol adapter error" // *...ORA-12154 $ oerr ora 12154 12154, 00000, "TNS:could not resolve the connect identifier specified" /
windows平台个一如下操作:开始---程序---管理工具---服务,打开服务面板,启动oraclehome92TNSlistener服务。
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...通常来讲,ORA-12560和ORA-12557错误常常是由于环境变量等设置不正确引起, 本文介绍连接错误基本的解决思路和方法。...##解决错误的基本思路: 1.确认用户连接方法和数据库认证方式,是否使用了Listener监听登陆,在BEQ登陆的方式下是否有同样的问题 2.查看网络相关的配置文件sqlnet.ora、listener.ora...= (NTS) 3.查看警日志alert和trace,有相关的TNS错误 TNS-12537: TNS:connection closed ns secondary err code: 12560
一、确认故障 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...2.3 ORA-12560错误再次排查原因 上面解决了客户端的连接问题,但问题还没有完美解决,因为目前本地sysdba仍然还是无法登陆,依然报错ORA-12560: C:\Users\Administrator...ERROR: ORA-12560: TNS: 协议适配器错误 请输入用户名: 这时候就怀疑可能是机器上安装了多个Oracle程序导致,也就是说这个sqlplus命令可能是某个客户端的sqlplus程序
在windows服务器上 cmd sqlplus 用户名/密码 连接 报ORA-12560 (协议适配器错误啥的) 解决办法如下: 1.再原命令上 增加@127.0.0.1/实例 sqlplus 用户名
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=oel.oracle.com)(PORT=1521)) TNS-12541: TNS:no listener TNS-12560...error TNS-00511: No listener Linux Error: 111: Connection refused LSNRCTL> Starting /u01/app/ora10g...TNSLSNR for Linux: Version 10.2.0.1.0 - Production System parameter file is /u01/app/ora10g/product/10.2.0...error TNS-00511: No listener Linux Error: 111: Connection refused LSNRCTL> Starting /u01/app/ora10g...TNSLSNR for Linux: Version 10.2.0.1.0 - Production System parameter file is /u01/app/ora10g/product/10.2.0
error struct: ns main err code: 12537 TNS-12537: TNS:connection closed ns secondary err code: 12560...secondary err code: 0 nt OS err code: 0 opiodr aborting process unknown ospid (3657) as a result of ORA...error struct: ns main err code: 12537 TNS-12537: TNS:connection closed ns secondary err code: 12560...secondary err code: 0 nt OS err code: 0 opiodr aborting process unknown ospid (3666) as a result of ORA...error struct: ns main err code: 12537 TNS-12537: TNS:connection closed ns secondary err code: 12560
前言 我在控制台重启oracle服务端监听lsnrctl start的时候 报错:ORA-12560: TNS: 协议适配器错误 解决方法 一:检查监听口是否开启。...二:找到xxxxx\product\11.2.0\dbhome_1\NETWORK\ADMIN文件夹下的listener.ora文件和tnsnames.ora文件 查看 LISTENER_ORCL
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...to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))) TNS-12541: TNS:no listener TNS-12560.../listener.ora Log messages written to /opt/oracle/diag/tnslsnr/oracle/listener/alert/log.xml Listening...Authentication SNMP OFF Listener Parameter File /opt/oracle/11g/network/admin/listener.ora
LSNRCTL for Linux...oracle@test ~]$ lsnrctl stop listener_demo92 LSNRCTL for Linux...PORT=1521))) TNS-12541: TNS:no listener TNS-12560...TNS-12541: TNS:no listener TNS-12560...配置listener.ora中ADMIN_RESTRICTIONS参数 参数作用: 当在listener.ora文件中设置了ADMIN_RESTRICTIONS参数后,在监听器运行时,
10.101.1.106)(PORT=1520))) TNS-12545: Connect failed because target host or object does not exist TNS-12560...00:00:00 ora_pmon_USMTHLY oracle 5605 1 0 Jul08 ?...file to change the // host name to a numeric IP address and try again. oracle@sysreportDB:~> oerr tns 12560...12560, 00000, "TNS:protocol adapter error" // *Cause: A generic protocol adapter error occurred. //...ADDRESS=(PROTOCOL=TCP)(HOST=sysreportDB)(PORT=1520))) TNS-12543: TNS:destination host unreachable TNS-12560
在 Linux下启动Oracle服务需要下面两步: 启动lsnrctl监听。 启动数据库实例。...Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=wl1)(PORT=1521))) TNS-12541: TNS:no listener TNS-12560...to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) TNS-12541: TNS:no listener TNS-12560: TNS.../12.2.0/dbhome_1/network/admin/listener.ora Log messages written to /home/oracle/app/oracle/diag/tnslsnr...OFF Listener Parameter File /home/oracle/app/oracle/product/12.2.0/dbhome_1/network/admin/listener.ora
1.问题描述 在linux服务器centos7上新安装的oracle 19c,结果发现客户端怎么都连不上。...现在对这个问题进行修改: 2.修改listener.ora 文件 首先要修改listener.ora 文件。...3.修改tnsnames.ora 同理,tnsnames.ora文件也需要修改: # tnsnames.ora Network Configuration File: /opt/oracle/product...DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.161.120)(PORT=1521))) TNS-12541: TNS:no listener TNS-12560...DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.161.120)(PORT=1521))) TNS-12541: TNS:no listener TNS-12560
使用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...启动监听,提示: ora11g>lsnrctl status LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 08-JAN-2015 01...ERROR: ORA-12560: TNS:protocol adapter error 于是先看看端口是否开通,执行telnet报错: ora10g@localhost.localdomain$telnet...远程访问tnsping和sqlplus报错TNS-12560: TNS:protocol adapter error,说明可能两台机器之间的连接有问题而不是监听自身的问题。
排错-windows下_ORA-12560 TNS 协议适配器错误解决方法 by:授客 问题描述: 修改SQL*Plus窗口属性后,重新打开SQL*Plus时出现ORA-12560: TNS:...协议适配器错误 原因分析: ORA-12560: TNS: 协议适配器错误的问题的原因有三个: 1.
[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-12560...---------------------- Alias LISTENER Version TNSLSNR for Linux...))) The listener supports no services The command completed successfully 这样启动后远程连接会报错: oracle ORA... (GLOBAL_DBNAME = orcl) (SID_NAME = orcl) ) ) 注:orcl根据所安装的数据库实例名确定,将上面的代码加到原始的listener.ora
最近客户邮件描述无法从客户端连接到数据库,其错误号为ORA-12537: TNS:connection closed,连接被关闭。直接通过tnsping没有任何问题。...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-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
for Linux: Version 12.2.0.1.0 - Production TCP/IP NT Protocol Adapter for Linux: Version 12.2.0.1.0...Tns error struct: ns main err code: 12535 TNS-12535: TNS:operation timed out ns secondary err code: 12560...for Linux: Version 12.2.0.1.0 - Production TCP/IP NT Protocol Adapter for Linux: Version 12.2.0.1.0...Tns error struct: ns main err code: 12535 TNS-12535: TNS:operation timed out ns secondary err code: 12560...解决方案: 1.在sqlnet.ora中添加一行 DIAG_ADR_ENABLED=OFF 2.在listener.ora中添加一行 DIAG_ADR_ENABLED_LISTENER=OFF #
处理 1.登陆到oracle数据库服务器 [root@lzdk ~]# su - oracle 2.查看监听状态 [oracle@lzdk ~]$ lsnrctl status LSNRCTL for Linux...DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.91.116)(PORT=1521))) TNS-12541: TNS:no listener TNS-12560.../dbhome_1/network/admin/listener.ora Log messages written to /u01/app/oracle/diag/tnslsnr/lzdk/listener...ERROR: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor Enter...user-name: 5.发现报错ORA-12514,尝试重启数据库 6.连接数据库 [oracle@lzdk ~]$ sqlplus /nolog SQL> connect / as sysdba
领取专属 10元无门槛券
手把手带您无忧上云