问题：我在tnsname中配置如下
xx =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
host中配置的是localhost，结果不行
/etc/hosts文件
127.0.0.1 localhost
也已经有了相应配置。
listener.ora文件
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 117.79.236.112)(PORT = 1521))
)
)
解决，修改listener文件
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 117.79.236.112)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
)
在其中添加了127.0.0.1记录，就可以在tnsname中使用localhost了
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/16566331/viewspace-674849/ ，如需转载，请注明出处，否则将追究法律责任。
