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"
Wednesday, March 29, 2006
Subscribe to:
Post Comments (Atom)
4 comments:
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?
when you use "srvctl" with database, it does all nodes.
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
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
Post a Comment