Trying to start the RAC database after cloning from other RAC database and getting the error below:
After that error I have noticed that the database is running on n01 but not on n02
That gave me a idea that some how there is an issue with the cluster_database parameter
but when I had a look at the init file which was used to create the spfile it says cluster_database=TRUE
That is interesting, it looks like the correct spfile is not in use. But looking at the $ORACLE_HOME/dbs directory it looks like I forgot to move the spfile from the directory after the restore and recovery
Solution:
I have moved the spfile away from that folder and tried starting the database and it worked
[oracle@ract01n01 (qa2tesp1) dbs]$ srvctl start database -d qa2tesp
PRCR-1079 : Failed to start resource ora.qa2tesp.db
CRS-5017: The resource action "ora.qa2tesp.db start" encountered the following error:
ORA-01102: cannot mount database in EXCLUSIVE mode
. For details refer to "(:CLSN00107:)" in "/u01/app/grid/diag/crs/ract01n02/crs/trace/crsd_oraagent_oracle.trc".
CRS-2674: Start of 'ora.qa2tesp.db' on 'ract01n02' failed
CRS-2632: There are no more servers to try to place resource 'ora.qa2tesp.db' on that would satisfy its placement policy
[oracle@ract01n01 (qa2tesp1) dbs]$
After that error I have noticed that the database is running on n01 but not on n02
oracle@ract01n01 (qa2tesp1) dbs]$ srvctl status database -d qa2tesp
Instance qa2tesp1 is running on node ract01n01
Instance qa2tesp2 is not running on node ract01n02
[oracle@ract01n01 (qa2tesp1) dbs]$
That gave me a idea that some how there is an issue with the cluster_database parameter
SQL> show parameter cluster_dat
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cluster_database boolean FALSE
cluster_database_instances integer 1
SQL>
but when I had a look at the init file which was used to create the spfile it says cluster_database=TRUE
That is interesting, it looks like the correct spfile is not in use. But looking at the $ORACLE_HOME/dbs directory it looks like I forgot to move the spfile from the directory after the restore and recovery
[oracle@ract01n01 (qa2tesp1) dbs]$ ls -lah *qa2tes*
-rw-r--r-- 1 oracle oinstall 63 Nov 21 09:40 initqa2tesp1.ora
-rw-r----- 1 oracle oinstall 2.5K Nov 17 14:31 orapwqa2tesp1
-rw-r----- 1 oracle asmadmin 14K Nov 21 09:40 spfileqa2tesp1.ora
[oracle@ract01n01 (qa2tesp1) dbs]$
Solution:
I have moved the spfile away from that folder and tried starting the database and it worked
[oracle@ract01n01 (qa2tesp1) dbs]$ mv spfileqa2tesp1.ora ./backup/
[oracle@ract01n01 (qa2tesp1) dbs]$
[oracle@ract01n01 (qa2tesp1) dbs]$ srvctl start database -d qa2tesp
[oracle@ract01n01 (qa2tesp1) dbs]$
1 comment:
Same here. I too forgot to move spfile create in $HOME/dbs & by default my database was using spfile from dbs insted of ASM DATA diskgroup.
Got below error:
[oracle@ORA-RAC-3 ~]$ srvctl start database -d QAREL
PRCR-1079 : Failed to start resource ora.qarel.db
CRS-2674: Start of 'ora.LISTENER.lsnr' on 'ora-rac-3' failed
CRS-5017: The resource action "ora.qarel.db start" encountered the following error:
ORA-00205: error in identifying control file, check alert log for more info
. For details refer to "(:CLSN00107:)" in "/u01/app/oracle/diag/crs/ora-rac-3/crs/trace/crsd_oraagent_oracle.trc".
CRS-2674: Start of 'ora.qarel.db' on 'ora-rac-3' failed
CRS-2632: There are no more servers to try to place resource 'ora.qarel.db' on that would satisfy its placement policy
[oracle@ORA-RAC-3 ~]$ su
Moved dbs SPFILE to other location & post started database in mount. It worked..!!
Post a Comment