Results 1 to 3 of 3

Thread: RAC problem -- PRKP-1001 and CRS-0212

  1. #1
    Join Date
    Mar 2011
    Posts
    3

    RAC problem -- PRKP-1001 and CRS-0212

    I am new to Oracle and I inherited to clustered windows DB servers. This is Oracle 10g with RAC on Windows 2k3 x64

    I have no idea what happened to break it, came in in the morning to complains the DB wasn't working.

    When I do a crs_stat -t I see that several of the DBs are offline. When I try to start them I get CRS-0223 resource placement error. No amount of restarting or rebooting corrects this.
    If I try to bring up the database via the EMC I get PRKP-1001 and CRS-0212 and it says resources are unregistered.

    I don't know what to do at this point. Any help would be appreciated.

  2. #2
    Join Date
    Mar 2011
    Posts
    3

    Fixed

    Symptoms - database offline, start fails with errors CRS-0212 resource <resource name> is not registerd
    Attempts to start from EMC result in PRKP-1001 and CRS-0212 errors together

    Cause - database has been unregistered from the RAC cluster

    Actions required -

    1 - remove the unregistered database from the cluster configuration
    D:\...\crs\BIN> srvctl remove database -d <database name>
    Remove the database devdb? (y/[n]) y

    2 - add the database back into the cluster configration using the following steps
    D:\...\crs\BIN> srvctl add database -d <database name> -o %ORACLE_HOME%

    D:\...\crs\BIN> srvctl add instance -d <database name> -i <database instance> -n <host>

    D:\...\crs\BIN> srvctl add instance -d <database name> -i <database instance> -n <host>

    D:\...\crs\BIN> srvctl add service -d <database name> -s <service name> -r <host>,<host> -P BASIC

  3. #3
    Join Date
    Mar 2011
    Posts
    3

    correction

    Symptoms - database offline, start fails with errors CRS-0212 resource <resource name> is not registerd
    Attempts to start from EMC result in PRKP-1001 and CRS-0212 errors together

    Cause - database has been unregistered from the RAC cluster

    note: do this from within the DB's environment

    Actions required -

    1 - shutdown the database, stop each instance

    <database> (ex: navytap)
    sqlplus / as sysdba
    shutdown immediate;

    2 - remove the unregistered database from the cluster configuration
    D:\...\crs\BIN> srvctl remove database -d <database name>
    Remove the database devdb? (y/[n]) y

    3 - add the database back into the cluster configration using the following steps
    D:\...\crs\BIN> srvctl add database -d <database name> -o %ORACLE_HOME%

    D:\...\crs\BIN> srvctl add instance -d <database name> -i <database instance> -n <host>

    D:\...\crs\BIN> srvctl add instance -d <database name> -i <database instance> -n <host>

    D:\...\crs\BIN> srvctl add service -d <database name> -s <service name> -r <instance>,<instance> -P BASIC

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •