针对你提出的错误“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...
但是sqlPus上输入用户名和密码可以连接通过,百思不得其解(菜鸟本质 好奇)。 这种情况下查看了navicat的历史日志:ORA-12514: TNS:listener does not currently know of service requested in connect。 通过网上搜索查到说 navicat工具是32位,oracle64位不匹配,心想很有可能是这原因。因此通过博友给出的路径http://...
然后,我们通过split()方法获取了服务名和实例名,并进行了打印输出。 5. 修改TNS Listener配置文件 在连接数据库时,Python会使用TNS Listener的配置文件来查找数据库的服务名。如果配置文件中没有包含请求的服务名,就会报错ORA-12514。因此,我们需要在配置文件中添加服务名。 以下是一个示例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 二、排查过程 1、telenet应用服务器到数据库服务器端口连接正常 2、数据库登陆sqlplus正常 SQL>selectcount(*)fromv$session; 数据库连接数量几十,无异常 SQL>showparametername; ...
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...
ORA-12514 TNS:listener does not currently know of service requested in connect descriptor报错问题解决方法 解决方法: 1.停掉监听: lsnrctl stop 2.编辑监听文件: vim /u01/oracle/app/product/11.2/dbhome_1/network/admin/listener.ora 我这里的环境是双oracle做的主备,两台oracle服务器IP分别为 ...
报错信息:ORA-12514:TNS:listener does not currently know of service requested in connect descriptor。意思是监听程序当前无法识别连接描述符中请求的服务。 运行CMD命令,检查监听程序是否启动,但是发现正常。 于是查看lisenter.ora文件,原来此文件缺少SID配置。
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=...