Hi All,
Greetings. I was working on something and was interested to know if I can
connect to vip on a down RAC node using just service name? MYDB is the
database with instances MYDB1 on host19 and MYDB2 on host20 with all
cluster services down on host20 and all services including host20-vip
failed over to host19. Ping to host19-vip and host20-vip work fine. Version
is 12.1.0.2 on RHEL 64 bit.
Following tns entries work:
Using host19-vip and SERVICE_NAME=MYDB and INSTANCE_NAME=MYDB1
MYDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = host19-vip.omers.com)(PORT = 1524))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = MYDB)
(INSTANCE_NAME = MYDB1)
)
)
Using host20-vip and host19-vip and SERVICE_NAME=MYDB and
INSTANCE_NAME=MYDB1
MYDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = host20-vip.omers.com)(PORT = 1524))
(ADDRESS = (PROTOCOL = TCP)(HOST = host19-vip.omers.com)(PORT = 1524))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = MYDB)
(INSTANCE_NAME = MYDB1)
)
)
Using host20-vip and host19-vip and SERVICE_NAME=MYDB. NO
INSTANCE_NAME=MYDB1
MYDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = host20-vip.omers.com)(PORT = 1524))
(ADDRESS = (PROTOCOL = TCP)(HOST = host19-vip.omers.com)(PORT = 1524))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = MYDB)
)
)
Following do not work. Receiving error No listener.
Using host20-vip and SERVICE_NAME=MYDB. NO INSTANCE_NAME=MYDB1
MYDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = host20-vip.omers.com)(PORT = 1524))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = MYDB)
)
)
Using host20-vip and SERVICE_NAME=MYDB and INSTANCE_NAME=MYDB1
MYDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = host20-vip.omers.com)(PORT = 1524))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = MYDB)
(INSTANCE_NAME = MYDB1)
)
)
Is this even supposed to work considering the listener does not even listen
on host20-vip?
Is this why scan listener came into existence? What am i missing here?
Thanks to the list for your assistance.
