环境是这样的 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/hosts192.168.0.1 hostA
192.168.0.2 hostB
192.168.0.3 ha
在hostA上安装oracle 11G ,程序和数据库都放到集群的文件系统上,这样节点机故障时只要执行集群脚本就可以把数据库启动现在的问题是我希望修改listener.ora和tnsnames.ora中的host来使listener在浮动ip上监听,目前host修改为hostA或者hostB都可以在对应的节点启动监听程序,改为ha后采用动态注册时,提示 the listener supports no services,静态注册提示UNKNOWN,执行alter system register也注册不上,求解。
/etc/hosts192.168.0.1 hostA
192.168.0.2 hostB
192.168.0.3 ha
# 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:01Copyright (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