tnsname中配置localhost不起作用

问题：我在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博客 ” ，链接：http://blog.itpub.net/16566331/viewspace-674849/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/16566331/viewspace-674849/