tnsnames,listener局域网内链接 配置

HOST 的值要全部改成计算机名，局域网内电脑链接才不会报没有监听，记得重启服务器的监听服务才能生效！ 
ORCL 数据库访问实例名 
listener.ora 
# listener.ora Network Configuration File: C:\app\Administrator\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 = C:\app\Administrator\product\11.2.0\dbhome_1) 
      (PROGRAM = extproc) 
      (ENVS = "EXTPROC_DLLS=ONLY:C:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll") 
    ) 
  ) 

LISTENER = 
  (DESCRIPTION_LIST = 
    (DESCRIPTION = 
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) 
      (ADDRESS = (PROTOCOL = TCP)(HOST =  WIN-M8DVU4G9DLB )(PORT = 1521)) 
    ) 
  ) 

ADR_BASE_LISTENER = C:\app\Administrator 


tnsnames.ora 配置 
# tnsnames.ora Network Configuration File: C:\app\Administrator\product\11.2.0\dbhome_1\network\admin\tnsnames.ora 
# Generated by Oracle configuration tools. 

LISTENER_ORCL = 
  (ADDRESS = (PROTOCOL = TCP)(HOST =  WIN-M8DVU4G9DLB )(PORT = 1521)) 


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

ORCL = 
  (DESCRIPTION = 
    (ADDRESS = (PROTOCOL = TCP)(HOST =  WIN-M8DVU4G9DLB )(PORT = 1521)) 
    (CONNECT_DATA = 
      (SERVER = DEDICATED) 
      (SERVICE_NAME = orcl) 
    ) 
  )