今天同事遇到一个问题,具体描述如下:
ORA-12505,TNS:listener does not currently know of SID given in connect descriptor
排查方案:
普及Oracle三种链接方式:sid方式,service_name方式,tns方式,
sid方式: jdbc:oracle:thin:@localhost:1521:orcl
service_name方式:jdbc:oracle:thin:@//host:port/service_name
tns方式:jdbc:oracle:thin:@TNSName
后又得知是使用service_name集群配置,配置如下:
jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=ip1)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=ip2)(PORT=1521))(LOAD_BALANCE=off)(FAILOVER=on))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME =crm11g)))
排查load_balance=off负载均衡没打开,设置为load_balance=on就好了嘛~~~