Re: Server Architecture
Date: Thu, 3 Jan 2008 09:23:37 -0600 (CST)
We mostly use this architecture in production, i.e. one Unix account and set of binaries per instance. It has plusses and minuses. The plus is when application A needs a patch, but applications B through E do not. With one set of binaries, the patch needs to be tested (in theory) on all applications.
Or, Application A is on Oracle 9i and is upgraded to a new version that requires 10g. But, applications B through E aren't supported on 10g. Or are supported on 10.2.0.1, but not 10.2.0.3.
In my experience, the problems are endless.
We also use Veritas clustering software and have the need to failover individual databases to a different server. I'm not sure how that would be done without each database having it's own Oracle binaries, listener, etc.
This architecture was decided before I arrived. I've done it both ways and to me, this way has less headaches.
>> From: oracle-l-bounce_at_freelists.org
>> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Satheesh
>> Sent: Thursday, January 03, 2008 12:49 AM
>> Subject: Server
>> We have been proposed with following architecture by our
>> consultant. I need your expert opinion on this.
>> Assume a
>> server got 5 database and all the databases running in same oracle version
>> They are proposing to create 5 unix account. Each unix account
>> will have one oracle binaries and corresponding oracle DB. Apart from that
>> unix account will have dedicated mountpoints. In broader sense each unix
>> will be logically considered as one server.
>> I am slightly worried about this architecture. Because when this
>> architecture goes to production, the impact it will have on maintenace going
>> be huge. Assuming i am having minimum 100 db in production( ours is a very
>> shop) and if i need to apply one patch to all these servers going to kill
>> Secondly, will there be a impact on licensing. I don't think so, but like to
>> check it up with you guys. I know it has got some advantage too. But is this
>> approach is suitable for large shop like us?
>> Satheesh Babu.S