ORA-12505错误代码是Oracle数据库在尝试建立连接时遇到的一个常见错误,具体为“TNS does not currently know of SID given in connect descriptor”。这个错误表明Oracle监听器(Listener)在尝试根据连接描述符(Connect Descriptor)中提供的系统标识符(SID)来找到相应的数据库实例时,未能找到匹配的SID。 指出可能导致ORA-...
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...
解决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 二、排查过程 1、telenet应用服务器到数据库服务器端口连接正常 2、数据库登陆sqlplus正常 SQL>selectcount(*)fromv$session; ...
百度试题 结果1 题目ORA-12505,TNS:listener does not currently know of SID given in connect descriptor怎么解决?求大师 相关知识点: 试题来源: 解析 把你要连的TNSNAME String传上来看看,应该是service_name的值与监听服务的SID不一致 反馈 收藏
TNS listener does not currently know of SID given in connect descriptor问题的解决思路和办法1.引起此问题的现象: 在java中连接Oracle数据库: String url = "jdbc:oracle:thin:@192.168.1.50:1521:orcl"; String user = "xarh"; String password = “123456”; Connection connection = DriverManager....
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.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\12.1.0\dbhome_1\NETWORK\ADMIN\listener.ora ...