以下是一个使用.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=(PROTOCOL...
但是sqlPus上输入用户名和密码可以连接通过,百思不得其解(菜鸟本质 好奇)。 这种情况下查看了navicat的历史日志:ORA-12514: TNS:listener does not currently know of service requested in connect。 通过网上搜索查到说 navicat工具是32位,oracle64位不匹配,心想很有可能是这原因。因此通过博友给出的路径http://...
当我们用kettle或者其他工具访问数据库时,有时候会报ORA-12505的错误,具体报错如下图所示,这其实是oracle 11g高版本会存在的一个小问题。具体原因是监听器目前不知道给定的SID在连接描述符。直白点就是不认识这个SID值。 一、解决方式 1、应用端JDBC连接配置 如我们在帆软report上时,我们可以这样去写我们的URL。
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:listener does not currently know of service requested in connect descriptor 1. 1. 供应商代码 12514 1. 几年前写过一篇关于”ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务“的案例文章,现在看来当时写的比较肤浅和粗糙,当然案例也不一样,下面在总结一下如何处理ORA-12514这...
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor 二、排查过程 1、telenet应用服务器到数据库服务器端口连接正常 2、数据库登陆sqlplus正常 SQL>selectcount(*)fromv$session; 数据库连接数量几十,无异常 SQL>showparametername; ...
Currently, I'm facing the error "ORA-12514 TNS:listener does not currently know of service requested in connect descriptor" when trying to login on my front end. Every solution I've seen so far was to change the service_name on tnsnames.ora, but I've checked on my...
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=...
navicat连接Oracle报错ORA-12514TNS：listenerdoesnot。。。navicat连接Oracle报错ORA-12514TNS：listenerdoesnot。。。原因:服务名错了 修改服务名为你的服务名
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=...