Pages

Friday, June 29, 2012

CRS-0223: Resource 'ResourceName' has placement error

I noticed some services were started and some other weren't.  When I tried to start up the services, the 'placement' error showed up.

[oracle@pclone bin]$ ./srvctl start instance -d amct -i amct1
PRKP-1001 : Error starting instance amct1 on node pclone
CRS-1028: Dependency analysis failed because of:
CRS-0223: Resource 'ora.amct.amct1.inst' has placement error.

[oracle@pclone bin]$ ./crs_stat -t
Name           Type           Target    State     Host       
------------------------------------------------------------
ora....t1.inst application    ONLINE    UNKNOWN   pclone     
ora.amct.db    application    OFFLINE   OFFLINE              
ora....SM1.asm application    ONLINE    ONLINE    pclone     
ora.pclone.gsd application    ONLINE    ONLINE    pclone     
ora.pclone.ons application    ONLINE    ONLINE    pclone     
ora.pclone.vip application    ONLINE    ONLINE    pclone


I restarted  the CRS manually but still did not have any luck.
change user to root and then stop CRS.  remove temporary files and then restart the CRS.

[oracle@pclone bin]$ su -
[root@pclone bin]# ./crsctl stop crs
Stopping resources.
Successfully stopped CRS resources
Stopping CSSD.
Shutting down CSS daemon.
Shutdown request successfully issued.

rm -f /var/tmp/.oracle/*
./crsctl start crs
Attempting to start CRS stack
The CRS stack will be started shortly


Wait until CRS gets started.
[root@pclone bin]# ./crs_stat -t
Name           Type           Target    State     Host       
------------------------------------------------------------
ora....t1.inst application    ONLINE    OFFLINE              
ora.amct.db    application    OFFLINE   OFFLINE              
ora....SM1.asm application    ONLINE    OFFLINE              
ora.pclone.gsd application    ONLINE    OFFLINE              
ora.pclone.ons application    ONLINE    OFFLINE              
ora.pclone.vip application    ONLINE    OFFLINE              
Still No Luck ~~~.

So Let's find out OCR Configuration.

[oracle@pclone bin]$ ./srvctl config database -d amct -a
pclone amct1 /u01/oracle/amctdb/10.2.0/db_1
DB_NAME: null
ORACLE_HOME: /u01/oracle/amctdb/10.2.0/db_1
SPFILE: null
DOMAIN: null
DB_ROLE: null
START_OPTIONS: null
POLICY:  AUTOMATIC
ENABLE FLAG: DB ENABLED

As per the output of OCR Configuration "DB_NAME" and "SPFILE" are null and this seems to be the reason the instance was not coming up using srvctl start instance command.


srvctl modify database syntax

The srvctl modify database command is used to modify a database configurations in the  OCR (Oracle cluster registry).
The OCR is the repository used by the CRS (cluster readu services) processes to run a database in RAC environment.

Syntax:
srvctl modify database -d db_unique_name [-n db_name] [-o oracle_home] [-m domain_name]
  [-p spfile] [-r {PRIMARY | PHYSICAL_STANDBY | LOGICAL_STANDBY}] [-s start_options] [-y {AUTOMATIC | MANUAL}]

-d database name (unique name)
-n db_name: database name if different from unique name
-o oracle_home:Oracle home
-m domain_name: Domain name of the database
-p spfile: server parameter file
-r role [PRIMARY | PHYSICAL_STANDBY | LOGICAL_STANDBY]: Role of the database
-s start_options:Startup options for the database.
-y Management policy for the database, either automatic or manual.
-h




./srvctl modify database -d amct -p '/u01/oracle/amctdb/10.2.0/db_1/dbs/spfileamct1.ora' -n amct -s open
[oracle@pclone bin]$ ./srvctl config database -d amct -a
pclone amct1 /u01/oracle/amctdb/10.2.0/db_1
DB_NAME: amct
ORACLE_HOME: /u01/oracle/amctdb/10.2.0/db_1
SPFILE: /u01/oracle/amctdb/10.2.0/db_1/dbs/spfileamct1.ora
DOMAIN: null
DB_ROLE: null
START_OPTIONS: open
POLICY:  AUTOMATIC
ENABLE FLAG: DB ENABLED

Once configuration is modified this seems to fix the issue.

No comments:

Post a Comment