针对你提出的错误“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=(PROTOCOL...
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=...
1、telenet应用服务器到数据库服务器端口连接正常 2、数据库登陆sqlplus正常 SQL>selectcount(*)fromv$session; 数据库连接数量几十,无异常 SQL>showparametername; db_name和service_names没问题 3、检查lisener配置文件配置正常 vim product/11.2.0/dbhome_1/network/admin/listener.ora 4、一直没有头绪,尝试重新...
第一步:打开Oracle Net Manager 进行如下配置:(服务名称对应自己的配置) 第二步:找到查看listener.ora文件:位于oracle 安装目录的app文件夹目录下面 我的位置是:D:\app\myname\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora,打开大致如下 # listener.ora Network Configuration File: G:\app\admin\product...
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor 1. 1. 供应商代码 12514 1. 几年前写过一篇关于”ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务“的案例文章,现在看来当时写的比较肤浅和粗糙,当然案例也不一样,下面在总结一下如何处理ORA-12514这...
Oracle driver raises exception when attempting to create a connection to the database 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...
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=...
1.首先默认的oracle配置文件中tnsnames.ora和listener.ora中默认监听的地址是localhost,如果删除了/etc/hosts中localhost的映射也会出现这个问题。 2.手动的修改listener.org和tnsnames.org文件 日志:/opt/oracle/product/11.2.0/dbhome_1/listener.log 解决方案 首先确定Oracle的安装位置: /opt/oracle/product/11.2.0...
说明数据库监听文件配置出问题了，可以以下几个文件的位置，配置一次 忘LZ采纳