Re: MULTIPLE INSTANCES

Hi,

        A DataBase can be mount by many instance it's the parallel server option.

		Check if you have install it.
			It require a Lock manager not provide by Oracle on Unix, but by the unix
server.
		Check if you have set the parameter 
			in the init.ora
			AT THE DATABASE CREATION
		Check you rollback segment private or public for each instance

	Everything is explain in the parallel server manual.

Regards Francois.                         

Nathan D. Hughes <nhughes_at_well.com> wrote in article <6010l8$oc7$1_at_was.hooked.net>...
> >> Can we have more than one instance for the same database on a single
> >> server machine and what benefit we will get ?
>
> You can, but the potential to mess stuff up seems pretty large. Only
> one instance could mount the db, obviously - but I've had some
> pretty bad db corruption (on NT granted) by trying to mount an
> already open db with another instance (accidentally).
>
> But, yes - this is somethign good to do when you run your db during the
> day as an OLTP system, and at night run your batch jobs. You can adjust
> your memory allocs etc. for the purpose you need it for. Just make sure
> you bulletproof your startup/shutdowns.
> --
>
> ---
> Nathan D. Hughes <nhughes_at_well.com>
> Computer Consultants of America, Inc.
>
Received on Mon Sep 22 1997 - 00:00:00 CDT