Re: Creating two instances in one server

"Ognjen Antonic" <ogo_at_ogo.homeip.net> wrote in message news:<zcLj9.2089$EM5.71218_at_news.siol.net>...
> You are probably using svrmgr for shutting down, starting up oracle
> database. Prior to using svrmgrl, ORACLE_SID environment variable should be
> properly changed. This is important, when you have multiple instances on
> same machine.
>
>
> Best regards,
>
>
> Ognjen Antonic
>
>
>
>
>
> "kiru" <kiru_at_picmond.com> wrote in message
> news:3D896B20.25A17495_at_picmond.com...
> > hi Guang,
> > Thamk u.
> > I have created the new database, but now i8 cannot start both the database
 at same
> > time.
> > I am starting XXXDB first and the 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.
> >
> >
> > G M wrote:
> >
> > > You need to set your ORACLE_SID to YYYDB, have your new initYYYDB.ora
> > > and then to create database YYYDB, just like you did for XXXDB. Make
> > > sure your semaphone setting (in /etc/system) is big enough for both
> > > XXXDB and YYYDB. I have done this many times and never had any
> > > problems.
> > >
> > > Good luck.
> > >
> > > Guang
> > >
> > > kiru <kiru_at_picmond.com> wrote in message
 news:<3D885B47.43FF8800_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
> >

The database that is automatically defined is the one that comes first in the /etc/oratab file.If you want to start the other one you must export oracle_sid=database_name or setenv or whatever. That should work.Feel free to use my email if you still have issues Michael Tubuo Ngong Received on Tue Sep 24 2002 - 16:55:31 CEST