Re: How to Create a new Oracle instance ?

From: Arati Vijay <vijayj_at_singnet.com.sg>
Date: Mon, 18 Oct 1999 23:49:32 +0800
Message-ID: <7uffpb$6kv$1@mawar.singnet.com.sg>

Hi,

I presume that you are running Oracle on Unix. You need to do the following:

create new initxxxx.ora files where xxxx is you instance name, with the necessary parameters.
create the new directories for storing your data files, control files and redo log files
create scripts for database creation, installing various packages, tablespace creation, user creation,
set the environment variable ORACLE_SID to xxxx (the instance name) connect as sysdba
create the database
bringup the database in the 'nomount' mode run the various creation scripts
exit
startup the database

To start your current instance, set your ORACLE_SID to the relevant value and startup

Regards,
VJ

Jack <zhangjun1975_at_263.net> wrote in message news:01bf1921$77d62000$b20a0a0a_at_smile.newksy.com.cn...
> Hi all:
>
> After I install oracle, I want to create another instance. But I don't
> know
> where can I find some documents about it?
>
> Thanks.
>
> Jack
>
Received on Mon Oct 18 1999 - 10:49:32 CDT