URL writing for connecting applications to Oracle rac

Oracle RAC cluster
RAC, short for real application clusters, is a new technology used in the new version of Oracle Database,

It is a type of high availability and the core technology that Oracle databases support the grid computing environment.

An example of how to connect an application to Oracle rac:

1. Jdbc: oracle: thin: @ (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = dc1.bpsb.com.cn) (PORT = 1521) (ADDRESS = (PROTOCOL = TCP) (HOST = dc2.bpsb.com.cn) (PORT = 1521) (LOAD_BALANCE = yes) (FAILOVER =On) (CONNECT_DATA = (SERVICE_NAME = bpscrac )))

This is an oracle rac url Connection on the network and an example of client tnsnames. ora ---- example of connection configuration related to Oracle RAC :( address --)

1. 1. Write the URL for connecting an application to Oracle rac
2. Jdbc: oracle: thin: @ (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.30.52) (PORT = 1521) (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.30.51) (PORT = 1521) (LOAD_BALANCE = yes) (FAILOVER = yes) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = kms) (FAILOVER_MODE = (TYPE =SELECT) (METHOD = BASIC) (RETIRES = 180) (DELAY = 15 ))))
5. 2. tnsnames. ora statement when the client connects to Oracle rac
6. ZJGLDB2 =
8. (DESCRIPTION =
10. (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.30.52) (PORT = 1521 ))
12. (CONNECT_DATA =
14. (SERVER = DEDICATED)
16. (SERVICE_NAME = kms)
18. (INSTANCE_NAME = kms2)
20. )
22. )
26. ZJGLDB1 =
28. (DESCRIPTION =
30. (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.30.51) (PORT = 1521 ))
32. (CONNECT_DATA =
34. (SERVER = DEDICATED)
36. (SERVICE_NAME = kms)
38. (INSTANCE_NAME = kms1)
40. )
42. )
46. LISTENERS_KMS =
48. (ADDRESS_LIST =
50. (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.30.51) (PORT = 1521 ))
52. (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.30.52) (PORT = 1521 ))
54. )
58. KMS =
60. (DESCRIPTION =
62. (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.30.51) (PORT = 1521 ))
64. (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.30.52) (PORT = 1521 ))
66. (LOAD_BALANCE = yes)
68. (FAILOVER = yes)
70. (CONNECT_DATA =
72. (SERVER = DEDICATED)
74. (SERVICE_NAME = kms)
76. (FAILOVER_MODE =
78. (TYPE =SELECT)
80. (METHOD = BASIC)
82. (RETRIES = 180)
84. (DELAY = 5)
86. )
88. )
90. )