oracle共享服务器配置后，无法进行正常的连接，报错ora-28547的解决方法

最新推荐文章于 2021-04-16 04:53:11 发布

原创最新推荐文章于 2021-04-16 04:53:11 发布 · 2.3k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#oracle #服务器 #initialization #protocols #server #service

本文介绍ORA-28547错误的原因及解决办法，通常由于客户端和服务端网络协议不一致引起。文章提供了检查网络配置的具体步骤，并给出了解决方案，包括调整监听器设置和重新注册实例。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

错误描述： ORA-28547: connection to server failed, probable Net8 admin error Cause: A failure occurred during initialization of a network connection from a client process to the Oracle server: The connection was completed but a disconnect occurred while trying to perform protocol-specific initialization, usually due to use of different network protocols by opposite sides of the connection. This usually is caused by incorrect Net8 administrative setup for database links or external procedure calls. The most frequent specific causes are: -- The connection uses a connect string which refers to a Heterogeneous Services agent instead of an Oracle server. -- The connection uses a connect string which includes an (HS=) specification. Action: Check Net8 administration in the following ways: -- When using TNSNAMES.ORA or an Oracle Names server, make sure that the client connection to the ORACLE server uses the correct service name or SID. -- Check LISTENER.ORA on the connection end point's host machine to assure that this service name or SID refers to the correct server. -- Confirm in TNSNAMES.ORA or the equivalent service definition that the connect string does NOT contain (HS=).

错误原因：监听器用的IP地址在服务器进行监听，调度进程使用的是主机名来注册到服务器的监听器上，那么就会出现这个错误。

解决方法：将监听器监听的主机地址的方式修改为HOSTNAME的方式来监听，重启监听器(lsnrctl stop /lsnrctl start)，sys登录oracle实例，重新动态注册实例到监听器(alter system register)，方可解决。