tnsping not working in cloud environment


Setting up of DR site, I had to ping to primary site

Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL=tcp)( (CONNECT_DATA = (SERVICE_NAME=ebscdb)(INSTANCE_NAME=ebscdb)))
TNS-12543: TNS:destination host unreachable

Solution, add firewall rule and make entry of private ip instead of hostname in the tnsnames.ora

firewall-cmd –zone=public –add-port=1521/tcp –permanent
firewall-cmd –reload

Have changed the to private ip then it worked

tnsping ebscdb

TNS Ping Utility for Linux: Version – Production on 28-MAY-2021 22:36:53

Copyright (c) 1997, 2020, Oracle. All rights reserved.

Used parameter files:

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL=tcp)(HOST= (CONNECT_DATA = (SERVICE_NAME=ebscdb)(INSTANCE_NAME=ebscdb)))
OK (10 msec)


About Author

Leave A Reply