#@#@#@!!!!!!

As technical consultant, I learn new stuff everyday. My goal here to collect those day-to-day findings and organized them for future reference.

#@#@#@!!!!!!

Saturday, March 10, 2007

Oracle CRS with Trunked public interface problem (+ workaround)

I've encountered a problem installing Oracle CRS on a server with trunked public 'ce' interfaces.

Hardware: v890
OS : Solaris 10 update 3
Oracle Version: 10.2.0.3
Trunking : 1.3

The 'vipca' script fails, and when you look at the logfile $CRS_HOME/log//racg/ora..vip.log it's packed full of usage messages from nettr (see extract from log below). Oracle has a bug logged with similar symptoms 5876195 but this is marked as not a bug and they have not published a workaround.

Looking at the script $CRS_HOME/bin/racgvip, it calls nettr -stats with incorrect options if you have a 'ce' interface.

line 305 # _O1=`$NETTR -stats ${_TRUNKHEAD} device=${_DEVICE} | $AWK '/'$_DEVICE'/ { _S += $2 } END { print _S }'`

If you alter this line to read

_O1=`$NETTR -stats ${_TRUNKHEAD} | $AWK '/'$_DEVICE'/ { _S += $2 } END { print _S }'`

Then re-run vipca manually, your vip will create successfully.

Hope this helps stop someone having the same headaches I did,

mel


------ Extract from log starts here

Oracle Database 10g CRS Release 10.2.0.1.0 Production Copyright 1996, 2005 Oracle. All rights reserved.
2007-03-08 13:48:30.063: [ RACG][1] [5638][1][ora.bombay.vip]: Usage: /etc/opt/SUNWconn/bin/nettr -setup device= members=
[ { device= members= }... ]
[ policy= ]
[ mac= ]
[ lacp= [ ptimer=<0|1> ] ]
/etc/opt/SUNWconn/bin/nettr
2007-03-08 13:48:30.070: [ RACG][1] [5638][1][ora.bombay.vip]: -setup device= members=
[ policy= ]

/etc/opt/SUNWconn/bin/nettr -stats
[ type=<1|2> ] [ interval= ]
/etc/opt/SUNWconn/bin/nettr -stats device=
[ type=<1|2> ] [ in
2007-03-08 13:48:30.070: [ RACG][1] [5638][1][ora.bombay.vip]: terval= ]

/etc/opt/SUNWconn/bin/nettr -release
/etc/opt/SUNWconn/bin/nettr -release device=

/etc/opt/SUNWconn/bin/nettr -add
device= members=
[ { device=dev2> members= }.
2007-03-08 13:48:30.070: [ RACG][1] [5638][1][ora.bombay.vip]: .. ]

/etc/opt/SUNWconn/bin/nettr -rem
device= members=
[ { device= members= }... ]

/etc/opt/SUNWconn/bin/nettr -mod
[ policy= ]
[ lacp= ] [ ptimer=<0|1> ]

/etc/opt/S