Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

cluster_database parameter not changed within database

446118Feb 25 2011 — edited Mar 1 2011
i am doing a database upgrade on a 2 node clustered database

When i run command start upgrade, i get the below errors in the alert log

*Errors in file /u01/app_home/oracle/admin/racdb/udump/racdb1_ora_26470.trc:
ORA-39701: database must be mounted EXCLUSIVE for UPGRADE or DOWNGRADE
Fri Feb 25 13:41:39 2011
Error 39701 happened during db open, shutting down database
USER: terminating instance due to error 39701
Fri Feb 25 13:41:39 2011
Errors in file /u01/app_home/oracle/admin/racdb/bdump/racdb1_lms0_26269.trc:
ORA-39701: database must be mounted EXCLUSIVE for UPGRADE or DOWNGRADE
Instance terminated by USER, pid = 26470
ORA-1092 signalled during: ALTER DATABASE OPEN MIGRATE...*

I have run the the coomand

SQL> alter system set cluster_database=FALSE scope=spfile;

System altered.

but when i re-run start startup upgrade, parameters setting for cluster_database is still set to true

compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
cluster_database = TRUE
cluster_database_instances= 2
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 29 2011
Added on Feb 25 2011
3 comments
5,412 views