RE: Does it matter where the binaries are?
- From: "Hostetter, Jay M" <JHostetter@xxxxxxxxxxxxxxxxxxxx>
- To: "Oracle-L" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 10 Mar 2005 13:29:08 -0500
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:=
oracle-l-bounce@xxxxxxxxxxxxx=0D=0A[mailto:oracle-l-bounce@xxxxxxxxxxxxx] =
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 root.sh and orainst=
Root.sh 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//www.freelists.org/webpage/oracle-l=0D=
=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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
