jdbc 连接Oracle集群（RAC）数据库

一、现象

1)内网172.16.30.x网段，两台DL580做ORACLERAC，

#Oracle Public IP (eth1)

172.16.30.1 BnetDB1

172.16.30.2 BnetDB2

#Oracle privite IP (eth0)

10.0.0.1 BnetDB1-priv

10.0.0.2 BnetDB2-priv

#Oracle Virtual IP

172.16.30.3 BnetDB1-vip

172.16.30.4 BnetDB2-vip

#Oracle Scan IP

172.16.30.5 BnetDB-scan

2)应用192.168.3.x网段

3.1)在防火墙上，将数据内网地址分别映射为

172.16.30.1 192.168.3.201

172.16.30.2 192.168.3.202

172.16.30.3 192.168.3.203

172.16.30.4 192.168.3.204

172.16.30.5 192.168.3.205

3.2)在防火墙上为确保先调通，policy除指定源及目的地址外，双向any均permit

4) 应用服务器jdbcUrl=jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.30.5)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=BnetDB)))就正常

但一旦通过205连接数据库jdbcUrl=jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.3.205)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=BnetDB)))就报错，报错信息如下：

java.sql.SQLException: Unable to open a test connection to the given database. JDBC url = jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.3.205)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=BnetDB))), username = hblh. Terminating connection pool. Original Exception: ------

java.sql.SQLException: Listener refused the connection with the following error:

ORA-12516, TNS:listener could not find available handler with matching protocol stack

The Connection descriptor used by the client was:

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.3.205)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=BnetDB)))

二、排查过程

1)showparameter processes; processes为2000

selectcount(*) from v$process; 为54

show parameter sessions; sessions为3024

selectcount(*) from v$session; 为52

2) jdbcUrl通过203或204连接数据库,正常

三、有效方法

通过以下方式，OK

jdbcUrl=jdbc:oracle:thin:@(description=(ADDRESS_LIST=(address=(protocol=tcp)(host=192.168.3.203)(port=1521))(address=(protocol=tcp)(host=192.168.3.204)(port=1521))(load_balance=yes))(connect_data=(server=dedicated)(service_name=BnetDB)(failover_mode=(type=session)(method=basic)(retries=5)(delay=15))))

四、遗留问题

1、地址映射后，为啥scan-ip就不行咧，是否如《DBA的思想天空:感悟Oracle数据库本质》P16所讲需CONNECT MANAGER (CMAN)?不知咋搞，先记下再说

本文来源 我爱IT技术网 http://www.52ij.com/jishu/5046.html 转载请保留链接。