Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> help with CREATE DATABASE

help with CREATE DATABASE

From: CONST <const_at_const.ricor.ru>
Date: 1998/01/16
Message-ID: <34BF5C2A.F95C8DDD@const.ricor.ru>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US