ora-12514:TNS:监听服务当前无法识别描述中的请求服务

在使用plsql登录时提示：ora-12514:TNS:监听服务当前无法识别描述中的请求服务

解决办法：
修改oracle服务端D:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN路径下的 listener.ora配置文件，并重启监听服务

listener.ora修改如下所示：

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
)
)
(SID_DESC =
(GLOBAL_DBNAME = ORCL)
(ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1)
(SID_NAME = ORCL)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
)
ADR_BASE_LISTENER = d:\app\Administrator

根据具体需求，添加或修改黑体部分内容。修改后重启“OracleOraDb11g_home1TNSListener”监听服务