ora-12154 无法处理服务器名错误如何处理？

ora-12154 无法处理服务器名错误解决方法如下：

编辑代码：

1. XIEHENG_192.168.16.20 =
   (DESCRIPTION =
   (ADDRESS_LIST =
   (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.16.20)(PORT = 1521))
   (CONNECT_DATA =
   (SID = XIEHENG)
   (SERVER = DEDICATED)

2. GCBORA_192.168.1.3 =
   (DESCRIPTION =
   ( ADDRESS_LIST =
   (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.3)(PORT = 1521))
   )
   (CONNECT_DATA =
   (SID = GCBORA)
   (SERVER = DEDICATED)
   

3.ORCL29 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.6.29)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = orcl)

4. ORCL32 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.31.6.32)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = orcl)

扩展阅读：conn时报错ora-12154 ... ora-12154解决方案 ... 解决ora-12154的问题 ... ora-12154解决办法 ... ora12154无法处理服务名 ... 登录sql时出现ora-12154 ... ora12154 tns listener ... ora-02015 解决 ... ora12154tnscouldnot ...