ORACLE11g ORA-12514 TNS 监听程序当前无法识别连接描述符中请求的服务

               

 

1、TNS连接错误

同事跟我说连接oracle数据库报错ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务，如下所示：

 

 

2、查看本地TNSPING

查看本地的tns配置：

WXX =      (DESCRIPTION =        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.121.58)(PORT = 1521))        (CONNECT_DATA =          (SERVER = DEDICATED)          (SERVICE_NAME = orcl)        )   )

 

 

查看本地的tnsping是ok的

C:\Users\Administrator>tnsping WXX       TNS Ping Utility for 32-bit Windows:  Version 11.2.0.1.0 - Production on 26-10月-2016 11:31:04       Copyright (c) 1997, 2010, Oracle.  All rights reserved.       已使用的参数文件:   D:\app\Administrator\product\11.2.0\client_2\network\admin\sqlnet.ora           已使用 TNSNAMES 适配器来解析别名   尝试连接 (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.121.58)(PORT  = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))   OK (30 毫秒)       C:\Users\Administrator>

 

 

本地的tnsp