| Create DB Instance [message #53438] |
Thu, 19 September 2002 13:25  |
Rizwan Qazi
Messages: 135
Registered: August 2002
|
Senior Member |
|
|
I want to create a db instance on a UNIX box. Would I have to bring Oracle down to accomplish this?
Thank You
Rizwan
|
|
|
|
| Re: Create DB Instance [message #53439 is a reply to message #53438] |
Thu, 19 September 2002 13:37  |
Rizwan Qazi
Messages: 135
Registered: August 2002
|
Senior Member |
|
|
I am running a createdb1.sql script at svrmgrl and this is the error I am getting....
-----------------------------------------
SVRMGR> @createdb1.sql
Termout ON
Echo ON
SVRMGR> spool createdbDWT.log
SVRMGR> --
SVRMGR> connect internal
Connected.
SVRMGR> startup nomount pfile=/u01/app/oracle/admin/DWT/pfile/initDWT.ora
ORA-01081: cannot start already-running ORACLE - shut it down first
SVRMGR> CREATE DATABASE DWT
2> LOGFILE GROUP 1 ('/u01/oradata/DWT/redoDWT1a.log','/u01/oradata/DWT/redoDWT1b.log') size 10M reuse,
3> GROUP 2 ('/u01/oradata/DWT/redoDWT2a.log','/u01/oradata/DWT/redoDWT2b.log') size 10M reuse,
4> GROUP 3 ('/u01/oradata/DWT/redoDWT3a.log','/u01/oradata/DWT/redoDWT3b.log') size 10M reuse
5> MAXLOGFILES 255
6> MAXLOGMEMBERS 5
7> MAXLOGHISTORY 100
8> DATAFILE '/u01/oradata/DWT/SYSDWT01.dbf' size 100M reuse
9> MAXDATAFILES 2000
10> MAXINSTANCES 10
11> ARCHIVELOG
12> EXCLUSIVE
13> /
CREATE DATABASE DWT
*
ORA-01501: CREATE DATABASE failed
ORA-00205: error in identifying controlfile, check alert log for more info
SVRMGR> spool off
SVRMGR>
SVRMGR> quit
Server Manager complete.
---------------------------------------------------
What am I doing wrong?
Thanks
Rizwan
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
