ora-28547 连接服务器失败，可能是ORACLE NET 管理错误

Oracle RAC集群监听器状态异常解决

最新推荐文章于 2025-09-29 13:37:48 发布

最新推荐文章于 2025-09-29 13:37:48 发布 · 176 阅读

文章标签：

#数据库 #网络

本文详细描述了如何解决Oracle RAC集群中监听器状态异常的问题，包括使用CRS_STATS查看状态、检查LISTENER.ORA配置、执行srvctl命令重启监听器等步骤，最终通过PL/SQLDEVELOPER成功连接验证解决方案的有效性。

1.平台ORACLE10G RAC,反复lsnrctl stop(start)但，结果还是此报错！

2.用CRS_STATS查看状态

rac1-> crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.....CRM.cs application OFFLINE OFFLINE
ora....db1.srv application OFFLINE OFFLINE
ora.devdb.db application ONLINE ONLINE rac2
ora....b1.inst application ONLINE ONLINE rac1
ora....b2.inst application ONLINE ONLINE rac2
ora....SM1.asm application ONLINE ONLINE rac1
ora....C1.lsnr application OFFLINE OFFLINE
ora.rac1.gsd application ONLINE ONLINE rac1
ora.rac1.ons application ONLINE ONLINE rac1
ora.rac1.vip application ONLINE ONLINE rac1
ora....SM2.asm application ONLINE ONLINE rac2
ora....C2.lsnr application ONLINE OFFLINE
ora.rac2.gsd application ONLINE ONLINE rac2
ora.rac2.ons application ONLINE ONLINE rac2
ora.rac2.vip application ONLINE ONLINE rac2

可以看到状态都为OFFLINE，虽然用lsnrctl status可以看到监听已经起来了；

3.查看LISTENER.ORA，注释(PROGRAM = extproc)

rac1-> more listener.ora
# listener.ora.rac1 Network Configuration File: /u01/oracle/product/10.2.0/db_1/network/admin/listener.ora.rac1
# Generated by Oracle configuration tools.

LISTENER_RAC1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip)(PORT = 1521)(IP = FIRST))
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.96.171)(PORT = 1521)(IP = FIRST))
)
)

SID_LIST_LISTENER_RAC1 =
(SID_LIST =
(SID_DESC =
(SID_NAME = devdb1)
(ORACLE_HOME = /u01/oracle/product/10.2.0/db_1)
# (PROGRAM = extproc)
)
)

4.2节点上分别执行

srvctl stop listener -n rac1

srvctl stop listener -n rac2

srvctl start listerner -n rac1

srvctl start listener -n rac2

5.再次查看状态,可以看到已经起来了

rac2-> crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.....CRM.cs application OFFLINE OFFLINE
ora....db1.srv application OFFLINE OFFLINE
ora.devdb.db application ONLINE ONLINE rac2
ora....b1.inst application ONLINE ONLINE rac1
ora....b2.inst application ONLINE ONLINE rac2
ora....SM1.asm application ONLINE ONLINE rac1
ora....C1.lsnr application ONLINE ONLINE rac1
ora.rac1.gsd application ONLINE ONLINE rac1
ora.rac1.ons application ONLINE ONLINE rac1
ora.rac1.vip application ONLINE ONLINE rac1
ora....SM2.asm application ONLINE ONLINE rac2
ora....C2.lsnr application ONLINE ONLINE rac2
ora.rac2.gsd application ONLINE ONLINE rac2
ora.rac2.ons application ONLINE ONLINE rac2
ora.rac2.vip application ONLINE ONLINE rac2

6.再次用PL/SQL DEVELOPER连接，OK！