lsnrctl status 2、查看输出结果,确保监听服务(LISTENER)的状态为"正在运行",如果状态为"停止"或"未知",请尝试重新启动监听服务。 检查TNS配置文件 1、找到Oracle的TNS配置文件(tnsnames.ora),通常位于$ORACLE_HOME/network/admin目录下。 2、使用文本编辑器打开TNS配置文件,检查其中的连接信息是否正确。 MYDB = (D...
重新安装连接依然不行。问题还是回到了listener does not currently know of service requested in connect侦听器目前并不知道连接的服务请求,怎样能让listener know? 通过上网查到可通过修改listener.ora文件解决。http://blog.csdn.net/icqsky/article/details/4313791 添加了一段在安装目录E:\app\Administrator\product...
close(3) = 0 access("/etc/listener.ora", F_OK) = -1 ENOENT (No such file or directory) access("/opt/oracle/product/10.2.0/db_1/network/admin/listener.ora", F_OK) = 0 open("/opt/oracle/product/10.2.0/db_1/network/admin/listener.ora", O_RDONLY|O_LARGEFILE) = 3 fcntl64(3...
2 days before we got tnslistner error and unable to connect to the database. we are able to re-start all the oracle services except tnslistener service. while restarting the service getting following error "the oracleoradb19home1tnllistenergldb service on local co...
TNS错误可能是由于配置问题导致的,监听器(Listener)配置不正确、服务名(Service Name)配置错误等。 2、网络故障 网络故障也可能导致TNS错误,网络中断、防火墙设置不当等。 3、Oracle实例问题 Oracle实例问题也可能导致TNS错误,实例启动失败、实例崩溃等。 4、驱动问题 ...
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor 1. 1. 供应商代码 12514 1. 几年前写过一篇关于”ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务“的案例文章,现在看来当时写的比较肤浅和粗糙,当然案例也不一样,下面在总结一下如何处理ORA-12514这...
在使用.NET框架进行数据库开发时,有时候可能会遇到"ORA-12514: TNS:listener does not currently know of service requested"错误。这个错误通常出现在尝试连接到Oracle数据库时,数据库监听器无法找到请求的服务。本文将介绍这个错误的原因、解决方法和相关的代码示例。
当数据库启动时，它会尝试向监听程序注册它的服务名。默认情况下为it will try to use the network ...
Listener refused the connection with the following error:ORA-12514,TNS:listener does not currently know of service requested in connect descriptor The Connection descriptor used by the client was:(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=zsl)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=...
Listener refused the connection with the following error:ORA-12514,TNS:listener does not currently know of service requested in connect descriptor The Connection descriptor used by the client was:(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=zsl)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=...