RE: Oracle installation on Local disk vs. SAN

From: Michael Schmitt <mschmitt_at_uchicago.edu>
Date: Thu, 14 May 2009 18:43:19 -0500
Message-ID: <E37E556CF8A6C44381D2DA9FC354D2410108B0D30235_at_EVS03.ad.uchicago.edu>

Does anyone know if there is a performance difference between keeping the binaries on local disk compared to the SAN?

One advantage of putting the Oracle Home and database on the SAN is that if your database server goes down, it is possible to mount all of those disks on a seperate server (but same OS) and start up the database

---

From: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] On Behalf Of Matthew Zito [mzito_at_gridapp.com] Sent: Thursday, May 14, 2009 3:44 PM
To: sims_at_suu.edu; Oracle-L Freelists
Subject: RE: Oracle installation on Local disk vs. SAN

I have both extremes - customers with 100+ instances running out of one ORACLE_HOME, and customers that deploy one ORACLE_HOME for every instance. We typically recommend the latter configuration, especially for production environments, as it removes the, "Well, I don't want you to apply that patch to *my* database" coupled with "But I *have* to get that patch applied to *my* database" between two users sharing the same oracle_home.

Plus it allows you to do better privilege separation by running different databases as different OS users.

Thanks,
Matt

--
Matthew Zito
Chief Scientist
GridApp Systems
P: 646-452-4090
mzito_at_gridapp.com
http://www.gridapp.com



-----Original Message-----
From: oracle-l-bounce_at_freelists.org on behalf of April Sims
Sent: Thu 5/14/2009 4:00 PM
To: Oracle-L Freelists
Subject: Re: Oracle installation on Local disk vs. SAN

Everyone,

Is there any physical limits you would be up against?  The number of instances per ORACLE_HOME?



April Sims
SELECT IOUG Contributing Editor
http://aprilcsims.wordpress.com
OCP 8i, 9i, 10g DBA
Southern Utah University
sims_at_suu.edu
940-484-4276




>>> William Wagman <wjwagman_at_ucdavis.edu> 5/14/2009 1:30 PM >>>

Greetings,

We have just purchased a new very large SAN to which we will be migrating several databases. There are also two new servers which will be connected to this SAN. We will be running RHEL5 and Oracle 11g. We are in the midst of a discussion with the system administrator who wants us to install Oracle on the SAN rather than the local disk on the new server. We, the DBAs would like to have it installed on the local disk, of which there is plenty.

We are wondering about the pros and cons of installing Oracle on the local disk versus the SAN. All comments appreciated.

Thanks.

Bill Wagman
Univ. of California at Davis
IET Campus Data Center
wjwagman_at_ucdavis.edu
(530) 754-6208

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



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




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

Received on Thu May 14 2009 - 18:43:19 CDT