Re: Creating two instances in one oracle server

Hi Kiru,

You need to set the ORACLE_SID environment variable correctly (as this determines which instance you wish to start)..

On Unix, simply:

ORACLE_SID=required_sid
export ORACLE_SID

Good Luck

Richard
"kiru" <kiru_at_picmond.com> wrote in message news:3D896BC3.8EFF45FE_at_picmond.com...
> hi steve,
> Thamk u.
> I have created the new database, but now i cannot start both the databases
at
> same
> time.
> I am starting XXXDB first and then i am trying to start YYYDB. Its saying
that
> ORACLE
> is running - shut it down first. Now i am struggling to start and run both
at
> the
> same time.
>
> thanx
> kiru.
>
>
>
> steve wrote:
>
> > 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 Thu Sep 19 2002 - 01:39:09 CDT