错误代码:
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
前两天遇到plsql连接正常,但是配置java项目连接却报错的问题,这里为记录一下
主要是Oracle的SID和SERVER_NAME的区别,如果遇到这样的问题,只要修改一些连接方式就可以了
jdbc:oracle:thin:@xxx.xxx.xxx.xx:1521:orcl
or
jdbc:oracle:thin:@//xxx.xxx.xxx.xx:1521/orcl
如果有DBA权限可以查询SID: select name from V$database;