求助，急！！aix5.3下ORACLE 监听自动停止

zengkan

两台IBM p570搭建的hacmp 浮动地址为192.168.1.170
oracle版本为9.2.0.6.0

监听宕掉后查询其状态如下：

[smsdb1]$lsnrctl status
LSNRCTL for IBM/AIX RISC System/6000: Version 9.2.0.6.0 - Production on 13-JUL-2007 09:27:00
Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   IBM/AIX RISC System/6000 Error: 79: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.170)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   IBM/AIX RISC System/6000 Error: 79: Connection refused


请各位大大帮忙分析一下，谢谢啊

zengkan

而且监听启动的时候也很慢  要两三分钟才能完成

[smsdb1]$lsnrctl start
LSNRCTL for IBM/AIX RISC System/6000: Version 9.2.0.6.0 - Production on 13-JUL-2007 09:27:24
Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved.
Starting /home/oracle/app/oracle/product/9.2/bin/tnslsnr: please wait...
TNSLSNR for IBM/AIX RISC System/6000: Version 9.2.0.6.0 - Production
System parameter file is /home/oracle/app/oracle/product/9.2/network/admin/listener.ora
Log messages written to /home/oracle/app/oracle/product/9.2/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.170)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))－－到这一步的时候就很慢了
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for IBM/AIX RISC System/6000: Version 9.2.0.6.0 - Production
Start Date                13-JUL-2007 09:27:24
Uptime                    0 days 0 hr. 1 min. 14 sec
Trace Level               off
Security                  OFF
SNMP                      OFF
Listener Parameter File   /home/oracle/app/oracle/product/9.2/network/admin/listener.ora
Listener Log File         /home/oracle/app/oracle/product/9.2/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.170)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "ora92" has 1 instance(s).
  Instance "ora92", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

zengkan

刚才查了下资料，说是可能与hosts文件配置有关系，贴上来大家帮忙看看

# Internet Address      Hostname        # Comments
# 192.9.200.1           net0sample      # ethernet name/address
# 128.100.0.1           token0sample    # token ring name/address
# 10.2.0.2              x25sample       # x.25 name/address
127.0.0.1       loopback        localhost       # loopback (lo0) name/address
192.168.1.170   icdnode_float
192.168.1.165   icdnode1_boot   smsdb1
192.168.1.166   icdnode2_boot   smsdb2
10.71.0.47      icdnode1_standby
#

comerliang

类似的问题
AIX 5310
oracle 10.2.0.5

监听经常自动停止

找了很多文章，有说加
SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER=OFF
的，

renxiao2003

回复 4# comerliang


    那你就改了试试看啊。

tacsoft

现在监听器指到的是那个浮动地址，该地址不是物理地址，你那个地址稳定吗？慢应该是多次尝试才找到，而且有断的现象，好好检查你那个双机的状态，网卡状态。

有一种情况，当发生主、备机切换时老是切换不成功，检查发现是备机的主网卡绑定浮动IP老是失败，再进一步排查，发现失败的原因是备机主网卡绑定MAC地址失败，由于IBM双机配置时需要将Service IP配置为一个固定的MAC地址，规则是取主机主网卡的MAC地址，将最后两位改为固定的两个数字（要求与原主网卡地址不同，如定制为89）。
问题排除：最后修改了HA 拓扑图中以太网配置中Service Adapter配置，去掉MAC地址的配置（置为空），让后同步双机，再进行倒换，一切OK.