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

2014-11-24 17:43:48 · 作者: · 浏览: 0

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


[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 bysrac1


ora.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.


相关阅读: