Re: create second database

From: <bgokberk_at_my-deja.com>
Date: Tue, 13 Jul 1999 12:39:57 GMT
Message-ID: <7mfc2r$hes$1@nnrp1.deja.com>

Steps are:

1. Set your ORACLE_SID to your new SID.
2. Create new initSID.ora, configSID.ora.
3. Connect to server by connect internal
4. startup nomount pfile= give full path of your new initSID.ora

run your create database script.
additionally you may create new tablespaces. 5. run catalog.sql and catproc.sql in this order.(this may take a while)

now, you have your new db.
to connect your new db, it is enough to set your ORACLE_SID before entering server manager.

In article <7mergh$2mia$1_at_storm.comstar.ru>, "Vadim Grepan" <kezal_at_mail.ru> wrote:
> Hello All!
>
> I want to create one additional database (Solaris x86, Oracle
7.3.3). Is
> it
> enough to create new initxxx.ora and then say 'CREATE DATABASE
..'?
> Documentaion has been seen by me isn't clear enough :(
>
> And how can I startup all existing darabases without specify
> pfile-parameter?
>
> Rgds, Vadim Grepan
> --------
> kezal_at_mail.ru
> 2:5020/653_at_fidonet.org
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Jul 13 1999 - 07:39:57 CDT