以前使用oracle的RAC都是通过连接数据库的URL做文章,把RAC的多个节点都配置到该URL里面。11g开始,提供了新玩法,避免由于RAC中节点的增、减而去调整数据源的URL参数。11g提供了通过scan ip访问的方式,本以为这个和单实例数据库一样连接使用,结果报错:
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
The Connection descriptor used by the client was:
zhscan:1521:racdb
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:261)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:439)
at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:165)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:68)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:87)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.acquireResource(C3P0PooledConnectionPool.java:83)
at com.mchange.v2.resourcepool.BasicResourcePool.assimilateResource(BasicResourcePool.java:884)
at com.mchange.v2.resourcepool.BasicResourcePool.acquireUntil(BasicResourcePool.java:601)
at com.mchange.v2.resourcepool.BasicResourcePool.access$400(BasicResourcePool.java:31)
at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1079)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:354)
把这个zhscan改为scan ip,错误依旧。
如是,配置数据库连接到RAC的某一个节点上,且使用该节点上的实例racdb1,数据库连接成功。
通过客户端的sqlplus连接racdb,一切正常。再通过plsql连接,也没问题。
既然客户端可以连,那证明oracle RAC没问题,是配置数据源连接池时的参数问题。于是,找到客户端服务器下的tnsnames.ora,找到里面配置的racdb那段作为URL后半部分,整个数据源的URL如下:
jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.100)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=racdb)))
其中192.168.1.100是RAC的scan ip,racdb是GLOBAL_DBNAME。
按如上配置保存后,数据库连接成功。
看来,虽然11g提供了scan ip访问的方式,但并不是像想象着访问单实例那样玩了。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/9399028/viewspace-758106/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/9399028/viewspace-758106/