版本是?11g?R1?Win32

11g?安裝好后?正常?但是?將進程設置為手動后?
OracleOraDb11g_home1TNSListener
OracleServiceORCL
啟動順序?先OracleOraDb11g_home1TNSListener后OracleServiceORCL

報?Ora-12514：TNS：監聽程序當前無法識別鏈接描述符中請求的服務？

問題解決：

在D:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN下：

listener.ora：

# listener.ora Network Configuration File: D:\app\Administrator\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

?

SID_LIST_LISTENER =
? (SID_LIST =
??? (SID_DESC =
????? (SID_NAME = CLRExtProc)
????? (ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1)
????? (PROGRAM = extproc)
????? (ENVS = "EXTPROC_DLLS=ONLY:D:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")
??? )
? (SID_DESC =??
???? (GLOBAL_DBNAME = bdqn)??
???? (ORACLE_HOME = D:\oracle_11g\product\11.2.0\dbhome_1)??
???? (SID_NAME = bdqn)??
?? )??

? )

?

LISTENER =
? (DESCRIPTION_LIST =
??? (DESCRIPTION =
????? (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
????? (ADDRESS = (PROTOCOL = TCP)(HOST = PCmy)(PORT = 1521))
??? )
? )

ADR_BASE_LISTENER = D:\app\Administrator

?

tnsnames.ora：

#tnsnames.oraNetworkConfigurationFile:D:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

?

JBIT =
? (DESCRIPTION =
??? (ADDRESS_LIST =
????? (ADDRESS = (PROTOCOL = TCP)(HOST = PCmy)(PORT = 1521))
??? )
??? (CONNECT_DATA =
????? (SERVER = DEDICATED)
????? (SERVICE_NAME = jbit)
??? )
? )

BDQN =
? (DESCRIPTION =
??? (ADDRESS_LIST =
????? (ADDRESS = (PROTOCOL = TCP)(HOST = PCmy)(PORT = 1521))
??? )
??? (CONNECT_DATA =
????? (SERVER = DEDICATED)
????? (SERVICE_NAME = bdqn)
??? )
? )

?

ORACLR_CONNECTION_DATA =
? (DESCRIPTION =
??? (ADDRESS_LIST =
????? (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
??? )
??? (CONNECT_DATA =
????? (SID = CLRExtProc)
????? (PRESENTATION = RO)
??? )
? )

?

?

?

?

?

總結

以上是生活随笔為你收集整理的oracle 11g 服务启动后 监听程序当前无法识别SID的问题解决的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。