以下是一个使用.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. 1. 供应商代码 12514 1. 几年前写过一篇关于”ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务“的案例文章,现在看来当时写的比较肤浅和粗糙,当然案例也不一样,下面在总结一下如何处理ORA-12514这...
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://...
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor 中文版的提示: ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求服务 1、各软件的版本 Navicat Premium 版本:11.2.14(64-bit) Oracle 版本:10.2.0.1.0(32-bit) ...
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=...
大概意思就是TNS监听器程序当前无法识别连接描述符中请求的服务。 问题分析: 1.首先默认的oracle配置文件中tnsnames.ora和listener.ora中默认监听的地址是localhost,如果删除了/etc/hosts中localhost的映射也会出现这个问题。 2.手动的修改listener.org和tnsnames.org文件 日志:/opt/oracle/product/11.2.0/dbhome_1/lis...
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 供应商代码 12514 ⼏年前写过⼀篇关于”“的案例⽂章，现在看来当时写的⽐较肤浅和粗糙,当然案例也不⼀样，下⾯在总结⼀下如何处理ORA-12514这个错误吧。Step 1：⾸先检查客户端的tnsnames.ora⾥⾯的...
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...