遠程連接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]