oracle远程链接遇到的监听问题

问题

本地或服务装好oracle服务之后，只能本地访问，局域网内访问报监听问题。
本人遇到的问题是在什么都配好的情况下，本地能连，局域网内也能链接，重启服务器电脑之后，死活连不上，弄了好久发现配置文件自动发生了变化

需要修改的文件

基本上只需要修改oracle安装目录下的\product\11.2.0\dbhome_1\network\admin\listener.ora和tnsnames.ora这两个文件

修改listener.ora监听配置文件

# listener.ora Network Configuration File: E:\app\xcl\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = E:\app\xcl\product\11.2.0\dbhome_1)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:E:\app\xcl\product\11.2.0\dbhome_1\bin\oraclr11.dll")
    )

#下面的SID_DESC是新增加的内容，注意修改ORACLE_HOME路径
	(SID_DESC =
      (GLOBAL_DBNAME = ORCL)
      (ORACLE_HOME = E:\app\xcl\product\11.2.0\dbhome_1)
	  (SID_NAME = ORCL)
    )
  )

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

**#下面的DESCRIPTION是新增加的内容，注意修改HOST为本机IP
	(DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 169.254.43.12)(PORT = 1521))
    )**
  )

ADR_BASE_LISTENER = E:\app\xcl

修改tnsnames.ora服务配置文件

# tnsnames.ora Network Configuration File: E:\app\xcl\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORACLR_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
    (CONNECT_DATA =
      (SID = CLRExtProc)
      (PRESENTATION = RO)
    )
  )

#注意此处的HOST要和listener.ora中的IP相同
ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 169.254.43.12)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

后话

基本上按照以上两步配置后，然后重启listener服务，接着重启oracle服务就可以本地及远程链接了，本人亲测有效