Re: Q on concepts of instances and mutliple databases on the same server

Simon -

You can have multiple instances running on the same server at the same time as long as your server has the resources to handle it (memory, disk, cpu, etc)

Just make sure you have your environment variables set up correctly so you do not accidentaly screw up the wrong instance while practicing your recovery scenarios.

Enjoy,

Chris Tirpak
cbtirpak_at_fred.net

On Tue, 21 Jan 1997 09:32:06 -0800, Simon Goland <sg_at_mda.ca> wrote:

>Something I am confused about. I have a running database and all is
>well. However, I need to demonstrate the various recovery procedures to
>our customer, and for that I will create another, dummy database to play
>with. It will reside on the same machine.
>
>So right now I have a Oracle instance running the "real" database. Can I
>have another instance running my "dummy" on the same machine at the same
>time, with its own datafiles, tablespaces and stuff, or do I have to
>shutdown the "real" thing and then create and configure and play with
>the "dummy"? And shut the real one down every time I need to play with
>the dummy?
>
>Thanks,
>--
>[ Simon Goland B-)> sg_at_mda.ca ]
>[ Without action there is no change ]
Received on Thu Jan 23 1997 - 00:00:00 CST