Can you connect to a vip on a down RAC node with service name?
Date: Wed, 11 Apr 2018 15:22:28 -0400
Message-ID: <CADmQEr4rwU59AWMJvk8-S-YZmLwrV3MsCUvTSSaNsBtVWMA9Lg_at_mail.gmail.com>
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.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Apr 11 2018 - 21:22:28 CEST