解决oracle集群配置ORA-12505问题

今天同事遇到一个问题，具体描述如下：

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就好了嘛~~~