RAC application vip

RAC 의 RESOURCE 에 application vip 를 부여하여 failover 하게 활용할수 있다. apache, ogg 등등

구성은 간단하지만 application에 따라 작동방식, failover 등을 고려한다면 추가적인 script 작성 등 손 볼 부분은 많다..

 

------------------------------------------------------------------------------------------------

현재 /etc/hosts 화일

 

#### Public ######
192.168.56.50   rac1
192.168.56.51   rac2

 

#### Virtual ######
192.168.56.52   rac1-vip
192.168.56.53   rac2-vip

 

#### Private ######
10.10.10.1      rac1-priv
10.10.10.2      rac2-priv

 

#### SCAN ######
192.168.56.54   rac-scan

------------------------------------------------------------------------------------------------

 

1. 생성
[RAC1]root@rac1:/root# appvipcfg create -network=1 -ip=192.168.56.55 -vipname=appsvip -user=root

 

2. 시작

[RAC1]root@rac1:/root# crsctl start resource appsvip
CRS-2672: Attempting to start 'appsvip' on 'rac2'
CRS-2676: Start of 'appsvip' on 'rac2' succeeded

 

노드명을 안 주면 2번에서 뜬다. 다시..

[RAC1]root@rac1:/root# crsctl start resource appsvip -n rac1
CRS-2672: Attempting to start 'appsvip' on 'rac1'
CRS-2676: Start of 'appsvip' on 'rac1' succeeded

 

3. 확인

 

ifconfig 해보면

eth0:2    Link encap:Ethernet  HWaddr 08:00:27:BF:04:20 
          inet addr:192.168.56.55  Bcast:192.168.56.255  Mask:255.255.255.0
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1

 

appsvip
      1        ONLINE  ONLINE       rac2                     STABLE
appsvip2
      1        ONLINE  ONLINE       rac1                     STABLE

 

지울때는..

[RAC1]root@rac1:/root# crsctl stop res appsvip -f

[RAC1]root@rac1:/root# appvipcfg delete -vipname=appsvip

 

2개도 가능함..활용하기 나름일듯..

appvipcfg create -network=1 -ip=192.168.56.55 -vipname=appsvip -user=root
appvipcfg create -network=1 -ip=192.168.56.56 -vipname=appsvip2 -user=root

 

default 로 만들면 속성이 거의 정의되어 있지 않다.

 

crsctl stat res -p

NAME=appsvip
TYPE=app.appvipx.type
ACL=owner:root:rwx,pgrp:root:r-x,other::r--,user:root:r-x
ACTIONS=
ACTION_SCRIPT=
ACTION_TIMEOUT=60
ACTIVE_PLACEMENT=0
AGENT_FILENAME=%CRS_HOME%/bin/orarootagent%CRS_EXE_SUFFIX%
APPSVIP_FAILBACK=0
AUTO_START=restore
CARDINALITY=1
CHECK_INTERVAL=1
CHECK_TIMEOUT=0
CLEAN_TIMEOUT=60
DEGREE=1
DELETE_TIMEOUT=60
DESCRIPTION=Application VIP
ENABLED=1
FAILOVER_DELAY=0
FAILURE_INTERVAL=0
FAILURE_THRESHOLD=0
GEN_USR_ORA_STATIC_VIP=
GEN_USR_ORA_VIP=
HOSTING_MEMBERS=
INSTANCE_FAILOVER=1
INTERMEDIATE_TIMEOUT=0
LOAD=1
LOGGING_LEVEL=1
MODIFY_TIMEOUT=60
NLS_LANG=
OFFLINE_CHECK_INTERVAL=0
PLACEMENT=balanced
RELOCATE_BY_DEPENDENCY=1
RESTART_ATTEMPTS=0
SCRIPT_TIMEOUT=60
SERVER_CATEGORY=
SERVER_POOLS=*
START_CONCURRENCY=0
START_DEPENDENCIES=hard(ora.net1.network) pullup(ora.net1.network)
START_TIMEOUT=0
STOP_CONCURRENCY=0
STOP_DEPENDENCIES=hard(ora.net1.network)
STOP_TIMEOUT=0
TYPE_VERSION=1.1
UPTIME_THRESHOLD=7d
USER_WORKLOAD=no
USE_STICKINESS=0
USR_ORA_ENV=
USR_ORA_VIP=192.168.56.55
VERSION=12.1.0.1.0

 

Application VIP on second network ora.net2.network missing after addnode (문서 ID 1617281.1)에 근거

아래와 같이 필요한 속성값을 변경해 주면 되겠다.

 

crsctl modify resource appsvip -attr "RESTART_ATTEMPTS=2,START_TIMEOUT=100,STOP_TIMEOUT=100,CHECK_INTERVAL=10,USR_ORA_VIP=192.168.56.55,START_DEPENDENCIES='hard(ora.net1.network)pullup(ora.net1.network)',STOP_DEPENDENCIES='hard(ora.net1.network)',HOSTING_MEMBERS=rac1"