ORA-12514 错误,全称为“TNS does not currently know of service requested in connect descriptor”,指的是 Oracle 数据库监听器无法识别客户端连接描述符中请求的服务。这个错误通常出现在尝试连接到 Oracle 数据库时,数据库监听器无法找到请求的服务。以下是一些解决此问题的步骤: 确认错误信息的准确性: 确保错误...
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=...
但是sqlPus上输入用户名和密码可以连接通过,百思不得其解(菜鸟本质 好奇)。 这种情况下查看了navicat的历史日志:ORA-12514: TNS:listener does not currently know of service requested in connect。 通过网上搜索查到说 navicat工具是32位,oracle64位不匹配,心想很有可能是这原因。因此通过博友给出的路径http://...
以下是一个使用.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...
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor 二、排查过程 1、telenet应用服务器到数据库服务器端口连接正常 2、数据库登陆sqlplus正常 SQL>selectcount(*)fromv$session; 数据库连接数量几十,无异常 SQL>showparametername; ...
解决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无法识别到请求的服务引起的。本文将向你介绍解决该问题的步骤和相...
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。意思是监听程序当前无法识别连接描述符中请求的服务。 运行CMD命令,检查监听程序是否启动,但是发现正常。 于是查看lisenter.ora文件,原来此文件缺少SID配置。
遇到ORA-12514错误时，若是因为更改了IP地址导致"ORA-12541: TNS:无监听程序"，请在WINDOWS.X64_193000_db_home\network\admin\tnsnames.ora文件中调整对应IP地址。完成修改后，请重启Oracle监听服务。另外，若选择在文件中设置固定IP地址，也可实现数据库连接。确保设置后的IP地址与Oracle服务器实际使用...
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor 1.ORA-12514: TNS:listener does not currently know of service requested in connect descriptor 检查listener.ora文件,没有问题的话重启一下监听,回到客户端重新输入下服务名连接...