2 Replies Latest reply: May 13, 2014 4:13 AM by Vandana B -Oracle RSS

    Is an Oracle Instance a Cluster Resource

    Jimbo

      hi,

       

      I am trying to understand what is considered a cluster resource - the Oracle Instance, the Oracle Database or both ?

       

      When I use 'crsctl resource' the Oracle Instance does not appear to be a resource type

       

      To my understanding, a cluster resource is anything the cluster monitors and restarts in the event of a failure - yet when you think about it, it is the Oracle Instance that the cluster services monitors for on a given node and will try to restart in the event of a failure. So why does the Instance not appear as a Resource Type ?

       

      I have seen other definitions for 'Resource' which define it as any application that the cluster runs using several nodes.

       

      thanks,

      Jim

        • 1. Re: Is an Oracle Instance a Cluster Resource
          FreddieEssex

          Hi,

           

          Both the database and the instances are resources.

           

          When you create a database you first register the database with CRS and then all the instances (srvctl add database/instance).

           

          crsctl stat res -t shows the database as a resource along with it's associated instances.

           

          srvctl config database -d db_name shows the database as being registered and all the instances which are registered with the database.

          • 2. Re: Is an Oracle Instance a Cluster Resource
            Vandana B -Oracle

            Hi,

             

            From 11gR2 on wards, when new instances are added, they become a part of the db resource

             

            crsctl stat res ora.testdb.db -p

            NAME=ora.testdb.db

            TYPE=ora.database.type

             

            ...

             

            GEN_USR_ORA_INST_NAME=

            GEN_USR_ORA_INST_NAME@SERVERNAME(earth7cl1vm1)=testdb1

            GEN_USR_ORA_INST_NAME@SERVERNAME(earth7cl1vm2)=testdb2

             

            ...

             

            USR_ORA_INST_NAME@SERVERNAME(earth7cl1vm1)=testdb1

            USR_ORA_INST_NAME@SERVERNAME(earth7cl1vm2)=testdb2

             

            Prior to 11gR2, the db and instances were listed as separated resources as follows

             

            crs_stat ora.orcl.ORCL1.inst -p

            NAME=ora.orcl.ORCL1.inst

             

             

            ...

             

             

            DESCRIPTION=CRS application for Instance

             

             

             

            crs_stat ora.orcl.ORCL2.inst -p

            NAME=ora.orcl.ORCL2.inst

             

             

            ...

             

             

            DESCRIPTION=CRS application for Instance

             

             

             

             

             

            crs_stat ora.orcl.db -p

            NAME=ora.orcl.db

             

             

            ...

             

             

            DESCRIPTION=CRS application for the Database

             

            And all resources are monitored by CRS/GI

             

            Regards,

            Vandana - Oracle