Oracle RAC URL

Note
Make Sure that You have available the below DB IPs inside the Application Servers

cat /etc/hosts
#public
10.106.1.xxx prd-node-db1
10.106.1.xxx prd-node-db2
#Virtual
10.106.1.xxx prd-node-db1-vip
10.106.1.xxx prd-node-db2-vip
#scan
10.106.1.xxx prd-node-db-scan

SCAN VIP URL

jdbc:oracle:thin:@prd-node-db-scan:1521/racdb

OR

jdbc:oracle:thin:@prd-node-db-scan:1521/racdb

OR

jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=YES)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST= prd-node-db-scan)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=racdb))(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC)(RETRIES=180)(DELAY=5)))

LOCAL VIPs URL

jdbc:oracle:thin:@(DESCRIPTION = (ENABLE=BROKEN)
(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(Host = prd-node-db1-vip)
(Port = 1521)) (ADDRESS = (PROTOCOL = TCP)(Host = prd-node-db2-vip)(Port = 1521)))
(FAILOVER = ON) (LOAD_BALANCE=on) (CONNECT_DATA=(SERVICE_NAME = racdb)
(FAILOVER_MODE = (TYPE=SELECT)(METHOD=BASIC))))

LOCAL Single VIP Node-1

jdbc:oracle:thin:@prd-node-db1-vip:1521:racdb1

LOCAL Single VIP Node-2

jdbc:oracle:thin:@prd-node-db2-vip:1521:racdb2

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.