Oliver's Blog

解决Oracle无法用本机IP连接数据库的问题

  • Oct 01, 2009

解决方法

D:\oracle\product\11.2.0\client_1\network\admin\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN下找到listener.ora文件

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.54)(PORT = 1521))
    )
  )

或者用Oracle Net Manager 增加LISTENER的地址

Search