Re: help with CREATE DATABASE

look on my web page, there is a link for oracle scripts and on that page is a document about creating an oracle database. did you create ALL the directories?

joe

CONST wrote:

> 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 ;-)

--
Joseph S. Testa, Oracle Database Administrator, mailto:jtesta_at_scioto.net
(home)
Vice-President Ohio Oracle Users Group,
See the Oracle FAQ at http://www.orafaq.org
Try http://web.scioto.net/jtesta that is also the place to find the FREE,
drop column script
ICQ UIN:  2832230(&oracle, home).