Message-Id: <25956.338437@fatcity.com> From: April Wells Date: Fri, 18 Jul 2003 07:36:45 -0500 Subject: RE: Physical Design Question This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C34D29.3FF45180 Content-Type: text/plain; charset="iso-8859-1" We have one Oracle home for all of our non-11i backend instances and one each for each of them (more for the extproc's that Dick was talking about and for ease of testing upgrades than for any other pressing reason.) Auditors are a funny breed... they want total separation even at the expense of practicality. April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas You will recognize your own path when you come upon it, because you will suddenly have all the energy and imagination you will ever need. ~ Jerry Gillies ~ -----Original Message----- From: Goulet, Dick [mailto:DGoulet@vicr.com] Sent: Friday, July 18, 2003 8:19 AM To: Multiple recipients of list ORACLE-L Subject: RE: Physical Design Question Ray, Boy are you ever. In our location every version gets an Oracle_Home. Databases that share the same version share the same home. BTW: Oracle Support recommends using the listener for the highest version installed. I do that & it works very darn well, unless your into extproc's. Then you should have an extproc listener for each version installed. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -----Original Message----- Sent: Thursday, July 17, 2003 7:29 PM To: Multiple recipients of list ORACLE-L my 2cents... Every instance get it's own oracle home, user id and group id. Total isolation and separation. It makes our auditors happy too! Then again, I may be an extremist... Ron Thomas Hypercom, Inc rthomas@hypercom.com Each new user of a new system uncovers a new class of bugs. -- Kernighan Stephen.Lee@DTAG. Com To: ORACLE-L@fatcity.com Sent by: cc: ml-errors@fatcity Subject: RE: Physical Design Question .com 07/17/2003 05:14 PM Please respond to ORACLE-L Well, since nobody else has jumped on this... -----Original Message----- > Here's my situation: > 1. Should I use a separate Oracle Home for each DB? Not unless you have some peculiar situation there. Use separate ORACLE_HOME for each version of Oracle but not each database. > Pros: --Allows upgrade/patching of 1 DB at a > time without affecting others (some are home-grown, > some are 3rd party). The separate ORACLE_HOME for each version takes care of this. You just change the ORACLE_HOME in the oratab when you upgrade the database. If you use environment setting scripts, have them grab the correct ORACLE_HOME from the oratab. something like: export ORACLE_HOME=`/usr/bin/nawk -F: '$1 == SID {print $2}' SID="$ORACLE_SID" "$ORATAB"` where ORATAB is the path to your oratab file. Sorry, I got no opinions on your storage arrangement. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: Stephen.Lee@DTAG.Com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Thomas INET: rthomas@hypercom.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: DGoulet@vicr.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment. ------_=_NextPart_001_01C34D29.3FF45180 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: Physical Design Question

We have one Oracle home for all of our non-11i backend= instances and one each for each of them (more for the extproc's that Dick= was talking about and for ease of testing upgrades than for any other= pressing reason.)

Auditors are a funny breed... they want total separation= even at the expense of practicality.

April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas

You will recognize your own path when you come upon it,= because you will suddenly have all the energy and imagination you will= ever need.

~ Jerry Gillies ~



-----Original Message-----
From: Goulet, Dick [mailto:DGoulet@vicr.com]
Sent: Friday, July 18, 2003 8:19 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Physical Design Question


Ray,

        Boy are you= ever.  In our location every version gets an Oracle_Home. = Databases that share the same version share the same home.  BTW:= Oracle Support recommends using the listener for the highest version= installed.  I do that & it works very darn well, unless your into= extproc's.  Then you should have an extproc listener for each version= installed.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-----Original Message-----
Sent: Thursday, July 17, 2003 7:29 PM
To: Multiple recipients of list ORACLE-L



my 2cents...

Every instance get it's own oracle home, user id and= group id.  Total isolation and separation.  It
makes our auditors happy too!

Then again, I may be an extremist...

Ron Thomas
Hypercom, Inc
rthomas@hypercom.com
Each new user of a new system uncovers a new class of= bugs. -- Kernighan


           &nbs= p;            &= nbsp;           &nbs= p;            &= nbsp;           &nbs= p;            &= nbsp;           &nbs= p;            &= nbsp;           &nbs= p;            &= nbsp;           &nbs= p;        

           &nbs= p;         = Stephen.Lee@DTAG.         &nb= sp;            =             &nb= sp;            =             &nb= sp;            =             &nb= sp;            =          

           &nbs= p;         = Com            = ;         = To:      = ORACLE-L@fatcity.com         =             &nb= sp;            =             &nb= sp;            =          

           &nbs= p;          Sent= by:            = ;    = cc:            = ;            &n= bsp;            = ;            &n= bsp;            = ;            &n= bsp;            = ;        

           &nbs= p;         = ml-errors@fatcity        Subject: = RE: Physical Design= Question           =             &nb= sp;            =             &nb= sp;           =

           &nbs= p;         = .com           &nbs= p;            &= nbsp;           &nbs= p;            &= nbsp;           &nbs= p;            &= nbsp;           &nbs= p;            &= nbsp;           &nbs= p;       

           &nbs= p;            &= nbsp;           &nbs= p;            &= nbsp;           &nbs= p;            &= nbsp;           &nbs= p;            &= nbsp;           &nbs= p;            &= nbsp;           &nbs= p;        

           &nbs= p;            &= nbsp;           &nbs= p;            &= nbsp;           &nbs= p;            &= nbsp;           &nbs= p;            &= nbsp;           &nbs= p;            &= nbsp;           &nbs= p;        

           &nbs= p;          07/17/2003= 05:14           &nb= sp;            =             &nb= sp;            =             &nb= sp;            =             &nb= sp;            =         

           &nbs= p;         = PM            =             &nb= sp;            =             &nb= sp;            =             &nb= sp;            =             &nb= sp;            =          

           &nbs= p;          Please respond= to            =             &nb= sp;            =             &nb= sp;            =             &nb= sp;            =             &nb= sp;      

           &nbs= p;         = ORACLE-L           =             &nb= sp;            =             &nb= sp;            =             &nb= sp;            =             &nb= sp;            =     

           &nbs= p;            &= nbsp;           &nbs= p;            &= nbsp;           &nbs= p;            &= nbsp;           &nbs= p;            &= nbsp;           &nbs= p;            &= nbsp;           &nbs= p;        

           &nbs= p;            &= nbsp;           &nbs= p;            &= nbsp;           &nbs= p;            &= nbsp;           &nbs= p;            &= nbsp;           &nbs= p;            &= nbsp;           &nbs= p;        





Well, since nobody else has jumped on this...

-----Original Message-----
> Here's my situation:
> 1.  Should I use a separate Oracle Home for= each DB?

Not unless you have some peculiar situation there. = Use separate ORACLE_HOME
for each version of Oracle but not each database.

> Pros:   --Allows upgrade/patching of 1 DB= at a
> time without affecting others (some are= home-grown,
> some are 3rd party).

The separate ORACLE_HOME for each version takes care of= this.  You just
change the ORACLE_HOME in the oratab when you upgrade= the database.  If you
use environment setting scripts, have them grab the= correct ORACLE_HOME from
the oratab.

something like:

export ORACLE_HOME=3D`/usr/bin/nawk -F: '$1 =3D=3D SID= {print $2}'
SID=3D"$ORACLE_SID"= "$ORATAB"`

where ORATAB is the path to your oratab file.


Sorry, I got no opinions on your storage= arrangement.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
  INET: Stephen.Lee@DTAG.Com

Fat City Network Services    --= 858-538-5051 http://www.fatcity.com
San Diego,= California        -- Mailing list and= web hosting services
---------------------------------------------------------------------<= /FONT>
To REMOVE yourself from this mailing list, send an= E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of= 'ListGuru') and in
the message BODY, include a line containing: UNSUB= ORACLE-L
(or the name of mailing list you want to be removed= from).  You may
also send the HELP command for other information (like= subscribing).




--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ron Thomas
  INET: rthomas@hypercom.com

Fat City Network Services    --= 858-538-5051 http://www.fatcity.com
San Diego,= California        -- Mailing list and= web hosting services
---------------------------------------------------------------------<= /FONT>
To REMOVE yourself from this mailing list, send an= E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of= 'ListGuru') and in
the message BODY, include a line containing: UNSUB= ORACLE-L
(or the name of mailing list you want to be removed= from).  You may
also send the HELP command for other information (like= subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Goulet, Dick
  INET: DGoulet@vicr.com

Fat City Network Services    --= 858-538-5051 http://www.fatcity.com
San Diego,= California        -- Mailing list and= web hosting services
---------------------------------------------------------------------<= /FONT>
To REMOVE yourself from this mailing list, send an= E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of= 'ListGuru') and in
the message BODY, include a line containing: UNSUB= ORACLE-L
(or the name of mailing list you want to be removed= from).  You may
also send the HELP command for other information (like= subscribing).

The=
 information contained in this communication, including attachments, is=
 strictly=20
confidential and for the intended use of the addressee only; it may also=
 contain=20
proprietary, price sensitive, or legally privileged information. Notice is=
 hereby given that=20
any disclosure, distribution, dissemination, use, or copying of the=
 information by anyone=20
other than the intended recipient is strictly prohibited and may be=