Re: create new database

1
either by using the installer (IIRC you still need to create an init.ora and set the ORACLE_SID) or by the same procedure, go into svrmgrl, connect internal, startup nomount, create database etc. etc. etc.

2 Databases are distinguished ao by their SIDs, so yes 4 You need to edit the init.ora to reflect the new SID 5 Either the Getting Started Manual or the Server Administrators Manual should have sufficient info. Please keep in mind Oracle is not a toy like Sqlserver or MySql.

Hth,

Sybrand Bakker, Oracle DBA

"Danu Kusmana" <danukusmana_at_investorindonesia.com> wrote in message news:3A5A4444.80208_at_investorindonesia.com...
> Hai it's me again; still newbie :-)
>
> I have created a database when I succeeded Installed the Oracle8i on my
> Linux and thanx God I now can use the net8 to connect my database server
> from my web server. My questions are:
> 1. How to create new database?
> 2. Do I have to change the SID value, because the instructions I
> received from Oracle8i Linux Starter kit book I have to input the value
> ORACLE_SID=MySID into my .bash_profile?
> 3. If not, how the Oracle can see the different?
> 4. I have read that to create a database, first we have to create an
> instance; copy from init.ora to our own initSID.ora and than follow alot
> of instructions to create a database. But how I can use that
> initNEWSID.ora if I've already startup another *.ora; startup open
> pfile=$ORACLE_HOME/dbs/initOLDSID.ora?
> 5. IS there any document I can read for this damn things?
>
> Thanx
>
Received on Mon Jan 08 2001 - 17:35:03 CST