Wednesday, August 08, 2007

[Oracle 10G] Relocate service on RAC

When Some node of Oracle RAC restart. Serices on that node will relocate to other nodes.

We check by crs_stat.

A Resource Target State
----------- ------ -----
ora.H.RADIUS.H1.srv ONLINE ONLINE on h02
ora.H.R.cs ONLINE ONLINE on h01
ora.H.U.H1.srv ONLINE ONLINE on h02
ora.H.U.cs ONLINE ONLINE on h01
ora.H.W.H1.srv ONLINE ONLINE on h02
ora.H.W.cs ONLINE ONLINE on h01

ora.H.H1.inst ONLINE ONLINE on h01
ora.H.H2.inst ONLINE ONLINE on h02
ora.H.db ONLINE ONLINE on h01
ora.h01.ASM1.asm ONLINE ONLINE on h01
ora.h01.LISTENER_H01.lsnr ONLINE ONLINE on h01
ora.h01.gsd ONLINE ONLINE on h01
ora.h01.ons ONLINE ONLINE on h01
ora.h01.vip ONLINE ONLINE on h01
ora.h02.ASM2.asm ONLINE ONLINE on h02
ora.h02.LISTENER_H02.lsnr ONLINE ONLINE on h02
ora.h02.gsd ONLINE ONLINE on h02
ora.h02.ons ONLINE ONLINE on h02
ora.h02.vip ONLINE ONLINE on h02


Services on RAC has stated on h02,that some connections will connect to h02 when pass services.

If we need some connection to pass h01, So we should relocate.

#srvctl relocate service -d H -s U -i H2 -t H1
#srvctl relocate service -d H -s W -i H2 -t H1
#srvctl relocate service -d H -s H -i H2 -t H1


A Resource Target State
----------- ------ -----
ora.H.RADIUS.H1.srv ONLINE ONLINE on h01
ora.H.R.cs ONLINE ONLINE on h01
ora.H.U.H1.srv ONLINE ONLINE on h01
ora.H.U.cs ONLINE ONLINE on h01
ora.H.W.H1.srv ONLINE ONLINE on h01
ora.H.W.cs ONLINE ONLINE on h01

ora.H.H1.inst ONLINE ONLINE on h01
ora.H.H2.inst ONLINE ONLINE on h02
ora.H.db ONLINE ONLINE on h01
ora.h01.ASM1.asm ONLINE ONLINE on h01
ora.h01.LISTENER_H01.lsnr ONLINE ONLINE on h01
ora.h01.gsd ONLINE ONLINE on h01
ora.h01.ons ONLINE ONLINE on h01
ora.h01.vip ONLINE ONLINE on h01
ora.h02.ASM2.asm ONLINE ONLINE on h02
ora.h02.LISTENER_H02.lsnr ONLINE ONLINE on h02
ora.h02.gsd ONLINE ONLINE on h02
ora.h02.ons ONLINE ONLINE on h02
ora.h02.vip ONLINE ONLINE on h02

2 comments:

VINAY KUMAR said...

when the node comes back, does the services relocate automatically

Surachart Opun said...

Nope
We have to relocate by manual.