CRS-0223: Resource 'ora.xyz.xyz1.inst' has placement error.
cayenneMay 11 2009 — edited May 12 2009Hello all,
I'm trying to learn about clusters....I've got some RAC nodes I'm now in charge of...and one is having problems. I'm trying now to find out what to do...
Let's say my cluster is 'xyz', the instances is xyz1
I cannot get to the database, so started looking around.
When I tried:
srvctl status database -d xyz
PRKO-2015 : Error in checking condition of instance on node: server01
I next tried to just start things up:
srvctl start database -d xyz
PRKP-1001 : Error starting instance xyz1on node server01
CRS-1028: Dependency analysis failed because of:
CRS-0223: Resource 'ora.xyz.xyz1.inst' has placement error.
I'm looking around trying to resolve this...I'm not sure yet what a placement error is...and so far, status info isn't helping.
I'm trying to look at the CRS logs directory and figure out what logs to look for and then what is listed in those...
Any suggestions? Oh, when I do :
olsnodes -n
server01 1
server02 2
Now, something weird...server02 actually doesn't exist anymore...at least, there is NO oracle on that box, it was repuporsed way before I came on board....
This is really just a one node cluster.
From looking at logs like the crs alert one...it appears things all started up on Sat. the 9th...maybe there was a power failure or something...
Can someone give me some idea/pointers/links?
Thank you,
cayenne
PS: Found a command to give a little more information:
crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....P1.inst application ONLINE ONLINE server01
ora....PIBP.db application ONLINE ONLINE server01
ora....P1.inst application ONLINE UNKNOWN server01
ora....PIBP.db application ONLINE OFFLINE
ora....D1.inst application ONLINE ONLINE server01
ora.ISPGRID.db application ONLINE ONLINE server01
ora....SM1.asm application ONLINE ONLINE server01
ora....01.lsnr application ONLINE ONLINE server01
ora....a01.gsd application ONLINE ONLINE server01
ora....a01.ons application ONLINE ONLINE server01
ora....a01.vip application ONLINE ONLINE server01
ora....02.lsnr application ONLINE OFFLINE
ora....a02.gsd application ONLINE OFFLINE
ora....a02.ons application ONLINE OFFLINE
ora....a02.vip application ONLINE ONLINE server01
I thought I read somewhere that you should maybe use crs_stop -f to force a stop...and then restart with srvctl...not sure if to do this...or exactly what the command would be in my case.
Edited by: cayenne on May 11, 2009 10:45 AM