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

最近对接第三方的数据同步的时候，发现了这样一个问题：

业务场景：定时将第三方Oracle数据库中的数据同步到我方mysql数据库中，使用最原始的JDBC连接Oracle数据库，将对方提供的视图数据同步过来！在联调的时候发现无论如何都无法连接到对方的Oracle数据库，现场的同事使用PL/SQL developer 使用相同的连接参数却可以正常连接,报错信息如下：

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
 
        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:458)
        at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:546)
        at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:236)
        at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
        at java.sql.DriverManager.getConnection(DriverManager.java:571)
        at java.sql.DriverManager.getConnection(DriverManager.java:215)
        ...
Caused by: oracle.net.ns.NetException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
 
        at oracle.net.ns.NSProtocol.connect(NSProtocol.java:395)
        at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1102)
        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:320)
        ... 32 more

排查改该问题时网上最多的结果就是ora中监听配置的sid名和服务名不一致导致，

最后发现对方对方所给的url地址是错误的：因为实例名前面应该是/ （斜杠），如果是冒号的话，Oracle会认为这个冒号后面的应该是sid名，与数据库里的sid名不匹配导致报错！

url=jdbc:oracle:thin:@127.0.0.1:1521:orcl

换成下面正确的斜杠（/）总算是可以了：

url=jdbc:oracle:thin:@127.0.0.1:1521/orcl