Hello,
experts
Our production environment Oracle Data Guard 11.2.0.4.0 physical standby,i use command 'tnsping' to ping its primary TNS name,
finally,it show error about 'TNS-12547',see my operation as follows,
[oracle@orcl27 ~]$ tnsping orcl29
TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 26-OCT-2017 16:08:10
Copyright (c) 1997, 2013, Oracle. All rights reserved.
Used parameter files:
/u01/app/oracle/product/11.2.0/db_1/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.101.0.29)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl29)))
TNS-12547: TNS:lost contact
And tnsping physical standby's TNS name on primary DB,it's OK!
[oracle@orcl29 ~]$ tnsping standby29
TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 26-OCT-2017 16:10:46
Copyright (c) 1997, 2013, Oracle. All rights reserved.
Used parameter files:
/u01/app/oracle/product/11.2.0/db_1/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.101.0.27)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = standby29)))
OK (0 msec)
Pleas guide me to solve it.
Thanks a lot
Best Regards,
Quanwen Zhao