RE: Additional VIP in RAC

From: Juergen Stegmair <jstegmair_at_enkitec.com>
Date: Tue, 18 Nov 2008 14:51:56 -0600 (CST)
Message-ID: <009101c949bf$81b27ff0$85177fd0$@com>

Did you create an application to protect with that new vip? What's the application status? What's crs_stat -t saying? Did you put the application onto all nodes? And I think your vip2-1 should be bound to eth0, rather than eth1? Unless you are using eth0 for your priv-vip instead of using it for public?

And can you stop/start the vip and the app?

-Juergen

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Stuart Blackburn
Sent: Tuesday, November 18, 2008 1:39 PM Cc: oracle-l_at_freelists.org
Subject: Additional VIP in RAC

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:51:56 CST