tnsping not working in cloud environment

0

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

Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL=tcp)(HOST=apps.example.com)(PORT=1521)) (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 apps.example.com to private ip then it worked 10.0.0.145

tnsping ebscdb

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

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

Used parameter files:
/u01/install/APPS/19.0.0/network/admin/ebsdb_apps/sqlnet.ora

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

Share.

About Author

Leave A Reply