TNS-12533: TNS:illegal ADDRESS parameters

tnsnames.ora有格式，最好粘贴文件中自带的配置格式，否则容易引起报错：

[oracle@dj admin]$ more tnsnames.ora # tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora # Generated by Oracle configuration tools. SYD =   (DESCRIPTION =     (ADDRESS_LIST =       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.77)(PORT = 1521))     )     (CONNECT_DATA =       (SERVICE_NAME = syd)(UR=A)     )   ) ORCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = dj)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = orcl)(UR=A) ) ) [oracle@dj admin]$ tnsping orcl TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 04-JAN-2019 05:03:52 Copyright (c) 1997, 2013, Oracle.  All rights reserved. Used parameter files: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/sqlnet.ora Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = TNS-12533: TNS:illegal ADDRESS parameters

调整tnsnames.ora格式后，正常。

[oracle@dj admin]$ more tnsnames.ora # tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora # Generated by Oracle configuration tools. SYD =   (DESCRIPTION =     (ADDRESS_LIST =       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.77)(PORT = 1521))     )     (CONNECT_DATA =       (SERVICE_NAME = syd)(UR=A)     )   ) ORCL =   (DESCRIPTION =     (ADDRESS_LIST =       (ADDRESS = (PROTOCOL = TCP)(HOST = dj)(PORT = 1521))     )     (CONNECT_DATA =       (SERVICE_NAME = orcl)(UR=A)     )   ) [oracle@dj admin]$ tnsping orcl TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 04-JAN-2019 05:46:54 Copyright (c) 1997, 2013, Oracle.  All rights reserved. Used parameter files: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/sqlnet.ora Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = dj)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = orcl)(UR=A))) OK (40 msec)