JDBC connection to Oracle RAC Server

Xuzhou needs to connect to a third-party database. The original database uses a Windows Cluster and is recently changed to the RAC mode, leading to frequent JDBC connection errors. Solution:

1. connection string Configuration:

JDBC: oracle: thin: @ (description = (address_list = (address = (host = IP address 1) (Protocol = TCP) (Port = 1521 )) (address = (host = IP address 2) (Protocol = TCP) (Port = 1521) (load_balance = yes) (Failover = yes )) (CONNECT_DATA = (SERVICE_NAME = Database Service name )))

 

2. Modify the host file and add the Server IP address and name.

Host file address c: \ windows \ system32 \ drivers \ etc \ hosts

 

After the preceding two steps, you can connect to the Oracle database in RAC mode.