日期:2014-05-17  浏览次数:21081 次

ORACLE XE提示无监听
今天装了个XE,但一连接就直接报12541错误,说无监听程序
下面是tnsnames的配置
XE =
  (DESCRIPTION =
  (ADDRESS = (PROTOCOL = TCP)(HOST = xrkj-e86332a8bd)(PORT = 1521))
  (CONNECT_DATA =
  (SERVER = DEDICATED)
  (SERVICE_NAME = XE)
  )
  )


下面是listener的配置
SID_LIST_LISTENER =
  (SID_LIST =
  (SID_DESC =
  (SID_NAME = PLSExtProc)
  (ORACLE_HOME = D:\oracle\xe\app\oracle\product\10.2.0\server)
  (PROGRAM = extproc)
  )
  (SID_DESC =
  (SID_NAME = CLRExtProc)
  (ORACLE_HOME = D:\oracle\xe\app\oracle\product\10.2.0\server)
  (PROGRAM = extproc)
  )
  )

LISTENER =
  (DESCRIPTION_LIST =
  (DESCRIPTION =
  (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
  (ADDRESS = (PROTOCOL = TCP)(HOST = xrkj-e86332a8bd)(PORT = 1521))
  )
  )

DEFAULT_SERVICE_LISTENER = (XE)


xrkj-e86332a8bd为计算机名
用sqlplus连接的话是可以连接,但连接不了XE,如下:
connect sys/sys as sysdba 成功
connect sys/sys@XE as sysdba 报错:ORA-12541:TNS:无监听程序
但服务器的监听都是启动了的
就搞不懂了,望各位牛人赐教

------解决方案--------------------
tnsping XE
看看