Wednesday, March 29, 2006

[PRKP-1001] After Change spfile on RAC , can't start database from srvctl

I changed initdb1.ora,initdb2.ora from
SPFILE='+ARC/db/spfiledb.ora'

to

SPFILE='+DATA/db/spfiledb.ora'

then delete '+ARC/db/spfiledb.ora' file

and
I started database by srvctl

$ srvctl start database -d db
PRKP-1001 : Error starting instance db1 on node db1
CRS-0215: Could not start resource 'ora.db.db1.inst'.
PRKP-1001 : Error starting instance db2 on node db2
CRS-0215: Could not start resource 'ora.db.db2.inst'.

when checked from #evmwatch -A -t '@ timestamp@@'
"@ timestampCRS ora.db.db2.inst is transitioning from state OFFLINE to state ONLINE on member db2"
"@ timestampRAC: ora.db.db2.inst: down: "
"@ timestampRAC: ora.db.db2.inst: imstop: "
"@ timestampCRS ora.db.db2.inst had an error, and is no longer running"


but when i started by manual don't found any problems.
SQL> startup
Total System Global Area 1073741824 bytes
Fixed Size 2076616 bytes
Variable Size 264241208 bytes
Database Buffers 801112064 bytes
Redo Buffers 6311936 bytes
Database mounted.
Database opened.
SQL>

resolve problem by:

#srvctl stop database -d db
#srvctl modify database -d db -p '+DATA/db/spfiledb.ora' -s open
#srvctl start database -d db


#evmwatch -A -t '@ timestamp@@'

"@ timestampCRS ora.db.db2.inst is transitioning from state OFFLINE to state ONLINE on member db2"
"@ timestampCRS ora.db.db1.inst is transitioning from state OFFLINE to state ONLINE on member db1"
"@ timestampRAC: ora.db.db2.inst: up: "
"@ timestampRAC: ora.db.db2.inst: imstop: "
"@ timestampRAC: ora.db.db2.inst: imcheck: "
"@ timestampCRS ora.db.db2.inst started on member db2"
"@ timestampRAC: ora.db.db1.inst: up: "
"@ timestampRAC: ora.db.db1.inst: imstop: "
"@ timestampRAC: ora.db.db1.inst: imcheck: "
"@ timestampCRS ora.db.db1.inst started on member db1"


4 comments:

Joao said...

Tks for you help. You doc was very useful.

Just 1 question. We do this command only in one of the database nodes at it is applied to them all, correct?

HunterX said...

when you use "srvctl" with database, it does all nodes.

Anonymous said...

Thanks! This just helped me solve my problem!

Note to other readers: to see what SPFILE your RAC database is config'ed to use, try this command:

$ srvctl config database -d [dbname] -a

HunterX said...

I'm glad that can help you and thanks for your idea

$ srvctl config database -d db -a

db01 db1 /product/10.2.0/db

db02 db2 /product/10.2.0/db

DB_NAME: db

ORACLE_HOME: /product/10.2.0/db

SPFILE: +ASM_GROUP01/db/spfiledb.ora

DOMAIN: domain.com

DB_ROLE: null

START_OPTIONS: null

POLICY: AUTOMATIC

ENABLE FLAG: DB ENABLED