但是sqlPus上输入用户名和密码可以连接通过,百思不得其解(菜鸟本质 好奇)。 这种情况下查看了navicat的历史日志:ORA-12514: TNS:listener does not currently know of service requested in connect。 通过网上搜索查到说 navicat工具是32位,oracle64位不匹配,心想很有可能是这原因。因此通过博友给出的路径http://...
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=...
以下是一个使用.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...
今天使用SQL Developer连接一台测试服务器数据库(ORACLE 11g)时,遇到了“ORA-12514, TNS:listener does not currently know of service requested in connect descriptor”错误,具体提示如下所示: 执行请求的操作时遇到错误: 1. 1. Listener refused the connection with the following error: 1. 1. ORA-12514, T...
Listener refused the connection with the following error: ORA-12514, TNS:listener does not currently know of service requested in connect descriptor 二、排查过程 1、telenet应用服务器到数据库服务器端口连接正常 2、数据库登陆sqlplus正常 SQL>selectcount(*)fromv$session; ...
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=...
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 c...
解决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无法识别到请求的服务引起的。本文将向你介绍解决该问题的步骤和相...