Error while creating database
394386Oct 4 2006 — edited Oct 4 2006Hi I am etting the following error during creating database. Any suggestions, please?
C:\>
C:\>sqlplus /nolog
SQL*Plus: Release 10.1.0.5.0 - Production on Wed Oct 4 16:28:00 2006
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> @c:\oracle\admin\TEST\scripts\CreateDB.sql
Connected.
SQL> spool c:\oracle\ora92\assistants\dbca\logs\CreateDB.log
SQL> startup nomount pfile="c:\oracle\admin\TEST\scripts\init.ora";
ORA-25138: DISTRIBUTED_TRANSACTIONS initialization parameter has been made obsol
ete
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> CREATE DATABASE TEST
2 MAXINSTANCES 1
3 MAXLOGHISTORY 1
4 MAXLOGFILES 5
5 MAXLOGMEMBERS 3
6 MAXDATAFILES 100
7 DATAFILE 'D:\TEST\SYSTEM\SYSTEM01.DBF' SIZE 2048M REUSE AUTOEXTEND ON NEXT
10240K MAXSIZE UNLIMITED
8 EXTENT MANAGEMENT LOCAL
9 DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE 'F:\TEST\TEMP\TEMP01.DBF' SIZE 20
48M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
10 UNDO TABLESPACE "UNDOTBS1" DATAFILE 'c:\oracle\oradata\TEST\E:\IMM\UNDO\
UNDOTBS01.DBF' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
11 CHARACTER SET WE8MSWIN1252
12 NATIONAL CHARACTER SET AL16UTF16
13 LOGFILE GROUP 1 ('c:\oracle\oradata\TEST\redo01.log') SIZE 102400K,
14 GROUP 2 ('c:\oracle\oradata\TEST\redo02.log') SIZE 102400K,
15 GROUP 3 ('c:\oracle\oradata\TEST\redo03.log') SIZE 102400K;
CREATE DATABASE TEST
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
SQL> spool off
SQL> exit;
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
C:\>
Windows 2000 OS, Oracle 9.2.0.1