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