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)

Comments