Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Does it matter where the binaries are?

RE: Does it matter where the binaries are?

From: Hostetter, Jay M <>
Date: Thu, 10 Mar 2005 13:29:08 -0500
Message-ID: <>

Stephen,=0D=0A=0D=0A  For many years we have been running Oracle in a 2 nod=
e cluster=0D=0Aenvironment (HP Tru64, 8i and 9i databases), but without RAC=

=2E We have=0D=0AORACLE_HOME, ORACLE_BASE, the datafiles, etc. stored out =
on the shared=0D=0Adisks. If one node crashes, we can just bring up the da= tabase on the=0D=0Aother node. I'm going to argue that you don't even need= your standby=0D=0Adatabase.=20=0D=0A In this scenario, when we do OS patc= hes, we patch both nodes and=0D=0Arelink the Oracle software. /etc is shar= ed by both nodes - I don't know=0D=0Aif that is the case in your scenario.=0D=

=0A Since ORACLE_HOME is on the shared disks, we can't accidentally start=0D=
=0Athe database on both nodes - Oracle complains that it can't mount the=0D=
=0Adatabase in exclusive mode.=0D=0A You can also setup different ORACLE_H=
OMEs for different applications.=0D=0AThat way you don't affect all databas=
es on all of the nodes.  When we do=0D=0Adatabase upgrades, I setup a new O=
racle Home and migrate the databases=0D=0Aover to it, one at a time.=0D=0A =
 You may want to setup a listener for each database or each node - give=0D=0A= it a unique name like LISTENER_DB1 or LISTENER_NODE1, or something like=0D=0A=
that.  In our situation, we use cluster services to assign a IP=0D=0Aaddres=
ses that are unique for each database.  When we move the 'service'=0D=0Ato =
another node, the IP goes with it, so we don't have to change our=0D=0ATNSN=
AMES files.=0D=0A=0D=0AJay=0D=0A=0D=0A-----Original Message-----=0D=0AFrom:=[] =
On Behalf Of stephen booth=0D=0ASent: Thursday, March 10, 2005 11:41 AM=0D=0A= To: Oracle-L=0D=0ASubject: Does it matter where the binaries are=3F=0D=0A=0D=
=0AWe have a collection of systems proposed where a set (I'm delibaerately=0D=
=0Aavoiding the word 'cluster' here as we're not talking=0D=0ARAC) of Sun V=
440 boxes will be running Oracle instances attached to a=0D=0ANetApp 920c f=
iler cluster providing storage.  Each server will be=0D=0Arunning one live =
production database and one hot standby (dataguard) of=0D=0Aone of the data=
base for which the live database is on one of the other=0D=0Aservers.=0D=0A=0D=

=0AThe datafiles for each database will be on the filer, each database will=0D=
=0Abe uniquely named to ensure no name clashes.=0D=0A=0D=0AIt has been sugg=
ested that we put the Oracle binaries on the filer so=0D=0Awhen we patch on= e server we're patching them all. From discussions so=0D=0Afar it sounds l= ike $ORACLE_BASE will point to a location on the server=0D=0Abut $ORACLE_HO= ME will point to a location on the filer (alert logs,=0D=0Atnanames &c will= be on the server storage, datafiles and binaries will=0D=0Abe on the filer= ).=0D=0A=0D=0AObviously we'll have to make sure trhat the Oracle user UID n= umbers are=0D=0Athe same accross all servers (but we have to do that anyway= regfardless=0D=0Aof where the binaries live) and will have to ensure that = the correct=0D=0Apermissions are set and the files in /usr/local/bin and /v= ar/opt/oracle=0D=0Aare created (presumably riunnign the and orainst= scripts=0D=0Acreated when we do the first install will accomplish t= his).=0D=0A=0D=0ACould someone please tell me. Has anyone done this (seems= a pretty=0D=0Aobvious thing to try)=3F Did it work=3F Is there anything = we need to watch=0D=0Aout for (have I missed anything)=3F Is anyone aware = of any documentation=0D=0Aon how to do this=3F=0D=0A=0D=0AThanks=0D=0A=0D=0A= Stephen=0D=0A=0D=0A--=0D=0AIt's better to ask a silly question than to make= a silly assumption.=0D=0A--=0D=0A
=0A=0D=0A=0D=0A=0D=0A=0D=0A**DISCLAIMER=0D=0AThis e-mail message and any fi=
les transmitted with it are intended for the use of the individual or entit= y to which they are addressed and may contain information that is privilege= d, proprietary and confidential. If you are not the intended recipient, you= may not use, copy or disclose to anyone the message or any information con= tained in the message. If you have received this communication in error, pl=
ease notify the sender and delete this e-mail message. The contents do not = represent the opinion of D&E except to the extent that it relates to their = official business.=0D=0A
Received on Thu Mar 10 2005 - 13:32:30 CST

Original text of this message