Win7旗舰版安装Oracle11g后,数据库可以正常使用,重启系统,再次连接数据库,提示:
ORA-12514:TNS:监听程序当前无法识别连接描述符中请求的服务
解决方法:
1、打开listener.ora文件(\product\11.2.0\dbhome_1\NETWORK\ADMIN\)。
2、增加以下红色标识的一段文字。
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME =
CLRExtProc)
(ORACLE_HOME =
D:\app\Thor\product\11.2.0\dbhome_1)
(PROGRAM =
extproc)
(ENVS =
"EXTPROC_DLLS=ONLY:D:\app\Thor\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
(SID_DESC =
(GLOBAL_DBNAME
= dev)
(SID_NAME =
dev)
(ORACLE_HOME =
D:\app\Thor\product\11.2.0\dbhome_1)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION
=
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS
= (PROTOCOL = TCP)(HOST = 172.18.124.106)(PORT = 1521))
)
)
ADR_BASE_LISTENER = D:\app\Thor
注:次操作将创建的数据库的SID描述告知给监听器。