帆软配置Oracle外接数据库

模式连接orarle时报ORA-12505错误

{

ORA-12505, TNS:listener does not currently know of SID given in connect descriptor   (CONNECTION_ID=en2XoOiZT9uIhJSx5VZuPw==)     at oracle.jdbc.driver.T4CConnection.handleLogonNetException(T4CConnection

}

发现ORA-12505：TNS: 监听程序当前无法识别连接描述符中所给出的 SID

需讲原来生成的数据库连接URL：

jdbc:oracle:thin:@IP:端口:orcl

修改成jdbc:oracle:thin:@(description=(address=(protocol=tcp)(port=端口)(host=IP))(connect_data=(service_name=数据库名)))