2023年8月1日发(作者：)

ORA-12514：TNS：监听程序当前⽆法识别连接描述符中请求的服务解决环境： 11g R2 + PL SQL Developer + SQL Plus问题：Oracle主服务和监听器服务已经启动，使⽤SQL Plus能够正常连接，使⽤PL SQL Developer连接报次错误：ORA-12514: TNS: 监听程序当前⽆法识别连接描述符中请求的服务。如图：解决：打开H:Oracleproduct11.2.0dbhome_1NETWORKADMIN（不同机器⽬录可能不同）⽬录下的⽂件，发现此⽂件内容如下：1. # Network Configuration File:

2. H:Oracleproduct11.2.0dbhome_

3. #Generated by Oracle configuration tools.

4.

5. SID_LIST_LISTENER=

6. (SID_LIST =

7. (SID_DESC =

8. (SID_NAME = CLRExtProc)

9. (ORACLE_HOME =H:Oracleproduct11.2.0dbhome_1)

10. (PROGRAM = extproc)

11. (ENVS ="EXTPROC_DLLS=ONLY:H:Oracleproduct11.2.0dbhome_")

12. )

13. )

14.

15. LISTENER=

16. (DESCRIPTION_LIST =

17. (DESCRIPTION =

18. (ADDRESS = (PROTOCOL = IPC)(KEY =EXTPROC1521))

19. (ADDRESS = (PROTOCOL = TCP)(HOST =localhost)(PORT = 1521))

20. )

21. )

22.

23. ADR_BASE_LISTENER= H:Oracle

修改成如下内容（注意红⾊部分的内容）：# Network Configuration File:H:Oracleproduct11.2.0dbhome_#Generated by Oracle configuration _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_") ) )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应该按照你⾃⼰的设置。

2023年8月1日发(作者：)

ORA-12514：TNS：监听程序当前⽆法识别连接描述符中请求的服务解决环境： 11g R2 + PL SQL Developer + SQL Plus问题：Oracle主服务和监听器服务已经启动，使⽤SQL Plus能够正常连接，使⽤PL SQL Developer连接报次错误：ORA-12514: TNS: 监听程序当前⽆法识别连接描述符中请求的服务。如图：解决：打开H:Oracleproduct11.2.0dbhome_1NETWORKADMIN（不同机器⽬录可能不同）⽬录下的⽂件，发现此⽂件内容如下：1. # Network Configuration File:

2. H:Oracleproduct11.2.0dbhome_

3. #Generated by Oracle configuration tools.

4.

5. SID_LIST_LISTENER=

6. (SID_LIST =

7. (SID_DESC =

8. (SID_NAME = CLRExtProc)

9. (ORACLE_HOME =H:Oracleproduct11.2.0dbhome_1)

10. (PROGRAM = extproc)

11. (ENVS ="EXTPROC_DLLS=ONLY:H:Oracleproduct11.2.0dbhome_")

12. )

13. )

14.

15. LISTENER=

16. (DESCRIPTION_LIST =

17. (DESCRIPTION =

18. (ADDRESS = (PROTOCOL = IPC)(KEY =EXTPROC1521))

19. (ADDRESS = (PROTOCOL = TCP)(HOST =localhost)(PORT = 1521))

20. )

21. )

22.

23. ADR_BASE_LISTENER= H:Oracle

修改成如下内容（注意红⾊部分的内容）：# Network Configuration File:H:Oracleproduct11.2.0dbhome_#Generated by Oracle configuration _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_") ) )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应该按照你⾃⼰的设置。