ORA-12505, TNS:listener does not currently know of SID given in connect desc

ORA-12505, TNS:listener does not currently know of SID given in connect desc

首先了解数据库url的写法有两种

//监听sid服务,表示sid为orcl
database.url=jdbc:oracle:thin:@171.xxx.96.xx:xxxx:orcl
//监听服务名,表示服务名为orcl
database.url=jdbc:oracle:thin:@171.xxx.96.xx:xxxx/orcl
第一种是监听sid服务,第二种则是监听服务名

所以发现是自己的sid写错导致出现这个错误,把服务名当做了sid

把orcl的 “ : ” 改为 “ / ”  访问正常

 

上一篇:ORA-00600: internal error code, arguments: [kcbo_unlink_q_3], [0x3710B87B0]


下一篇:MyBatis+Spring+SpringMVC