Problem: [oracle@testdb2 ~]$ tnsping testdb2 TNS Ping Utility for Linux: Version 11.2.0.3.0 - Production on 18-APR-2017 21:27:27 Copyright (c) 1997, 2011, Oracle. All rights reserved. Used parameter files: /opt/oracle/product/11.2.0.3/network/admin/sqlnet.ora Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = testdb2.ipx.com)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = testdb2)) TNS-12533: TNS:illegal ADDRESS parameters Cause : This error appears due to incorrect syntax or spaces. In my cases I missed closing bracket “)” Solution: Correct syntax and remove spaces. After I fixed the syntax it works fine. TESTDB2 = [oracle@testdb2 ~]$ tnsping testdb2 TNS Ping Utility for Linux: Version 11.2.0.3.0 - Production on 18-APR-2017 21:33:13 Copyright (c) 1997, 2011, Oracle. All rights reserved. Used parameter files: /opt/oracle/product/11.2.0.3/network/admin/sqlnet.ora Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = testdb2.ipx.com)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = testdb2))) OK (0 msec) |