ORA-12514 TNS:listener does not currently know of service requested in connect descriptor

 

 

windows 版 Oracle11g
在rman 环境下，执行了SHUTDOWN IMMEDIATE
之后，再做startup nomount;
提示 ORA-12514 TNS:listener does not currently know of service requested in connect descriptor
连接中断了。

解决方法：
listener.ora 中加入
(SID_DESC =
(GLOBAL_DBNAME = XE)
(ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server\database)
(SID_NAME = XE)
)

再重启listener
lsnrctl stop
lsnrctl start