Friday, July 20, 2012

root.sh finished with VIP, Scan failed in first node during oracle 11g RAC installation


Environment:
--------------------
Database : Oracle 11gR2 (64i bit )
OS: RHEL 5.7 (64 bit)

Problem
-------------

                   root.sh completed successfully in node 1 with VIP and listener  status failed. I can't ping node 1 vip and scan IP. Node 2 root.sh finished successfully. So unable to proceed database installation . Details log as belows,

root.sh log in 1st node of RAC.
------------------------------------------------------------------------------------------------------
add nodeapps -n roots-db01 -A roots-db01-vip/255.255.255.224/eth0 on node=roots-db01 ... failed
CRS-2672: Attempting to start 'ora.asm' on 'roots-db01'
CRS-2676: Start of 'ora.asm' on 'roots-db01' succeeded
CRS-2672: Attempting to start 'ora.CRSDATA.dg' on 'roots-db01'
CRS-2676: Start of 'ora.CRSDATA.dg' on 'roots-db01' succeeded
PRCR-1001 : Resource ora.net1.network does not exist
add scan=roots-scan ... failed
Preparing packages for installation...
cvuqdisk-1.0.7-1
Configure Oracle Grid Infrastructure for a Cluster ... failed
Updating inventory properties for clusterware
Starting Oracle Universal Installer...

Checking swap space: must be greater than 500 MB.   Actual 33823 MB    Passed
The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /u01/app/oraInventory
'UpdateNodeList' was successful.
---------------------------------------------------------------------------------------------------------

[grid@roots-db01 bin]$ crs_stat -t -v
Name           Type           R/RA   F/FT   Target    State     Host
----------------------------------------------------------------------
ora.CRSDATA.dg ora....up.type 0/5    0/     ONLINE    ONLINE    roots-db01
ora....ER.lsnr ora....er.type 0/5    0/     ONLINE    ONLINE    roots-db02
ora.asm        ora.asm.type   0/5    0/     ONLINE    ONLINE    roots-db01
ora.eons       ora.eons.type  0/3    0/     ONLINE    ONLINE    roots-db02
ora.gsd        ora.gsd.type   0/5    0/     OFFLINE   OFFLINE
ora....network ora....rk.type 0/5    0/     ONLINE    ONLINE    roots-db02
ora.ons        ora.ons.type   0/3    0/     ONLINE    ONLINE    roots-db02
ora....ry.acfs ora....fs.type 0/5    0/     ONLINE    ONLINE    roots-db02
ora....SM1.asm application    0/5    0/0    ONLINE    ONLINE    roots-db01
ora....01.lsnr application    0/5    0/0    OFFLINE   OFFLINE
ora....b01.gsd application    0/5    0/0    OFFLINE   OFFLINE
ora....b01.ons application    0/3    0/0    OFFLINE   OFFLINE
ora....SM2.asm application    0/5    0/0    ONLINE    ONLINE    roots-db02
ora....02.lsnr application    0/5    0/0    ONLINE    ONLINE    roots-db02
ora....b02.gsd application    0/5    0/0    OFFLINE   OFFLINE
ora....b02.ons application    0/3    0/0    ONLINE    ONLINE    roots-db02
ora....b02.vip ora....t1.type 0/0    0/0    ONLINE    ONLINE    roots-db02

[grid@roots-db02 ~]$ crs_stat -t -v
Name           Type           R/RA   F/FT   Target    State     Host
----------------------------------------------------------------------
ora.CRSDATA.dg ora....up.type 0/5    0/     ONLINE    ONLINE    roots-db01
ora....ER.lsnr ora....er.type 0/5    0/     ONLINE    ONLINE    roots-db02
ora.asm        ora.asm.type   0/5    0/     ONLINE    ONLINE    roots-db01
ora.eons       ora.eons.type  0/3    0/     ONLINE    ONLINE    roots-db02
ora.gsd        ora.gsd.type   0/5    0/     OFFLINE   OFFLINE
ora....network ora....rk.type 0/5    0/     ONLINE    ONLINE    roots-db02
ora.ons        ora.ons.type   0/3    0/     ONLINE    ONLINE    roots-db02
ora....ry.acfs ora....fs.type 0/5    0/     ONLINE    ONLINE    roots-db02
ora....SM1.asm application    0/5    0/0    ONLINE    ONLINE    roots-db01
ora....01.lsnr application    0/5    0/0    OFFLINE   OFFLINE
ora....b01.gsd application    0/5    0/0    OFFLINE   OFFLINE
ora....b01.ons application    0/3    0/0    OFFLINE   OFFLINE
ora....SM2.asm application    0/5    0/0    ONLINE    ONLINE    roots-db02
ora....02.lsnr application    0/5    0/0    ONLINE    ONLINE    roots-db02
ora....b02.gsd application    0/5    0/0    OFFLINE   OFFLINE
ora....b02.ons application    0/3    0/0    ONLINE    ONLINE    roots-db02
ora....b02.vip ora....t1.type 0/0    0/0    ONLINE    ONLINE    roots-db02
-----------------------------------------------------------------------------------------------------------

Solution
-------------

Since only node 1 was not configured, this is what i did to resolve the issue:
Please do this as root

On node1
========
srvctl add vip -n roots-db01 -A 10.33.40.5/255.255.255.224/eth0 -k 1

srvctl add scan -n roots-scan 

srvctl add scan_listener
srvctl start vip -n roots-db01 
srvctl start scan
srvctl start scan_listener

The issue resolved for me.

Success..

Thanks,
Kaziul Islam Bulbul
Dhaka, Bangladesh

1 comment:

  1. Top 100 Best Casino Restaurants in Las Vegas | MapYRO
    Top 10 best casino restaurants 강릉 출장샵 in 고양 출장샵 Las Vegas. Restaurants: Harrah's 거제 출장안마 Palace, SLS, 파주 출장마사지 Cipriani & 포천 출장마사지 Sushi.

    ReplyDelete