远程连接Oracle报错：TNS-: no listener

远程连接时报错：TNS-: no listener
原因：监听器未启动
解决方案：
重新配置$Oracle_HOME/network/admin中的listener.ora
如下的标准文件

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
-
 

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

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = PLSEXTPROC
      (Oracle_HOME = /u01/app/oracle/product/11.2.0/db_1)
      (SID_NAME = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = ORCL)
      (Oracle_HOME = /u01/app/oracle/product/11.2.0/db_1)
      (SID_NAME = ORCL)
    )
  )

服务器租用/服务器托管中国五强！虚拟主机域名注册顶级提供商！15年品质保障！--亿恩科技[ENKJ.COM]