I have a RAC Oracle server which can be connected using Oracle client and the following TNS entry:
Code: Select all
ENTRY1.WORLD,ENTRY1=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = server1-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = server2-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = server3-vip)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORASRVC )
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
(RETRIES = 180)
(DELAY = 5)
)
)
)
HOST=
PORT=1521
SERVER=SN?SID?
Does the connection works if server1-vip is a DNS name ?
Thank you very much.
Jayme Jeffman