Re: Creating two instances in one oracle server

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:16:35 CDT