Re: Creating two instances in one oracle server

From: steve <scolebrookt_at_yahoo.com>
Date: Wed, 18 Sep 2002 12:28:15 +0100
Message-ID: <3d8861aa$0$121$7b0f0fd3@reader.news.newnet.co.uk>

Kiru,

All you need to do is set your ORACLE_SID in the environment to be (YYYDB)

Once it is started, enter

ps -eaf|grep pmon

That will show you the process monitors for the 2 instances running.

HTH Steve
"kiru" <kiru_at_picmond.com> wrote in message news:3D885BA9.D9EABED_at_picmond.com...
> Hi,
> I am using Oracle 8.6.1 running in Solaris. I have created one database
> (XXXDB) with one SID (XXXDB) and it is running properly. Now i want to
>
> create one more databse (YYYDB) and new SID(YYYDB). What are all the
> nessary things to be done and how to start a database when another
> database is already running. I appreciate if anybody help on this issue.
>
> thanx,
> kiru
>
>
>
Received on Wed Sep 18 2002 - 06:28:15 CDT