oracle 找不到监听 lister 有问题？？进来看看吧

最近用oracle做项目，总隔三差五的没监听而过不久就好了，系统问题，然后懵逼了，浪费时间。

哎，装完系统plsql 还能用，过会又没监听，草，然后配置下 文件找了一些总结了一下

杂技这里找到你的文件 jlister.ora

修改

# listener.ora Network Configuration File: D:\app\zyb_pc\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.

LISTENER1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = zyb)(PORT = 1521))
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DANAME = ORCL)
      (ORACLE_HOME = D:\Oracle\orcle\product\11.2.0\dbhome_1)
     )
      (SID_NAME = ORCL)  
      (SID_DESC=
      (PROGRAM = extproc)
      (SID_NAME=PLSExtProc)
     (ORACLE_HOME = D:\Oracle\orcle\product\11.2.0\dbhome_1)
    )
  )


LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
  )
ADR_BASE_LISTENER = D:\oracle

重启监听服务

就好了，因人而异