简单Dream-tnsping 报错TNS-12533: TNS:illegal ADDRESS parameters-优快云博客

本文链接：https://blog.youkuaiyun.com/chemzh/article/details/50371175

这篇博客介绍了在使用tnsping时遇到的TNS-12533错误，该错误是由于tnsnames.ora文件中的地址参数配置不正确导致。错误配置示例中，括号位置错误。正确配置需确保括号匹配，并正确指定主机、端口和服务名等信息。通过调整tnsnames.ora文件，可以解决这个问题。

报错：

[oracle@itpux2:/home/oracle]$tnsping itpux1
TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 21-DEC-2015 11:17:03
Copyright (c) 1997, 2013, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.131.6.203)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = itpux) （SID=itpux1）))
TNS-12533: TNS:illegal ADDRESS parameters
[oracle@itpux2:/home/oracle]$

错误原因：

tns文件配置错误，括号位置不对。

错误的配置和正确配置记录如下

错误的

itpux =
(DESCRIPTION =
(ADDRESS=(PROTOCOL = TCP)(HOST = itpuxscan)(PORT = 1521)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME=itpux)
)
)

itpux1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.131.6.203)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = itpux)
（SID=itpux1）
)
)

itpux2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.131.6.204)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = itpux)
（SID=itpux2）
)
)

stitpux =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.131.6.206)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = stitpux)
)
)

正确的

ITPUX =

(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = itpuxscan)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = itpux)
)
)

itpux1=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.131.6.203)(PORT = 1521))
)
(CONNECT_DATA =
(SID = itpux1)
(SERVER = DEDICATED)
(SERVER_NAME= ITPUX)
)
)

itpux2=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.131.6.204)(PORT = 1521))
)
(CONNECT_DATA =
(SID = itpux2)
(SERVER = DEDICATED)
(SERVER_NAME= ITPUX)
)
)

stitpux=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.131.6.206)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVER_NAME= STITPUX)
)
)