JDBC 连接 11gr2 集群环境-优快云博客

本文介绍了如何使用Oracle 11gr2新组件scan通过VIP和IP地址连接数据库实例，包括使用VIP方式和主机名方式，并提供了详细的连接字符串配置示例。同时，解释了在hosts文件中定义别名的重要性，以及如何解决NL Exception错误。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

使用11gr2新组件scan 方式连接（假设scan_vip为192.168.100.217）

String url = "jdbc:oracle:thin:@192.168.100.217:1521/prod"

也可以使用11gr2以前vip方式连接

String url="jdbc:oracle:thin:@(DESCRIPTION ="

+"(ADDRESS_LIST ="

+"(ADDRESS=(PROTOCOL=TCP)(HOST=el1)(PORT=1521))"

+"(ADDRESS=(PROTOCOL=TCP)(HOST=el2)(PORT=1521))"

+"(LOAD_BALANCE = yes)"

+")"+"(CONNECT_DATA="+"(SERVER=DEDICATED)"

+"(SERVICE_NAME=prod )"+")"+")";

注：jdbc thin使用11gr2以前vip方式连接，host中不可以直接使用ip，否则会出现NL Exception was generated 错误。需要使用别名。并且在hosts文件中定义。

例如本例中两台机器的vip为192.168.100.123和192.168.100.124并且，别名为el1，el2。那么在hosts文件中需要有下面两行

192.168.100.123 el1

192.168.100.124 el2

host文件位置：

linux|unix:/etc/hosts

windows:$系统盘\WINDOWS\system32\drivers\etc\hosts

下面是一个完整的实例：

package jdbc.dex.com;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import org.junit.Test;

public class JDBC1 {
	
	public static void main(String[] args){
		String urlVip = "jdbc:oracle:thin:@(DESCRIPTION =" 
				+ "(ADDRESS_LIST =" 
				+ "(ADDRESS=(PROTOCOL=TCP)(HOST=el1)(PORT=1521))" 
				+ "(ADDRESS=(PROTOCOL=TCP)(HOST=el2)(PORT=1521))" 
				+ "(LOAD_BALANCE = yes)"
				+ ")" + "(CONNECT_DATA=" + "(SERVER=DEDICATED)" 
				+ "(SERVICE_NAME=prod )" + ")" + ")"; 
		
		String urlScan1="jdbc:oracle:thin:@(DESCRIPTION ="+
				    "(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.217)(PORT = 1521))"+
				    "(CONNECT_DATA ="+
				      "(SERVER = DEDICATED)"+
				      "(SERVICE_NAME = prod)"+
				    ")"+
				  ")";
		
		String urlScan2="jdbc:oracle:thin:@192.168.100.217:1521/prod" ;
		String driver="oracle.jdbc.driver.OracleDriver" ;
		Connection con ;
		Statement st ;
		ResultSet rs ;
		try {
			Class.forName(driver) ;
			con = DriverManager.getConnection(urlVip,"dexter","xiaojun");
			st=con.createStatement() ;
			rs=st.executeQuery("select 2 from dual ") ;
			while(rs.next()) {
				System.out.println(rs.getString(1));
			}
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
	}
}