Home » Server Options » RAC & Failsafe » error creating db - ORA-12720: operation requires database is in EXCLUSIVE mode (10.2.0.2 OS:SuSE10)
error creating db - ORA-12720: operation requires database is in EXCLUSIVE mode [message #286452] Fri, 07 December 2007 08:08 Go to next message
orcl dba
Messages: 68
Registered: August 2005
Member
Hello,

I am trying to create a RAC database through scripts.
There are already other RAC databases running on the same nodes(we are using two clustered nodes) using ASM. I am trying to create a new database.
I get the following error when I run the scripts.

SQL> startup nomount pfile="/RACDEVdata/WISE/admin/pfile/initTEST.ora";
ORACLE instance started.

Total System Global Area 947912704 bytes
Fixed Size 2075656 bytes
Variable Size 402654200 bytes
Database Buffers 536870912 bytes
Redo Buffers 6311936 bytes
SQL> CREATE DATABASE "TEST"
2 MAXINSTANCES 32
3 MAXLOGHISTORY 1
4 MAXLOGFILES 192
5 MAXLOGMEMBERS 3
6 MAXDATAFILES 1024
7 DATAFILE SIZE 256M AUTOEXTEND ON NEXT 4M MAXSIZE UNLIMITED
8 EXTENT MANAGEMENT LOCAL
9 SYSAUX DATAFILE SIZE 128M AUTOEXTEND ON NEXT 4M MAXSIZE UNLIMITED
10 SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE SIZE 128M AUTOEXTEND ON NEXT 4M MAXSIZE UNLIMITED
11 SMALLFILE UNDO TABLESPACE "UNDOTBS1" DATAFILE SIZE 128M AUTOEXTEND ON NEXT 4M MAXSIZE UNLIMITED
12 CHARACTER SET AR8ISO8859P6
13 NATIONAL CHARACTER SET AL16UTF16
14 LOGFILE GROUP 1 SIZE 51200K,
15 GROUP 2 SIZE 51200K
16 USER SYS IDENTIFIED BY "&&sysPassword" USER SYSTEM IDENTIFIED BY "&&systemPassword";
CREATE DATABASE "TEST"
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-12720: operation requires database is in EXCLUSIVE mode

I have uploaded the init file for your reference.
Database version: 10.2.0.2
OS: SuSE Linux Enterprise Server 10 (SuSE10)
  • Attachment: initTEST.ora
    (Size: 2.71KB, Downloaded 326 times)
Re: error creating db - ORA-12720: operation requires database is in EXCLUSIVE mode [message #286453 is a reply to message #286452] Fri, 07 December 2007 08:15 Go to previous messageGo to next message
Michel Cadot
Messages: 58612
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
To create the database you must be in exclusice mode, remove/comment the cluster_database% parameters.

Regards
Michel
Re: error creating db - ORA-12720: operation requires database is in EXCLUSIVE mode [message #286478 is a reply to message #286453] Fri, 07 December 2007 10:08 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Also check the alert log file for any additional errors.
Re: error creating db - ORA-12720: operation requires database is in EXCLUSIVE mode [message #286497 is a reply to message #286453] Fri, 07 December 2007 11:01 Go to previous message
orcl dba
Messages: 68
Registered: August 2005
Member
Thanks for the reply. I have removed the parameters and created the database. Added those parameters later on after the database creation. Everything is fine.

Thanks
Previous Topic: Problems with package variables and RAC
Next Topic: RAC node service lost
Goto Forum:
  


Current Time: Tue Jul 29 20:27:44 CDT 2014

Total time taken to generate the page: 0.13412 seconds