Re: Additional VIP in RAC

From: LS Cheng <exriscer_at_gmail.com>
Date: Tue, 18 Nov 2008 21:19:47 +0100
Message-ID: <6e9345580811181219n61be57e3l46b038b6d0f79929@mail.gmail.com>


You can check

  1. $CRS_HOME/log/$HOSTNAME/racg/*vip* logfiles
  2. Enable VIP debug by modifying _USR_ORA_DEBUG to 1 in $CRS_HOME/bin/racgvip

Regards

--
LSC

On Tue, Nov 18, 2008 at 8:38 PM, Stuart Blackburn <sblackbu_at_cbnco.com>wrote:


> Does anyone have any experience creating extra VIP's for applications using
> RAC? I've created some extra VIP's by following the instructions in this
> link:
>
>
> http://download-uk.oracle.com/docs/cd/B19306_01/rac.102/b14197/crschp.htm#sthref1042
>
>
> When I reboot the nodes my VIP's come back up without any problems. The
> just seem to be very flaky and will not restart on command for some reason.
> Here is the crs_stat output for my new VIP:
>
>
> NAME=vip2-1
> TYPE=application
> ACTION_SCRIPT=/apps/oracle/product/10.2/crs/bin/usrvip
> ACTIVE_PLACEMENT=1
> AUTO_START=restore
> CHECK_INTERVAL=60
> DESCRIPTION=vip2-1
> FAILOVER_DELAY=0
> FAILURE_INTERVAL=0
> FAILURE_THRESHOLD=0
> HOSTING_MEMBERS=lepfrdb01
> OPTIONAL_RESOURCES=
> PLACEMENT=favored
> REQUIRED_RESOURCES=
> RESTART_ATTEMPTS=0
> SCRIPT_TIMEOUT=60
> START_TIMEOUT=0
> STOP_TIMEOUT=0
> UPTIME_THRESHOLD=7d
> USR_ORA_ALERT_NAME=
> USR_ORA_CHECK_TIMEOUT=0
> USR_ORA_CONNECT_STR=/ as sysdba
> USR_ORA_DEBUG=0
> USR_ORA_DISCONNECT=false
> USR_ORA_FLAGS=
> USR_ORA_IF=eth1
> USR_ORA_INST_NOT_SHUTDOWN=
> USR_ORA_LANG=
> USR_ORA_NETMASK=255.255.255.0
> USR_ORA_OPEN_MODE=
> USR_ORA_OPI=false
> USR_ORA_PFILE=
> USR_ORA_PRECONNECT=none
> USR_ORA_SRV=
> USR_ORA_START_TIMEOUT=0
> USR_ORA_STOP_MODE=immediate
> USR_ORA_STOP_TIMEOUT=0
> USR_ORA_VIP=10.0.1.27
>
>
>
>
> When I manually run crs_stop's and crs_start's of my VIP, it attempts on
> all 3 nodes and usually fails. I say "usually" because the odd time it will
> work. The logs aren't very helpful either because they just list the
> following info:
>
>
> 2008-11-18 14:18:11.810: [ CRSRES][1407371584]0Attempting to start
> `vip2-1` on member `lepfrdb01`
> 2008-11-18 14:18:20.925: [ CRSRES][1407371584]0Start of `vip2-1` on member
> `lepfrdb01` failed.
> 2008-11-18 14:18:20.935: [ CRSRES][1407371584]0startRunnable: setting CLI
> values
> 2008-11-18 14:18:20.937: [ CRSRES][1407371584]0Attempting to start
> `vip2-1` on member `lepfrdb02`
> 2008-11-18 14:18:29.999: [ CRSAPP][1407371584]0StartResource error for
> vip2-1 error code = 1
> 2008-11-18 14:18:33.050: [ CRSRES][1407371584]0Start of `vip2-1` on member
> `lepfrdb02` failed.
> 2008-11-18 14:18:33.064: [ CRSRES][1407371584]0Attempting to start
> `vip2-1` on member `lepfrdb03`
> 2008-11-18 14:18:42.177: [ CRSRES][1407371584]0Start of `vip2-1` on member
> `lepfrdb03` failed.
> 2008-11-18 14:18:42.183: [ CRSRES][1407371584]0CRS-1006: No more members
> to consider
>
>
> Any help would be appreciated. Thanks.
>
> Stuart
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- http://www.freelists.org/webpage/oracle-l
Received on Tue Nov 18 2008 - 14:19:47 CST

Original text of this message