CREATE CONTROLFILE ................................. ................................................. CHARACTER SET AL32UTF8; ERROR at line 1: ORA-01503: CREATE CONTROLFILE failed ORA-12720: operation requires database is in EXCLUSIVE mode
Solution:
SQL> alter system set cluster_database=FALSE scope=spfile sid='*'; shutdown immdeiate; startup nomount;
re-run script for controlfile creation
CREATE CONTROLFILE ................................. ................................................. CHARACTER SET AL32UTF8; Control file created.
after that change parameter with its old value
SQL> alter system set cluster_database=TRUE scope=spfile sid='*';
and restart database.
No comments:
Post a Comment