Re: Creating two instances in one server

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
>
Received on Mon Sep 23 2002 - 22:54:56 CEST