error creating db - ORA-12720: operation requires database is in EXCLUSIVE mode [message #286452] |
Fri, 07 December 2007 08:08 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 1935 times)
|
|
|
|
|
|