ORA-12514 TNS 监听程序当前无法识别连接描述符中请求服务
打开C:\app\tang\product\11.2.0\dbhome_1\NETWORK\ADMIN(不同机器目录可能不同)目录下的listener.ora文件,发现此文件内容如下:
1。#listener.ora Network Configuration File:
2.C:\app\tang\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora
3.#Generated by Oracle configuration tools.
4.
5.SID_LIST_LISTENER=
6. (SID_LIST =
7. (SID_DESC =
8. (SID_NAME = CLRExtProc)
9. (ORACLE_HOME =C:\app\tang\product\11.2.0\dbhome_1)
10. (PROGRAM = extproc)
11. (ENVS =”EXTPROC_DLLS=ONLY:C:\app\tang\product\11.2.0\dbhome_1\bin\oraclr11.dll”)
12. )
13. )
14.
15.LISTENER=
16. (DESCRIPTION_LIST =
17. (DESCRIPTION =
18. (ADDRESS = (PROTOCOL = IPC)(KEY =EXTPROC1521))
19. (ADDRESS = (PROTOCOL = TCP)(HOST =localhost)(PORT = 1521))