Re: Best practice for Oracle clients with a single instance database

I would keep them separate for several reasons.
You can upgrade them separately.
You can secure them separately
If someone mistaking does an RM on the client side, it is very fast to fix.
If these are in with the database binaries - Oh no Mr Bill.... 

And I am in total agreement with separating the app from the database either 
virtually or physically.  Beside security, you have more visiblity as to who is 
taking resources, etc.

--- On Wed, 1/19/11, Hemant K Chitale <hemantkchitale@xxxxxxxxx> wrote:

From: Hemant K Chitale <hemantkchitale@xxxxxxxxx>
Subject: Re: Best practice for Oracle clients with a single instance database
To: pjhoraclel@xxxxxxxxx
Cc: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
Date: Wednesday, January 19, 2011, 9:59 AM

When I used to do it : the client install is a custom install with only client 
libraries (e.g. even exclude the export utility) in a separate OS account that 
is in neither the oinstall nor the dba groups.  Then the client home can be 
handed over to the apps team.


The only issue is that you would be configuring sqlnet tcpip and suffer tcpip 
stack overheads and not use bequeath and ipc.

Hemant K Chitale

http://hemantoracledba.blogspot.com

sent from my smartphone
On Jan 19, 2011 6:27 PM, "Peter Hitchman" <pjhoraclel@xxxxxxxxx> wrote:

Hi,

Having over  the past couple of years started to work with RAC, where

the application code runs from another server with an Oracle client

install, I am back setting up a single instance where the application

code will run on the

same machine. It occurred to me that it might make sense to still

install an Oracle runtime or instant client for the application to

use,  as well as the database install, because that way I could

upgrade one without interfering with the other. On the down side it

means there will be an extra oracle home to maintain and if the

releases are different, I might run into issues with the oraenv/dbhome

programmes.



What do most people out there do, with single instance set-ups?



Thanks

Pete

--

http://www.freelists.org/webpage/oracle-l

Other related posts: