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

 我来答

1个回答

#热议# 不吃早饭真的会得胆结石吗？

太平洋科技

优质机构答主

2023-01-06 · 百度认证:广东太平洋互联网信息服务有限公司官方账号,优质数码...

太平洋科技

太平洋电脑网通过分析、评测生活及工作中各类消费品，让消费者客观了解产品性能及安全状况，帮助用户做出理性购买选择。同时科普各领域产品知识，解答用户选购及使用中所遇问题。

向TA提问

关注

展开全部

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

编辑代码：

XIEHENG_192.168.16.20 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.16.20)(PORT = 1521))
(CONNECT_DATA =
(SID = XIEHENG)
(SERVER = DEDICATED)
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)