oracle远程连接报错,远程连接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)

)

  )