This discussion is archived
6 Replies Latest reply: Mar 18, 2013 6:36 AM by User374733 RSS

How to add a resource to CRS

871977 Newbie
Currently Being Moderated
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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    Please help me !
  • 4. Re: How to add a resource to CRS
    912595 Expert
    Currently Being Moderated
    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
    988472 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    Check below link:

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points