環境:oracle11g R2 + PL SQL Developer + SQL Plus 問題:Oracle主服務和監聽器服務已經啟動,使用SQL Plus能夠正常連接,使用PL SQL Developer連接報次錯誤:ORA-12514: TNS: 監聽程序當前無法識別連接描述符中請求的服務。如圖: 解決: 打開H:Oraclepr
環境:Oracle?11g R2 + PL SQL Developer + SQL Plus
問題:Oracle主服務和監聽器服務已經啟動,使用SQL Plus能夠正常連接,使用PL SQL Developer連接報次錯誤:ORA-12514: TNS: 監聽程序當前無法識別連接描述符中請求的服務。如圖:
|
?
解決:
打開H:Oracleproduct11.2.0dbhome_1NETWORKADMIN(不同機器目錄可能不同)目錄下的listener.ora文件,發現此文件內容如下:
- #listener.ora?Network?Configuration?File:??
- H:Oracleproduct11.2.0dbhome_1networkadminlistener.ora??
- #Generated?by?Oracle?configuration?tools.??
- ???
- SID_LIST_LISTENER=??
- ??(SID_LIST?=??
- ????(SID_DESC?=??
- ??????(SID_NAME?=?CLRExtProc)??
- ??????(Oracle_HOME?=H:Oracleproduct11.2.0dbhome_1)??
- ??????(PROGRAM?=?extproc)??
- ??????(ENVS?=”EXTPROC_DLLS=ONLY:H:Oracleproduct11.2.0dbhome_1binoraclr11.dll”)??
- ????)??
- ??)??
- ???
- LISTENER=??
- ??(DESCRIPTION_LIST?=??
- ????(DESCRIPTION?=??
- ??????(ADDRESS?=?(PROTOCOL?=?IPC)(KEY?=EXTPROC1521))??
- ??????(ADDRESS?=?(PROTOCOL?=?TCP)(HOST?=localhost)(PORT?=?1521))??
- ????)??
- ??)??
- ???
- ADR_BASE_LISTENER=?H:Oracle??
修改成如下內容(注意紅色部分的內容):
#listener.ora Network Configuration File:
H:Oracleproduct11.2.0dbhome_1networkadminlistener.ora
#Generated by?Oracle?configuration tools.
SID_LIST_LISTENER=
??(SID_LIST =
???????? (SID_DESC =
????? (GLOBAL_DBNAME = ORCL)
????? (Oracle_HOME =H:Oracleproduct11.2.0dbhome_1)
????? (SID_NAME = ORCL)
??? )
??? (SID_DESC =
????? (SID_NAME = CLRExtProc)
????? (Oracle_HOME = H:Oracleproduct11.2.0dbhome_1)
????? (PROGRAM = extproc)
????? (ENVS =”EXTPROC_DLLS=ONLY:H:Oracleproduct11.2.0dbhome_1binoraclr11.dll”)
??? )
? )
LISTENER=
? (DESCRIPTION_LIST =
??? (DESCRIPTION =
????? (ADDRESS = (PROTOCOL = IPC)(KEY =EXTPROC1521))
????? (ADDRESS = (PROTOCOL = TCP)(HOST =localhost)(PORT = 1521))
??? )
? )
ADR_BASE_LISTENER= H:Oracle
說明:每臺電腦的Oracle安裝目錄和實例名不盡相同,修改此文件的ORACLE_HOME(本機Oracle安裝目錄)和SID_NAME應該按照你自己的設置。
SID查看請參照此圖:
?