遇到错误 ORA-12505: TNS:listener does not currently know of SID given in connect descriptor 通常意味着Oracle数据库的网络监听器(Listener)无法识别客户端连接描述符中指定的服务标识符(SID)或服务名(Service Name)。以下是针对您提供的问题的一些具体解决步骤,我将分点回答并包含必要的说明和可能的代码片段(尽...
【题目】Myeclipse开发:ORA-12505,T NS:listener does not currently know of SID given in connect descriptor.开发环境:Myeclipse 6.5,T omcat 5.5,oracle 10g,数据库服务器在IP为192.168.10.10的机子上,用户为:username.密码是:password,数据库实例启动Tomcat时报错,错误信息如下[main] ERROR:org.hibernate.util....
java.sql.SQLException: Listener refused the connection with the following error: 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(Databas...
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:listenerdoesnotcurrentlyknowofSIDgivenin 1. 说明给到的sid有误,很有可能就是服务名和sid混淆使用。 首先了解数据库url的写法有两种 //监听sid服务,表示sid为orcl database.url=jdbc:oracle:thin:@171.xxx.96.xx:xxxx:orcl //监听服务名,表示服务名为orcl ...
百度试题 结果1 题目ORA-12505,TNS:listener does not currently know of SID given in connect descriptor怎么解决?求大师 相关知识点: 试题来源: 解析 把你要连的TNSNAME String传上来看看,应该是service_name的值与监听服务的SID不一致 反馈 收藏
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor 供应商代码 12505 1. 2. 3. 4. 5. 6. 7. 2、错误原因 Oracle数据库SID出现错误,导致出现报错 3、解决办法 可以切换到选择服务名,勾选服务名,输入名称,进行登录...
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 说明给到的sid有误,很有可能就是服务名和sid混淆使用。 首先了解数据库url的写法有两种: //监听sid服务,表示sid为orcl database.url=jdbc:oracle:thin:@171.xxx.96.xx:xxxx:orcl ...
java.sql.SQLException: Listener refused the connection with the following error: 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:152...