OraFAQ Forum: RAC & Failsafe » error creating db - ORA-12720: operation requires database is in EXCLUSIVE mode

Home » Server Options » RAC & Failsafe » error creating db - ORA-12720: operation requires database is in EXCLUSIVE mode (10.2.0.2 OS:SuSE10)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

error creating db - ORA-12720: operation requires database is in EXCLUSIVE mode [message #286452]

Fri, 07 December 2007 08:08

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 2030 times)

Report message to a moderator

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

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

To create the database you must be in exclusice mode, remove/comment the cluster_database% parameters.

Regards
Michel

Report message to a moderator

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

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Also check the alert log file for any additional errors.

Report message to a moderator

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

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 05 00:48:15 CDT 2025