Home » RDBMS Server » Server Administration » Hi how to shutdown DB
Hi how to shutdown DB [message #194377] Thu, 21 September 2006 16:02 Go to next message
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

Re: Hi how to shutdown DB [message #194378 is a reply to message #194377] Thu, 21 September 2006 16:02 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
SQL> SHUTDOWN ABORT
Re: Hi how to shutdown DB [message #194670 is a reply to message #194377] Sat, 23 September 2006 16:15 Go to previous message
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
Senior Member
Agree with anacedent.

do 'shutdown abort' first
Previous Topic: row chaining
Next Topic: dispatcher confusion
Goto Forum:
  


Current Time: Sat Dec 03 05:49:15 CST 2016

Total time taken to generate the page: 0.09199 seconds