OraFAQ Forum: Server Administration » Hi how to shutdown DB

Home » RDBMS Server » Server Administration » Hi how to shutdown DB

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

Hi how to shutdown DB [message #194377]

Thu, 21 September 2006 16:02

saiyshnav
Messages: 15
Registered: August 2006
Location: Bangalore

Junior Member

Hi all

My system having one instance which is created Orcle Installation,Now i want create a DB,I setted primary issues like using ORADIM i created instance,and setted startmode as -a and password what are all neccessary,but script giving problem can some help if some body understand this errors

SQL> startup nomount pfile="d:\oracle\product\10.2.0\admin\mwm\pfile\init.ora";
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> CREATE DATABASE mwm
2 MAXINSTANCES 1
3 MAXLOGHISTORY 1
4 MAXLOGFILES 32
5 MAXLOGMEMBERS 5
6 MAXDATAFILES 500
7 DATAFILE SIZE 250M AUTOEXTEND ON NEXT 16M MAXSIZE UNLIMITED EXTENT MANA
GEMENT LOCAL
8 SYSAUX DATAFILE SIZE 128M AUTOEXTEND ON NEXT 16M MAXSIZE UNLIMITED
9 DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE SIZE 100M AUTOEXTEND ON NEXT 64
0K MAXSIZE 3000M
10 UNDO TABLESPACE "UNDOTBS1" DATAFILE SIZE 100M AUTOEXTEND ON NEXT 5120K MA
XSIZE UNLIMITED
11 CHARACTER SET WE8ISO8859P1
12 NATIONAL CHARACTER SET AL16UTF16
13 logfile group 1 size 48M,
14 group 2 size 48M,
15 group 3 size 48M,
16 group 4 size 48M;
CREATE DATABASE mwm
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-01100: database already mounted

SQL> spool off
SQL> exit;

[Updated on: Thu, 21 September 2006 16:30]

Report message to a moderator