SQlplus connectivity with incorrect hostname
edited Sep 9, 2013 8:13AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 1 commentAnswered
Hi
I have a TNS entry something like this:
ABCD =
(DESCRIPTION_LIST = (FAILOVER = yes)(LOAD_BALANCE = no)
(DESCRIPTION = (LOAD_BALANCE = yes)
(ADDRESS = (PROTOCOL= TCP) (HOST= stdby_host) (PORT = 1721))
(CONNECT_DATA = (SERVICE_NAME = HRMS_RO)))
(DESCRIPTION = (LOAD_BALANCE = yes)
(ADDRESS = (PROTOCOL= TCP) (HOST= primary_scan) (PORT= 1721))
(CONNECT_DATA = (SERVICE_NAME = HRMS_RO)))
)
Assumption: HRMS_RO service is up and running on both Standby and Primary. I stopped the HRMS_RO service on the primary service and edited the TNS file to replace the actual standby host name (stdby_host) in the above TNS with a non-existent host and try connecting, it connects successfully. I was expecting it to say TNS-12154 or something similar since the HRMS_RO is down on Primary and the Standby host is non-existent.
I have a TNS entry something like this:
ABCD =
(DESCRIPTION_LIST = (FAILOVER = yes)(LOAD_BALANCE = no)
(DESCRIPTION = (LOAD_BALANCE = yes)
(ADDRESS = (PROTOCOL= TCP) (HOST= stdby_host) (PORT = 1721))
(CONNECT_DATA = (SERVICE_NAME = HRMS_RO)))
(DESCRIPTION = (LOAD_BALANCE = yes)
(ADDRESS = (PROTOCOL= TCP) (HOST= primary_scan) (PORT= 1721))
(CONNECT_DATA = (SERVICE_NAME = HRMS_RO)))
)
Assumption: HRMS_RO service is up and running on both Standby and Primary. I stopped the HRMS_RO service on the primary service and edited the TNS file to replace the actual standby host name (stdby_host) in the above TNS with a non-existent host and try connecting, it connects successfully. I was expecting it to say TNS-12154 or something similar since the HRMS_RO is down on Primary and the Standby host is non-existent.
0