TNS-12533: TNS:illegal ADDRESS parameters

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 =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = testdb2.ipx.com)(PORT = 1521))

)

(CONNECT_DATA =

(SERVICE_NAME = testdb2)

(UR = A)

)

)

[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)