- 论坛徽章:
- 0
|
本帖最后由 bpxyz 于 2011-07-29 23:55 编辑
环境是这样的: HP-UX小机刀片两片,暂称之为A和B,安腾CPU,16G内存,用HP ServiceGuard做了双机互备。
这两个刀片就只是为了跑oracle应用,但没有购买ORACLE的RAC授权,所以用ServiceGuard做服务的高可用。
实施步骤:
1、配置HP-UX系统的主机名和IP已经卷组等等操作系统级的东西;
2、配置ServiceGurad,配置存储,完成了浮动IP和存储资源的切换;
3、在两台刀片上为Oracle的安装和运行建立相应的环境;
4、在当前活动的的A机上安装好Oracle11gr2(B机未安装,因为我将Oracle安装在共享存储上,
B机挂载存储的路径和A机一样),并配置好监听和实例。
安装配置完成后,A机上的Oracle运行一切正常,监听上能动态注册两个服务,如下- Listening Endpoints Summary...
- (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
- (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.20)(PORT=1521)))
- Services Summary...
- Service "mydb.cdc2k.cn" has 1 instance(s).
- Instance "mydb", status READY, has 1 handler(s) for this service...
- Service "mydbXDB.cdc2k.cn" has 1 instance(s).
- Instance "mydb", status READY, has 1 handler(s) for this service...
- The command completed successfully
复制代码 但是将listener.ora中的HOST改为浮动IP后,能启动监听和数据库实例,但是无法动态注册服务,lsnrctl status显示结果如下:- Listening Endpoints Summary...
- (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
- (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.20)(PORT=1521)))
- The listener supports no services
- The command completed successfully
复制代码 尝试过在listener.ora里增加如下配置,可以实现服务的注册,但是监听下的服务却显示状态未知:
- 在listener.ora中添加的内容:
- SID_LIST_LISTENER =
- (SID_LIST =
- (SID_DESC =
- (SID_NAME = mydb)
- (ORACLE_HOME = /u01/app/oracle/product/11.2.0/OraHome)
- (SERVICE_NAME = mydb )
- )
- )
复制代码
- 运行lsnrctl start后,显示:
- Listening Endpoints Summary...
- (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
- (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.20)(PORT=1521)))
- Services Summary...
- Service "mydb" has 1 instance(s).
- Instance "mydb", status UNKNOWN, has 1 handler(s) for this service...
- The command completed successfully
复制代码 虽然可以在客户机上用plsql连接到实例,但总觉得好像是哪里没弄好似的。
请教高手:
在安装好的Oracle上,用本机IP或计算机名做监听,在监听上可以动态注册服务,
那如果用浮动IP来配置监听,如果才能让Oracle实例能动态注册服务呢?
先谢谢各位了! |
|