Question

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

Answer 1

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)