Oracle Database Discussions

Dear all,

We are in process of migrating from single instance to RAC. Following is configuration of single instance database 'orcl'

HUY =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = cc1001-hisdbs01)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)

While the one given below is tnsnames.ora of our RAC setup, to which we will migrate.

ORCL2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = hisdbs02-vip)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
(INSTANCE_NAME = orcl2)
)
)

ORCL1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = hisdbs01-vip)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
(INSTANCE_NAME = orcl1)
)
)

HUY =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = hisdbs02-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = hisdbs01-vip)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
(failover=on)
(load_balance=on)
(failover_mode=
(type=select)
(method=basic))
)
)

What are short term and long term solutions.

Short term solution can be to put VIPs of both nodes of the RAC in DNS and let DNS do dynamic load balancing (round robin).

One of the long term solutions can be to have one directory mapped to all clients which contains tnsnames.ora and have TNS_ADMIN on client side pointed towards this directory containing tnsnames.ora

What are your recommendations? Please suggest.

Br,
Anjum