oracle localhost可连接，ip地址不能连接

1、修改配置文件listener.ora将HOST=你自己的主机名
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = sweetboy_pc)(PORT = 1521))
    )
  )
文件所在路径：
C:\oracle\product\10.2.0\db_1\NETWORK\ADMIN
2、检查监听设置，重新启动监听服务。