###################################################################
## How to add an Application VIP to Oracle Cluster 11gR2
###################################################################
Oracle Clusterware includes the utility appvipcfg which allows to easily create application VIPs; below an example based on a cluster 11.2.0.3.1
[root@lnxcld02 ~]# appvipcfg -h Production Copyright 2007, 2008, Oracle.All rights reserved Unknown option: h
Usage: appvipcfg create -network=<network_number> -ip=<ip_address> -vipname=<vipname> -user=<user_name>[-group=<group_name>] [-failback=0 | 1] delete -vipname=<vipname>
--Example to run as root user: [root@lnxcld02 ~]# appvipcfg create -network=1 -ip=192.168.2.200 -vipname=myappvip -user=grid -group=oinstall
Production Copyright 2007, 2008, Oracle.All rights reserved 2012-02-10 14:39:23: Creating Resource Type 2012-02-10 14:39:23: Executing /home/GRID_INFRA/product/11.2.0.3/bin/crsctl add type app.appvip_net1.type -basetype ora.cluster_vip_net1.type -file /home/GRID_INFRA/product/11.2.0.3/crs/template/appvip.type 2012-02-10 14:39:23: Executing cmd: /home/GRID_INFRA/product/11.2.0.3/bin/crsctl add type app.appvip_net1.type -basetype ora.cluster_vip_net1.type -file /home/GRID_INFRA/product/11.2.0.3/crs/template/appvip.type 2012-02-10 14:39:26: Create the Resource 2012-02-10 14:39:26: Executing /home/GRID_INFRA/product/11.2.0.3/bin/crsctl add resource myappvip -type app.appvip_net1.type -attr "USR_ORA_VIP=192.168.2.200,START_DEPENDENCIES=hard(ora.net1.network) pullup(ora.net1.network),STOP_DEPENDENCIES=hard(ora.net1.network),ACL='owner:root:rwx,pgrp:root:r-x,other::r--,group:oinstall:r-x,user:grid:r-x',HOSTING_MEMBERS=lnxcld02,APPSVIP_FAILBACK=" 2012-02-10 14:39:26: Executing cmd: /home/GRID_INFRA/product/11.2.0.3/bin/crsctl add resource myappvip -type app.appvip_net1.type -attr "USR_ORA_VIP=192.168.2.200,START_DEPENDENCIES=hard(ora.net1.network) pullup(ora.net1.network),STOP_DEPENDENCIES=hard(ora.net1.network),ACL='owner:root:rwx,pgrp:root:r-x,other::r--,group:oinstall:r-x,user:grid:r-x',HOSTING_MEMBERS=lnxcld02,APPSVIP_FAILBACK="
##############################################################################################
[grid@lnxcld02 trace]$ crsctl stat res -t -------------------------------------------------------------------------------- NAME TARGET STATE SERVER STATE_DETAILS -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.DATA1.dg ONLINE ONLINE lnxcld01 ONLINE ONLINE lnxcld02 ora.FRA1.dg ONLINE ONLINE lnxcld01 ONLINE ONLINE lnxcld02 ora.LISTENER.lsnr ONLINE ONLINE lnxcld01 ONLINE ONLINE lnxcld02 ora.OCRVOTING.dg ONLINE ONLINE lnxcld01 ONLINE ONLINE lnxcld02 ora.asm ONLINE ONLINE lnxcld01 Started ONLINE ONLINE lnxcld02 Started ora.gsd OFFLINE OFFLINE lnxcld01 OFFLINE OFFLINE lnxcld02 ora.net1.network ONLINE ONLINE lnxcld01 ONLINE ONLINE lnxcld02 ora.ons ONLINE ONLINE lnxcld01 ONLINE ONLINE lnxcld02 ora.registry.acfs ONLINE ONLINE lnxcld01 ONLINE ONLINE lnxcld02 -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- myappvip 1 ONLINE ONLINE lnxcld02 ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE lnxcld02 ora.cvu 1 ONLINE ONLINE lnxcld02 ora.lnxcld01.vip 1 ONLINE ONLINE lnxcld01 ora.lnxcld02.vip 1 ONLINE ONLINE lnxcld02 ora.oc4j 1 ONLINE ONLINE lnxcld02 ora.scan1.vip 1 ONLINE ONLINE lnxcld02 ora.tpolicy.db 1 ONLINE ONLINE lnxcld01 Open 2 ONLINE ONLINE lnxcld02 Open ora.tpolicy.loadbalance_rw.svc 1 ONLINE ONLINE lnxcld01 2 ONLINE ONLINE lnxcld02
##############################################################################################
[grid@lnxcld02 ~]$ crsctl stat res myappvip -p NAME=myappvip TYPE=app.appvip_net1.type ACL=owner:root:rwx,pgrp:root:r-x,other::r--,group:oinstall:r-x,user:grid:r-x ACTION_FAILURE_TEMPLATE= ACTION_SCRIPT= ACTIVE_PLACEMENT=1 AGENT_FILENAME=%CRS_HOME%/bin/orarootagent%CRS_EXE_SUFFIX% APPSVIP_FAILBACK=0 AUTO_START=restore CARDINALITY=1 CHECK_INTERVAL=1 CHECK_TIMEOUT=30 DEFAULT_TEMPLATE=PROPERTY(RESOURCE_CLASS=vip) DEGREE=1 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=lnxcld02 LOAD=1 LOGGING_LEVEL=1 NLS_LANG= NOT_RESTARTING_TEMPLATE= OFFLINE_CHECK_INTERVAL=0 PLACEMENT=balanced PROFILE_CHANGE_TEMPLATE= RESTART_ATTEMPTS=0 SCRIPT_TIMEOUT=60 SERVER_POOLS=* START_DEPENDENCIES=hard(ora.net1.network) pullup(ora.net1.network) START_TIMEOUT=0 STATE_CHANGE_TEMPLATE= STOP_DEPENDENCIES=hard(ora.net1.network) STOP_TIMEOUT=0 TYPE_VERSION=2.1 UPTIME_THRESHOLD=7d USR_ORA_ENV= USR_ORA_VIP=192.168.2.200 VERSION=11.2.0.3.0
My Oracle Notes 