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=...
针对你提出的错误“ORA-12514 TNS does not currently know of service requested in connect descriptor”,这是Oracle数据库连接中常见的错误,通常表示TNS监听器无法识别连接描述符中请求的服务。以下是根据你的提示提供的详细解决步骤: 确认ORACLE_HOME和TNS_ADMIN环境变量设置正确: 确保你的环境变量中正确设置了ORACL...
示例代码 以下是一个使用.NET框架连接到Oracle数据库的示例代码,演示了如何处理"ORA-12514: TNS:listener does not currently know of service requested"错误: usingSystem;usingSystem.Data;usingOracle.ManagedDataAccess.Client;classProgram{staticvoidMain(){stringconnectionString="Data Source=(DESCRIPTION=(ADDRESS=...
但是sqlPus上输入用户名和密码可以连接通过,百思不得其解(菜鸟本质 好奇)。 这种情况下查看了navicat的历史日志:ORA-12514: TNS:listener does not currently know of service requested in connect。 通过网上搜索查到说 navicat工具是32位,oracle64位不匹配,心想很有可能是这原因。因此通过博友给出的路径http://...
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor 二、排查过程 1、telenet应用服务器到数据库服务器端口连接正常 2、数据库登陆sqlplus正常 SQL>selectcount(*)fromv$session; 数据库连接数量几十,无异常 SQL>showparametername; ...
遇到ORA-12514错误时，若是因为更改了IP地址导致"ORA-12541: TNS:无监听程序"，请在WINDOWS.X64_193000_db_home\network\admin\tnsnames.ora文件中调整对应IP地址。完成修改后，请重启Oracle监听服务。另外，若选择在文件中设置固定IP地址，也可实现数据库连接。确保设置后的IP地址与Oracle服务器实际使用...
解决Python连接报错ORA-12514: TNS:listener does not currently know of service req问题 1. 概述 在使用Python连接Oracle数据库时,有时会遇到ORA-12514: TNS:listener does not currently know of service req的报错。这个错误通常是由于TNS Listener无法识别到请求的服务引起的。本文将向你介绍解决该问题的步骤和相...
Raw ORA-12514, TNS:listener does not currently know of service requested in connect descriptor The datasource URL string has the format below1 Raw jdbc:oracle:thin:@(description=(address_list=(load_balance=off)(failover=on)(address=(protocol=tcp)(host=abc2)(port=1536))(address=(protocol=tc...
ORA-12514,TNS：listenerdoesnotcurrentlyknowofs。。。今天使⽤SQL Developer连接⼀台测试服务器数据库（ORACLE 11g）时，遇到了“ORA-12514, TNS:listener does not currently know of service requested in connect descriptor”错误，具体提⽰如下所⽰：执⾏请求的操作时遇到错误:Listener refused the ...
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=...