在局域网中开放ORACLE服务

Win7环境中如何开发Oracle服务供局域网中其他机器访问：

1.  Oracle\product\dbhome\NETWORK\ADMIN\listener.ora 文件中

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

修改为

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

2. 修改Win7中自带的防火墙功能，当然如果全部关闭也就不用修改了。

若是修改，则需要在控制面板\所有控制面板项\Windows 防火墙  下  高级设置中增加一条入站规则。记着，是入站规则。