遇到错误 ORA-12505: TNS:listener does not currently know of SID given in connect descriptor 通常意味着Oracle数据库的网络监听器(Listener)无法识别客户端连接描述符中指定的服务标识符(SID)或服务名(Service Name)。以下是针对您提供的问题的一些具体解决步骤,我将分点回答并包含必要的说明和可能的代码片段(尽...
百度试题 结果1 题目ORA-12505,TNS:listener does not currently know of SID given in connect descriptor怎么解决?求大师 相关知识点: 试题来源: 解析 把你要连的TNSNAME String传上来看看,应该是service_name的值与监听服务的SID不一致 反馈 收藏
Myeclipse开发:ORA-12505,TNS:listener does not currently know of SID given in connect descriptor.开发环境:Myeclipse 6.5,Tomcat 5.5,oracle 10g,数据库服务器在IP为192.168.10.10的机子上,用户为:username.密码是:password,数据库实例为:test.启动Tomcat时报错,错误信息如下[main] ERROR:org.hibernate.util.JDBC...
1、在Oracle服务器中检查监听状态(命令:lsnrctl status) 2、若出现如上截图(The listener supports no services)问题,找到如图Listener Parameter File文件加入如下代码 SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = orcl) (SID_NAME = orcl) ) ) 3、重启监听,执行如下命令 su - oracle ...
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor The Connection descriptor used by the client was: 192.168.149.128:1521:orcl at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) at oracle.jdbc.driver.DatabaseError.throwSqlException(Database...
ORA-12505,TNS:listenerdoesnotcurrentlyknowofSIDgivenin 1. 说明给到的sid有误,很有可能就是服务名和sid混淆使用。 首先了解数据库url的写法有两种 //监听sid服务,表示sid为orcl database.url=jdbc:oracle:thin:@171.xxx.96.xx:xxxx:orcl //监听服务名,表示服务名为orcl ...
ORA-12505: TNS:listener does not currently know of SID given in connect descriptorerrors Server produces or throws following error message when starting: Raw WARN [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] (main) Throwable while attempting to get a new connection: null org.jbos...
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor org.pentaho.di.core.exception.KettleDatabaseException: 1. 2. 来看oracle 数据库版本 select * from v$version; 1. 连接oracle 12c以上的数据库需要在数据库名称前加上’/’。如下图所示 ...
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor 4、反复测试Oracle服务端监听正常。5、最后发现配置问题，改正为如下配置：①spring.datasource.url = jdbc:oracle:thin:@//192.168.1.4:1521/orcl ②spring.datasource.url = jdbc:oracle:thin:@192.168.1.4:1521:orcl...
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor 4、反复测试Oracle服务端监听正常。 5、最后发现配置问题,改正为如下配置: ①spring.datasource.url = jdbc:oracle:thin:@//192.168.1.4:1521/orcl ②spring.datasource.url = jdbc:oracle:thin:@192.168.1.4:1521:orcl ...