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