ORA-12502是一个Oracle数据库网络错误,全称是“TNS received no CONNECT_DATA from client”。这个错误表明Oracle监听器(Listener)没有从客户端接收到完整的连接数据(CONNECT_DATA)。 2. 可能导致ORA-12502错误的原因 内部连接或工具问题:某些内部连接或工具在尝试连接到Oracle数据库时,可能没有提供完整的连接字符串(C...
当使用plsqldev客户端登录Oracle数据库时,如果对应的tnsnames.ora中是直接使用IP地址来连接,并且未在系统的hosts文件中绑定主机名时,极易出现ORA-12502及ORA-12545报错,这两种错误内容分别是: ORA-12502: TNS:listener received no CONNECT_DATA from client ORA-12545: Connect failed because target host or object...
当使用plsqldev客户端登录oracle数据库时,如果对应的tnsnames.ora中是直接使用IP地址来连接,并且未在系统的hosts文件中绑定主机名时,极易出现ORA-12502及ORA-12545报错,这两种错误内容分别是: ORA-12502: TNS:listener received no CONNECT_DATA from client ORA-12545: Connect failed because target host or object...
ERROR: ORA-12502: TNS: 监听程序没有从客户机收到 CONNECT_DATA 解决: 设置所有节点的LOCAL_LISTENER参数,即可解决。host为vip SQL>show parameter local_listener; NAME TYPE VALUE--- --- ---local_listenerstringSQL>alter systemsetlocal_listener='(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.173)(PORT=1521)...
ORA-12502: TNS:listener received no CONNECT_DATA from client Cause: No CONNECT_DATA was passed to the listener. Action: Check that the service name resolved from TNSNAMES.ORA has the CONNECT_DATA component of the connect descriptor. Back to previous menu ...
Remote connections using SQL*Plus are intermittently failing with the following error:ORA-12502: TNS:listener received no CONNECT_DATA from clientFor example:SQLPLUS username@<TNS _ALIAS>Password:SQL*Plus: Release 11.2.0.1.0 Production on Thu May 16 14:59:48 2019...
当使用plsqldev客户端登录Oracle数据库时,如果对应的tnsnames.ora中是直接使用IP地址来连接,并且未在系统的hosts文件中绑定主机名时,极易出现ORA-12502及ORA-12545报错,这两种错误内容分别是: ORA-12502: TNS:listener received no CONNECT_DATA from client ...
Oracle rac 监听状态异常远程连接问题解决(TNS-12541 TNS-12560 TNS-00511 Linux Error:111 ORA-12502) 2019-04-02 13:42 − ... abm 0 1625 相关推荐 Oracle ORA-12569: TNS:包校验和失败 2019-12-19 11:25 − 检查端口号是否正确, 一般默认Port是1521... Uniqueness 0 6571 PL...
ORA-12502: TNS: 监听程序没有从客户机收到 CONNECT_DATA 解决: 设置所有节点的LOCAL_LISTENER参数,即可解决。host为vip SQL>show parameter local_listener; NAME TYPE VALUE--- --- ---local_listenerstringSQL>alter systemsetlocal_listener='(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.173)(PORT=1521))...