Re: Seperate Oracle Homes for each instance.

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Fri, 19 Mar 2004 10:47:34 +0100
Message-ID: <c3effl$fqj$1@news2.tilbu1.nb.home.nl>

Sybrand Bakker wrote:

> On Fri, 12 Mar 2004 17:33:53 GMT, "Bill Doggett"
> <bdoggett_at_direcway.com> wrote:
> 
> 

>>One thought we are looking to better what each instance is using as far as
>>resources is to have a seperate owner and Oracle Home for each instance.
>>Such as if we had a prod instance we would have a unix account name prod and
>>all the instance process and executables would be owned by prod. Second
>>instance (pweb) would have the same thing. Unix account and oracle home
>>with everything starting up as pweb. I can't seem to find any problems with
>>this. Want to know if anybody else did this and if they had problems with
>>it (besides duplicating the maintenance that may be needed.
>>
>>

>
> It is not going to work.
Of course it can work!

> There is a central oratab.
Yeah - and as long as you are aware of it - no problem. Rather an oracle installer flaw.

> There is a central tnsnames.ora.
No there is not. There's one in every Oracle home. > It is a maintenance nightmare. You would need to apply > patches to all Oracle homes.

Just because of that: test patches.
When no test machine is available...

-- 

Regards,
Frank van Bortel

Received on Fri Mar 19 2004 - 03:47:34 CST