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

  • From: Peter Hitchman <pjhoraclel@xxxxxxxxx>
  • To: Subodh Deshpande <deshpande.subodh@xxxxxxxxx>
  • Date: Wed, 19 Jan 2011 15:25:25 +0000

I am talking about the set-up for single instance Oracle here, not
RAC, where the database instance and the application will run on the
same machine.
VM is not something that is being considered for this project.

Thanks for the comments so far. At the moment I am leaning towards a
separate client install.


On Wed, Jan 19, 2011 at 2:47 PM, Subodh Deshpande
<deshpande.subodh@xxxxxxxxx> wrote:
> am bit confused,
> you have an rac and separate application node as of now and now you do not
> want to have multiple nodes/hosts, instead you want to have one oracle home
> for database, another for oracle client for application maintenance, sounds
> good, but is new hardware capabale of accomodating database load and
> application load as well..if so then
> 0) who is going to maintain application i.e. dba then why you
> require oracle client
> 1) otherwise can you have an VM ware instance on the host and can you move
> application code to VMware and there you can install oracle client, I
> thought of this because, like some of list members have already said
> security can not be guranteed on the same host even if we install database,
> oracle client and application code with different users.  but what
> about groups.if they are not same then you are compramising with
> security, and in that case root user and or pseudo user password policies
> will not be kept secure, especially, if you/dba are not going to maintain
> the application node, which is on the same host. instead think of VM ware
> instance where you can give complete access to application team

Other related posts: