Re: How can I create a database with Oracle8.0.5 on RS6000?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 8 Mar 2001 09:59:18 +0100
Message-ID: <taeib7ntnnii0a@beta-news.demon.nl>

"Ron" <ronyin_at_tpts5.seed.net.tw> wrote in message news:9876iq$eqh_at_netnews.hinet.net...
> I'm new to oracle.
> I'm using oracle8.0.5 on RS6000(Aix4.3).
> i'd like to know how to create a database by using command rather then
 using
> tools.
> i didn't find many information about how to create a database manaully.
>
> Ron
>
>

You did find the create database command though? Topics like this are typically adressed in the Oracle Server Administrators documentation.

Generally speaking

- assign a sid,
- edit the /etc/oratab to add the new sid
- setup an appriopate init<sid>.ora in $ORACLE_HOME/dbs, changing at least

the control_files parameter
- export ORACLE_SID=<yournewsid>
- svrmgrl
connect / as sysdba
startup nomount
spool credb.log

@<create database script, containing the create database command only>
@?/rdbms/admin/catalog
@?/rdbms/admin/catproc

exit

and that should be all there is to it.

BTW 8.0.5 has been desupported. You need to upgrade to 8.0.6 or 8.1.6. Hth,
Sybrand Bakker, Oracle DBA Received on Thu Mar 08 2001 - 02:59:18 CST