| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> help with CREATE DATABASE
Hi All!
I'm new in Oracle administration and have many problems :-(. One of them
follow.
I edit initSID.ora file like inittest.ora from installer, then make some
directories in $ORACLE_HOME/admin/$ORACLE_SID/*dump...,
$ORACLE_HOME/db1/$ORACLE_SID, $ORACLE_HOME/db2/$ORACLE_SID,
$ORACLE_HOME/db3/$ORACLE_SID. Then connected in SVRMGR like INTERNAL,
STARTUP NOMOUNT, @create_db.sql and cannot get prompt from SVRMGR!
Ctrl-C is not abort this process! I can kill it only! What can I do?
$ORACLE_HOME /oracle
$ORACLE_SID first
db_name first
create_db.sql:
CREATE DATABASE first
LOGFILE
GROUP 1 ('/oracle/db1/oradata/first/first01.log',
'/oracle/db2/oradata/first/first01.log')
SIZE 50K,
GROUP 2 ('/oracle/db1/oradata/first/first02.log',
'/oracle/db2/oradata/first/first02.log')
SIZE 50K
MAXLOGFILES 4
MAXLOGHISTORY 100
MAXDATAFILES 8
MAXINSTANCES 2
ARCHIVELOG
CHARACTER SET CL8ISO8859P5
DATAFILE '/oracle/db1/oradata/first/first.dta' SIZE 10M,
'/oracle/db1/oradata/first/first01.dbf' SIZE 50M
;
All data files was created!
CONST P.S. Sorry for my english ;-) Received on Fri Jan 16 1998 - 00:00:00 CST
![]() |
![]() |