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
看看