# listener.ora Network Configuration File: d:\app\Administrator\product\11.2.0\dbhome_1\network\admin\listener.ora

# Generated by Oracle configuration tools.

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST =Myserver)(PORT = 1521))

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

    )

  )

ADR_BASE_LISTENER = d:\app\Administrator

 

监听配置中，要注意 Host=计算机名字 ，如果写成127.0.0.1,会导致远程的电脑无法连接，

因为1521端口跑到 127.0.0.1上了，远程的端口无法开启

 

注意：

D:\app\Administrator\product\11.2.0\dbhome_1\database\oradim.log 这个文件中保存有服务开启时的日志

报如下错误：

ORA-00119: invalid specification for system parameter LOCAL_LISTENER

ORA-00132: syntax error or unresolved network name 'LISTENER_ORCL'

问题处理过程：

1、修改tnsnames.ora文件，添加下面的语句：

# tnsnames.ora Network Configuration File: d:\app\Administrator\product\11.2.0\dbhome_1\network\admin\tnsnames.ora

# Generated by Oracle configuration tools.

ORA11 =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))

    )

    (CONNECT_DATA =

      (SERVICE_NAME =ORA11)

    )

  )

LISTENER_ORA11 =

(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))