HA安装oracle 11G 监听问题

[lovercat]

环境是这样的

hostA hostB 安装rhel5.4 配置rhcs集群套件，集群状态正常浮动ip、文件系统都可以正常切换。
在hostA上安装oracle 11G ，程序和数据库都放到集群的文件系统上，这样节点机故障时只要执行集群脚本就可以把数据库启动

现在的问题是

我希望修改listener.ora和tnsnames.ora中的host来使listener在浮动ip上监听，目前host修改为hostA或者hostB都可以在对应的节点启动监听程序，改为ha后采用动态注册时，提示 the listener supports no services,静态注册提示UNKNOWN，执行alter system register也注册不上，求解。


/etc/hosts

192.168.0.1 hostA
192.168.0.2 hostB
192.168.0.3 ha

[ngx20080110]

不懂，帮顶，关注

[inthirties]

listener.ora的文件是怎么配的

[「已注销」]

listener.ora参数文件贴出来,瞧瞧...

[lovercat]

listener起来了，可是dbconsole起来后报 TNS:no listener

[lovercat]

listener.ora

# listener.ora Network Configuration File: /app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = ORCL)
(ORACLE_HOME = /app/oracle/product/11.2.0/dbhome_1/)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ha)(PORT = 1521))
)
)

ADR_BASE_LISTENER = /app/oracle


lsnrctl status


LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 08-NOV-2009 02:42:01

Copyright (c) 1991, 2009, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ha)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 07-NOV-2009 16:07:59
Uptime 0 days 10 hr. 34 min. 1 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File /app/oracle/diag/tnslsnr/rh64c1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.18.23)(PORT=1521)))
Services Summary...
Service "ORCL" has 1 instance(s).
Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

[lovercat]

额，不能修改帖子，1楼ip地址为示例，实际参数以4楼为准

[inthirties]

你是说dbconsole里看不到listener是启动的么？

[waymar]

可以设置parameter Local_listener

[lovercat]

好了，设置oracle_home变量就好了，话说这环境变量一共有多少啊。。。

[HeroChen24]

能把你的做法贴出来吗？