6 Replies Latest reply: Mar 18, 2013 8:36 AM by User374733 RSS

    How to add a resource to CRS

    871977
      Hi all,

      [oracle@edrsr25p1 ~]$ srvctl stop database -d orcl
      PRCD-1120 : The resource for database orcl could not be found.
      PRCR-1001 : Resource ora.orcl.db does not exist
      [oracle@edrsr25p1 ~]$

      How can i add ora.orcl.db resource to my CRS!

      Please help

      Thank you!
        • 1. Re: How to add a resource to CRS
          912595
          Dan wrote:
          Hi all,

          [oracle@edrsr25p1 ~]$ srvctl stop database -d orcl
          PRCD-1120 : The resource for database orcl could not be found.
          PRCR-1001 : Resource ora.orcl.db does not exist
          [oracle@edrsr25p1 ~]$

          How can i add ora.orcl.db resource to my CRS!

          Please help

          Thank you!
          ora.orcl.db is the database resource. If you wish to add database resource to your cluster then through DBCA you can create new database.
          http://docs.oracle.com/cd/E11882_01/rac.112/e16795/srvctladmin.htm#i1008470
          http://docs.oracle.com/cd/E11882_01/rac.112/e16795/srvctladmin.htm#i1008526

          If you have already existing single node database and want to convert to rac cluster database then see
          http://docs.oracle.com/cd/E11882_01/install.112/e10813/cvrt2rac.htm

          hth
          • 2. Re: How to add a resource to CRS
            871977
            Thanks 909592


            My db is on single instance with grid infastructure installed

            Before i executed:
            crsctl status resource and found

            NAME=ora.orcl.db
            TYPE=ora.database.type
            TARGET=ONLINE
            STATE=ONLINE on edrsr37p1

            But i dont know why my orc.orcl.db was removed and now i execute: crsctl status resource and found


            TYPE=ora.database.type
            TARGET=ONLINE
            STATE=ONLINE on edrsr37p1

            My ora.orcl.db was lost! :( how can i add it to crs?
            • 3. Re: How to add a resource to CRS
              871977
              Please help me !
              • 4. Re: How to add a resource to CRS
                912595
                Is your single database is still running? Try to login through

                export ORACLE_HOME= your rdbms home
                sqlplus / as sysdba

                Also check the status throgh:
                srvctl config database -d <database name>

                You can add your database back to cluster resource through "srvctl add database..." syntax you already have
                • 5. Re: How to add a resource to CRS
                  quanvlm
                  Hi all,

                  After adding a new node to oracle rac, I have the same problem. I access to database use sqlplus successfully but database resource not found.
                  srvctl config database -d mydb
                  PRCD-1120 : The resource for database db could not be found.
                  PRCR-1001 : Resource ora.mydb.db does not exist

                  Please help me!
                  • 6. Re: How to add a resource to CRS
                    User374733
                    Check below link:

                    http://docs.oracle.com/cd/E11882_01/server.112/e25494/restart002.htm#BABHHABA