1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Oracle Cluster RAC

Discussion in 'Server Administration and Options' started by mzainal, Sep 10, 2009.

  1. mzainal

    mzainal Forum Advisor

    Messages:
    72
    Likes Received:
    0
    Trophy Points:
    130
    Hi,

    I having problem with my cluster. This cluster has been setup with other person that not working my company anymore and i take over his job.

    Basically i don't know about cluster. Just google and try it. After an hour try and my db not up, here i really need help.

    How to up those that 'OFFLINE'?

    Code (Text):
    [oracle@db01 ~]$ crs_stat -t
    Name           Type           Target    State     Host        
    ------------------------------------------------------------
    ora....SM1.asm application    ONLINE    ONLINE    db01        
    ora....01.lsnr application    ONLINE    ONLINE    db01        
    ora.db01.gsd   application    ONLINE    ONLINE    db01        
    ora.db01.ons   application    ONLINE    ONLINE    db01        
    ora.db01.vip   application    ONLINE    ONLINE    db01        
    ora....SM2.asm application    ONLINE    ONLINE    db02        
    ora....02.lsnr application    ONLINE    ONLINE    db02        
    ora.db02.gsd   application    ONLINE    ONLINE    db02        
    ora.db02.ons   application    ONLINE    ONLINE    db02        
    ora.db02.vip   application    ONLINE    ONLINE    db02        
    ora....NSRV.cs application    ONLINE    OFFLINE              
    ora....on1.srv application    ONLINE    OFFLINE              
    ora....on2.srv application    ONLINE    OFFLINE              
    ora.mission.db application    ONLINE    OFFLINE              
    ora....n1.inst application    ONLINE    OFFLINE              
    ora....n2.inst application    ONLINE    OFFLINE              
    [oracle@db01 ~]$
     
    Code (Text):
    [oracle@db01 ~]$ crs_stat -l
    NAME=ora.db01.ASM1.asm
    TYPE=application
    TARGET=ONLINE
    STATE=ONLINE on db01

    NAME=ora.db01.LISTENER_DB01.lsnr
    TYPE=application
    TARGET=ONLINE
    STATE=ONLINE on db01

    NAME=ora.db01.gsd
    TYPE=application
    TARGET=ONLINE
    STATE=ONLINE on db01

    NAME=ora.db01.ons
    TYPE=application
    TARGET=ONLINE
    STATE=ONLINE on db01

    NAME=ora.db01.vip
    TYPE=application
    TARGET=ONLINE
    STATE=ONLINE on db01

    NAME=ora.db02.ASM2.asm
    TYPE=application
    TARGET=ONLINE
    STATE=ONLINE on db02

    NAME=ora.db02.LISTENER_DB02.lsnr
    TYPE=application
    TARGET=ONLINE
    STATE=ONLINE on db02

    NAME=ora.db02.gsd
    TYPE=application
    TARGET=ONLINE
    STATE=ONLINE on db02

    NAME=ora.db02.ons
    TYPE=application
    TARGET=ONLINE
    STATE=ONLINE on db02

    NAME=ora.db02.vip
    TYPE=application
    TARGET=ONLINE
    STATE=ONLINE on db02

    NAME=ora.mission.MISSIONSRV.cs
    TYPE=application
    TARGET=ONLINE
    STATE=OFFLINE

    NAME=ora.mission.MISSIONSRV.mission1.srv
    TYPE=application
    TARGET=ONLINE
    STATE=OFFLINE

    NAME=ora.mission.MISSIONSRV.mission2.srv
    TYPE=application
    TARGET=ONLINE
    STATE=OFFLINE

    NAME=ora.mission.db
    TYPE=application
    TARGET=ONLINE
    STATE=OFFLINE

    NAME=ora.mission.mission1.inst
    TYPE=application
    TARGET=ONLINE
    STATE=OFFLINE

    NAME=ora.mission.mission2.inst
    TYPE=application
    TARGET=ONLINE
    STATE=OFFLINE

    [oracle@db01 ~]$
    Code (Text):
    [oracle@db01 admin]$ cat tnsnames.ora
    # tnsnames.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora
    # Generated by Oracle configuration tools.

    MISSION =
      (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(HOST = db01-vip.mohe.gov.my)(PORT = 1521))
        (ADDRESS = (PROTOCOL = TCP)(HOST = db02-vip.mohe.gov.my)(PORT = 1521))
        (LOAD_BALANCE = yes)
        (CONNECT_DATA =
          (SERVER = DEDICATED)
          (SERVICE_NAME = mission)
        )
      )

    MISSIONSRV =
      (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(HOST = db01-vip.mohe.gov.my)(PORT = 1521))
        (ADDRESS = (PROTOCOL = TCP)(HOST = db02-vip.mohe.gov.my)(PORT = 1521))
        (LOAD_BALANCE = yes)
        (CONNECT_DATA =
          (SERVER = DEDICATED)
          (SERVICE_NAME = MISSIONSRV)
          (FAILOVER_MODE =
            (TYPE = SELECT)
            (METHOD = BASIC)
            (RETRIES = 180)
            (DELAY = 5)
          )
        )
      )

    LISTENERS_MISSION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = db01-vip.mohe.gov.my)(PORT = 1521))
        (ADDRESS = (PROTOCOL = TCP)(HOST = db02-vip.mohe.gov.my)(PORT = 1521))
      )

    MISSION2 =
      (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(HOST = db02-vip.mohe.gov.my)(PORT = 1521))
        (CONNECT_DATA =
          (SERVER = DEDICATED)
          (SERVICE_NAME = mission)
          (INSTANCE_NAME = mission2)
        )
      )

    MISSION1 =
      (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(HOST = db01-vip.mohe.gov.my)(PORT = 1521))
        (CONNECT_DATA =
          (SERVER = DEDICATED)
          (SERVICE_NAME = mission)
          (INSTANCE_NAME = mission1)
        )
      )

    [oracle@db01 admin]$
    Please assist me.
     
  2. UnixGuru

    UnixGuru Active Member

    Messages:
    28
    Likes Received:
    1
    Trophy Points:
    90
    Hi

    You need to use the following command to start the instance on the specified node.

    srvctl start nodeapps -n (node)

    This will bring up the gsd, ons, listener, and vip. The same command can shut down the nodeapps by replacing start with stop.

    Take a look here for some examples
     
  3. mzainal

    mzainal Forum Advisor

    Messages:
    72
    Likes Received:
    0
    Trophy Points:
    130
    After search in google, i try this command.

    Code (Text):
    [oracle@db01 ~]$ crs_start -all
    Attempting to start `ora.db01.ASM1.asm` on member `db01`
    Attempting to start `ora.db01.vip` on member `db01`
    Attempting to start `ora.db02.ASM2.asm` on member `db02`
    Attempting to start `ora.db02.vip` on member `db02`
    Start of `ora.db01.vip` on member `db01` succeeded.
    Attempting to start `ora.db01.LISTENER_DB01.lsnr` on member `db01`
    Start of `ora.db02.vip` on member `db02` succeeded.
    Attempting to start `ora.db02.LISTENER_DB02.lsnr` on member `db02`
    Start of `ora.db01.LISTENER_DB01.lsnr` on member `db01` succeeded.
    Start of `ora.db02.LISTENER_DB02.lsnr` on member `db02` succeeded.
    Start of `ora.db01.ASM1.asm` on member `db01` succeeded.
    Attempting to start `ora.mission.mission1.inst` on member `db01`
    Start of `ora.db02.ASM2.asm` on member `db02` succeeded.
    Attempting to start `ora.mission.mission2.inst` on member `db02`
    Start of `ora.mission.mission1.inst` on member `db01` failed.
    db02 : CRS-1018: Resource ora.db01.ASM1.asm (application) is already running on db01

    Start of `ora.mission.mission2.inst` on member `db02` failed.
    db01 : CRS-1018: Resource ora.db02.ASM2.asm (application) is already running on db02

    CRS-1002: Resource 'ora.db01.ons' is already running on member 'db01'

    Attempting to start `ora.db01.gsd` on member `db01`
    CRS-1002: Resource 'ora.db02.ons' is already running on member 'db02'

    Attempting to start `ora.mission.db` on member `db01`
    Attempting to start `ora.mission.MISSIONSRV.cs` on member `db02`
    Attempting to start `ora.mission.MISSIONSRV.mission1.srv` on member `db01`
    Attempting to start `ora.mission.MISSIONSRV.mission2.srv` on member `db02`
    Attempting to start `ora.db02.gsd` on member `db02`
    Start of `ora.db01.gsd` on member `db01` succeeded.
    Start of `ora.db02.gsd` on member `db02` succeeded.
    Start of `ora.mission.db` on member `db01` failed.
    Attempting to start `ora.mission.db` on member `db02`
    Start of `ora.mission.MISSIONSRV.cs` on member `db02` failed.
    Attempting to start `ora.mission.MISSIONSRV.cs` on member `db01`
    Start of `ora.mission.MISSIONSRV.mission2.srv` on member `db02` failed.
    db01 : CRS-1019: Resource ora.mission.MISSIONSRV.mission2.srv (application) cannot run on db01

    Start of `ora.mission.MISSIONSRV.mission1.srv` on member `db01` failed.
    db02 : CRS-1019: Resource ora.mission.MISSIONSRV.mission1.srv (application) cannot run on db02

    Start of `ora.mission.MISSIONSRV.cs` on member `db01` failed.
    CRS-1006: No more members to consider

    Start of `ora.mission.db` on member `db02` failed.
    CRS-1006: No more members to consider

    CRS-0223: Resource 'ora.db01.ons' has placement error.

    CRS-0223: Resource 'ora.db02.ons' has placement error.

    CRS-0215: Could not start resource 'ora.mission.MISSIONSRV.cs'.

    CRS-0215: Could not start resource 'ora.mission.MISSIONSRV.mission1.srv'.

    CRS-0215: Could not start resource 'ora.mission.MISSIONSRV.mission2.srv'.

    CRS-0215: Could not start resource 'ora.mission.db'.

    CRS-0215: Could not start resource 'ora.mission.mission1.inst'.

    CRS-0215: Could not start resource 'ora.mission.mission2.inst'.

    [oracle@db01 ~]$
     
     
  4. UnixGuru

    UnixGuru Active Member

    Messages:
    28
    Likes Received:
    1
    Trophy Points:
    90
    You are getting the CRS-0223 error

    The Oracle error manual states:

    Oracle Error : CRS-0223: Resource '%s' has placement error.
    Cause: There was no host available on which to failover/start the resource based on the Placement Policy for the resource.
    Action: Check the target host for the resource and restart the resource using the crs_start command.

    So basically don't attempt to start all together .
     
  5. mzainal

    mzainal Forum Advisor

    Messages:
    72
    Likes Received:
    0
    Trophy Points:
    130
    How to start this service:
    Code (Text):
    NAME=ora.mission.MISSIONSRV.cs
    TYPE=application
    TARGET=ONLINE
    STATE=OFFLINE

    NAME=ora.mission.MISSIONSRV.mission1.srv
    TYPE=application
    TARGET=ONLINE
    STATE=OFFLINE

    NAME=ora.mission.MISSIONSRV.mission2.srv
    TYPE=application
    TARGET=ONLINE
    STATE=OFFLINE

    NAME=ora.mission.db
    TYPE=application
    TARGET=ONLINE
    STATE=OFFLINE

    NAME=ora.mission.mission1.inst
    TYPE=application
    TARGET=ONLINE
    STATE=OFFLINE

    NAME=ora.mission.mission2.inst
    TYPE=application
    TARGET=ONLINE
    STATE=OFFLINE
     
  6. niahoo

    niahoo Guest

    start database then start service
    srvctl start database -d mission
    srvctl start service -d mission -s missionsrv
     
  7. phani510

    phani510 Guest

    hi ,
    i 2 facing the same problems i tried all the above tip . still my database is not up!!!!!!!!!!!!!! what to do? please help me out.



    srvctl start database -d pdb

    these are the error
    prkp-1001:error starting instance pdb02 on node rac2
    crs-0215:could not start resource ora.pdb.pdb02 .inst
    prkp-1001:error starting instance pdb01 on node rac1
    crs-0215:could not start resource ora.pdb.pdb01 .inst

    remaining all service are up ons,gsd ,vip lsnrs are up on both nodes.
    please help me out ... waiting for you replay

    thanks and regards in advace...