ERROR - ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务

来源：百度知道 编辑：UC知道 时间：2024/07/04 03:03:13
在网上搜了很多，但是看不懂...
我是初学者，请大家帮我看看怎么解决。
我是在WEB中登陆Plus的但是不知道怎么错了。。。
1. Open the ""<OracleHome>/network/admin/listener.ora" file in the host,and you will see:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)
2. Add the following lines after the 7th line in the above
(SID_DESC =
(GLOBAL_DBNAME = ORACLE)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(SID_NAME = ORACLE)
)
3. At last the content of the file become to the following section:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)

监听器配置错误，按照你上面写的，把下面这段代码加入到""<OracleHome>/network/admin/listener.ora" 里面试试：
===========================================
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = ORACLE)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(SID_NAME = ORACLE)
)
)