CRS: Resource in UNKNOWN state and srvctl Cannot Start/Stop the Resource (Doc ID 845709.1)

In this Document

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 11.1.0.7 [Release 10.2 to 11.1]
Information in this document applies to any platform.

Goal

A resource status is showing as UNKNOWN in crs_stat -t output :

When the resource state is UNKNOWN, srvctl cannot start or stop the resource.  It fails with the following errors:

After the failed srvctl command, the crsd.log will show an error:

Even running srvctl status on the resource can error:

These errors are all due to the resource state of UNKNOWN.

Solution

The UNKNOWN state can often be resolved by bringing the resource offline using crs_stop.

Any CRS resource can be in an UNKNOWN state, including vip, gsd, database, or instances.  The following uses an instance resource as an example.

1. Find the proper name for your instance resource.  To find it, do "crs_stat -u | grep inst", this will give the names of all instance resources in the OCR.

Pick the instance associated with the node and database in question.
For example, for a database named prod and instance named prod1, the resource name will be "ora.prod.prod1.inst".


2.  Before you go any further, make sure that you have a recent backup of your OCR.
You can check on your OCR automatic backups with the command "ocrconfig -showbackup":

If no backup exists, then create one using ocrconfig -export, following the instructions in the documentation:

Oracle??? Database Oracle Clusterware and Oracle Real Application Clusters Administration and Deployment Guide - 10g Release 2 (10.2)


3. Restore the instance resource to OFFLINE with this command:

crs_stop [instance resource name]

eg:

4. Check that instance status is now OFFLINE instead of UNKNOWN

5. If the instance status is OFFLINE, then you can try again to start it with srvctl.

6. If the startup fails again, then open a SR and provide Oracle Support with the following information:

a) Gather a trace by using the following script:

(Replace "ora.prod.prod1.inst" with the name of your actual instance resource; replace prod with the name of your database and prod1 with the name of your instance).

The trace log will be found in /tmp/trace1.out.

b) latest crsd.log from this node

c) the resource log for this instance from $CRS_HOME/log/<>/racg

d) ls -l of $ORACLE_HOME/log/<>/racg

Community Discussions

Still have questions? Use the communities window below to search for similar discussions or start a new discussion on this subject.

Note: Window is the LIVE community not a screenshot.

Click here to open in main browser window

References NOTE:1469600.1 - CRS-2503: Resource 'ora.' is in UNKNOWN state and must be stopped first

Document Details   Type: Status: Last Major Update: Last Update: HOWTO PUBLISHED Jun 26, 2014 Jun 26, 2014 Currency Check Required. Current Out of Date   Related Products   Oracle Database - Enterprise Edition   Information Centers   No Information Center available for this document. Index of Oracle Database Information Centers [1568043.2] Information Center: Overview of Database Security Products [1548952.2] Information Center: Overview Database Server/Client Installation and Upgrade/Migration [1351022.2]   Document References   No References available for this document. CRS-2503: Resource 'ora.' is in UNKNOWN state and must be stopped first [1469600.1]   Recently Viewed

Related …

Products …

• Oracle Database Products > Oracle Database Suite > Oracle Database > Oracle Database - Enterprise Edition > Real Application Cluster > RAC Administrative Issues

Keywords …

CRS;INSTANCE STATUSES;OCR;REAL APPLICATION CLUSTERS;SRVCTL;START INSTANCE;STARTUP;STARTUP FAILS;STATUS

Errors …

CRS-0223;CRS-1028;CRS-223;PRKO-2015;PRKP-1001

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/17252115/viewspace-1372906/，如需轉載，請註明出處，否則將追究法律責任。