Re: Database >1 per Instance

From: Michael Krolewski <vandra_at_u.washington.edu>
Date: Sat, 22 May 1999 12:25:59 -0700
Message-ID: <374704C7.A3538913@u.washington.edu>

I believe you are asking if more than 1 database can be running on the same server at the same time. Yes. Each database needs a separate SID and init<sid> file.

The simplist idea is to create the second init<sid>.ctl file. And then use the Oracle instance manager software to create/start the instance. Assuming the startup is automatic, both instances will restart when the server is restarted. The user needs to pick the instance to log into.

Mike Krolewski

sherwin wrote:

> Hi There,
> Can I have more than one Database per instance in Oracle 8. If yes,
> then will the normal ,,startup'' command start and mount each of these
> databases. where and how do I specify that my instance has more than one
> database. Thanks for your time.
>
> sherwin.
Received on Sat May 22 1999 - 14:25:59 CDT