RAC中通过设置服务名实现业务分割

说明：通过在RAC中新增四个监听服务，来实现通过不同服务名连接到不同的实例。

1.查看并使用srvctl来增加服务名

[Oracle@bysrac1 ~]$ crs_stat -t
-bash: crs_stat: command not found
[oracle@bysrac1 ~]$ su - grid
Password:
[grid@bysrac1 ~]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 24-OCT-2013 09:41:36
Copyright （c） 1991, 2009, Oracle. All rights reserved.
Connecting to （DESCRIPTION=（ADDRESS=（PROTOCOL=IPC）（KEY=LISTENER）））
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 24-OCT-2013 09:24:34
Uptime 0 days 0 hr. 17 min. 2 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /g01/app/11.2.0/grid/network/admin/listener.ora
Listener Log File /g01/app/grid/diag/tnslsnr/bysrac1/listener/alert/log.xml
Listening Endpoints Summary...
（DESCRIPTION=（ADDRESS=（PROTOCOL=ipc）（KEY=LISTENER）））
（DESCRIPTION=（ADDRESS=（PROTOCOL=tcp）（HOST=192.168.1.221）（PORT=1521）））
（DESCRIPTION=（ADDRESS=（PROTOCOL=tcp）（HOST=192.168.1.226）（PORT=1521）））
Services Summary...
Service "+ASM" has 1 instance（s）.
Instance "+ASM1", status READY, has 1 handler（s） for this service...
Service "bysrac" has 1 instance（s）.
Instance "bysrac1", status READY, has 1 handler（s） for this service...
The command completed successfully

使用srvctl向监听中增加 jiaoyi ，fengkong，caiwu，jiesuan四个服务--要用ORACLE用户

[grid@bysrac1 ~]$ srvctl add service -d bysrac -s jiaoyi -r "bysrac1"
PRCD-1026 : Failed to create service jiaoyi for database bysrac
PRKH-1014 : Current user grid is not the same as oracle owner oracle of oracle home /u01/app/oracle/product/11.2.0/dbhome_1.
[grid@bysrac1 ~]$ exit
logout
[oracle@bysrac1 ~]$ srvctl add service -d bysrac -s jiaoyi -r "bysrac1"
[oracle@bysrac1 ~]$ srvctl add service -d bysrac -s fengkong -r "bysrac2"
[oracle@bysrac1 ~]$ srvctl add service -d bysrac -s caiwu -r "bysrac1"
[oracle@bysrac1 ~]$ srvctl add service -d bysrac -s jiesuan -r "bysrac2"
[oracle@bysrac1 ~]$ su - grid
Password:
[grid@bysrac1 ~]$ crs_stat -t 可以看到新增的四个服务已经存在，但还是OFFLINE状态。
Name Type Target State Host
------------------------------------------------------------
ora....MBAK.dg ora....up.type OFFLINE OFFLINE
ora....DATA.dg ora....up.type ONLINE ONLINE bysrac1
ora....SMDG.dg ora....up.type ONLINE ONLINE bysrac1
ora....ER.lsnr ora....er.type ONLINE ONLINE bysrac1
ora....N1.lsnr ora....er.type ONLINE ONLINE bysrac2
ora.asm ora.asm.type ONLINE ONLINE bysrac1
ora....iwu.svc ora....ce.type OFFLINE OFFLINE
ora.bysrac.db ora....se.type ONLINE ONLINE bysrac1
ora....ong.svc ora....ce.type OFFLINE OFFLINE
ora....oyi.svc ora....ce.type OFFLINE OFFLINE
ora....uan.svc ora....ce.type OFFLINE OFFLINE
ora....SM1.asm application ONLINE ONLINE bysrac1
ora....C1.lsnr application ONLINE ONLINE bysrac1
ora....ac1.gsd application OFFLINE OFFLINE
ora....ac1.ons application ONLINE ONLINE bysrac1
ora....ac1.vip ora....t1.type ONLINE ONLINE bysrac1
ora....SM2.asm application ONLINE ONLINE bysrac2
ora....C2.lsnr application ONLINE ONLINE bysrac2
ora....ac2.gsd application OFFLINE OFFLINE
ora....ac2.ons application ONLINE ONLINE bysrac2
ora....ac2.vip ora....t1.type ONLINE ONLINE bysrac2
ora.eons ora.eons.type ONLINE ONLINE bysrac1
ora.gsd ora.gsd.type OFFLINE OFFLINE
ora....network ora....rk.type ONLINE ONLINE bysrac1
ora.oc4j ora.oc4j.type OFFLINE OFFLINE
ora.ons ora.ons.type ONLINE ONLINE bysrac1ora.scan1.vip ora....ip.type ONLINE ONLINE bysrac2

启动新增的四个监听的服务

[grid@bysrac1 ~]$ crs_start ora.bysrac.jiaoyi.svc
Attempting to start `ora.bysrac.jiaoyi.svc` on member `bysrac1`
Start of `ora.bysrac.jiaoyi.svc` on member `bysrac1` succeeded.
[grid@bysrac1 ~]$ crs_start ora.bysrac.fengkong.svc
Attempting to stop `ora.bysrac.db` on member `bysrac2`
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
Process ID: 0
Session ID: 0 Serial number: 0

Stop of `ora.bysrac.db` on member `bysrac2` succeeded.
Attempting to start `ora.bysrac.db` on member `bysrac2`
Start of `ora.bysrac.db` on member `bysrac2` succeeded.
Attempting to start `ora.bysrac.jiesuan.svc` on member `bysrac2`
Start of `ora.bysrac.jiesuan.svc` on member `bysrac2` succeeded.
Attempting to start `ora.bysrac.fengkong.svc` on member `bysrac2`
Start of `ora.bysrac.fengkong.svc` on member `bysrac2` succeeded.
[grid@bysrac1 ~]$ crs_start ora.bysrac.caiwu.svc
Attempting to start `ora.bysrac.caiwu.svc` on member `bysrac1`
Start of `ora.bysrac.caiwu.svc` on member `bysrac1` succeeded.
[grid@bysrac1 ~]$ crs_start ora.bysrac.jiesuan.svc
CRS-5702: Resource "ora.bysrac.jiesuan.svc" is already running on "bysrac2"
CRS-0223: Resource "ora.bysrac.jiesuan.svc" has placement error.更多详情见请继续阅读下一页的精彩内容： http://www.linuxidc.com/Linux/2013-10/92021p2.htm相关阅读：RAC环境下管理OGG-HA http://www.linuxidc.com/Linux/2012-07/65796.htmRAC环境下配置OGG同步 http://www.linuxidc.com/Linux/2012-07/65794.htmGoldenGate单向表DML同步 http://www.linuxidc.com/Linux/2013-04/82942.htmOracle GoldenGate 系列：Extract 进程的恢复原理 http://www.linuxidc.com/Linux/2013-04/82563.htmOracle GoldenGate安装配置 http://www.linuxidc.com/Linux/2013-02/79455.htmOracle goldengate的OGG-01004 OGG-1296错误 http://www.linuxidc.com/Linux/2011-08/40951.htm更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=12

GoldenGate不使用数据泵完成Oracle-Oracle的双向复制克隆安装Oracle 11G HOME相关资讯 rac

RAC本地数据文件迁移至ASM的方法-- （05月23日）
浅谈RAC中的负载均衡（09/06/2015 21:49:33）
Oracle 11gR2 RAC实时应用集群（01/05/2015 09:17:03）

RAC之间消息传输流量控制（12/26/2015 15:52:38）
Oracle 11.2.0.4 RAC日志记录的时（01/29/2015 08:46:34）
基于Workstation8、CentOS6.5实现（01/04/2015 15:42:35）

本文评论查看全部评论（0）