RE: Physical Design Question

isolated for you mere mortals!!!!!

REAL MEN STRESS NT boxes!!

-----Original Message-----
From: Joe Testa [mailto:jtesta_at_dmc-it.com] Sent: Friday, July 18, 2003 12:24 PM
To: Multiple recipients of list ORACLE-L Subject: Re: Physical Design Question

Tom, yours is an isolated incident, bwahhahahaha, unix still rulz

joe

Mercadante, Thomas F wrote:

>We do it all the time. Not a problem at all. My current dev box has 17
>instances on it (a shared box among many projects). There is nothing to
>prevent you from doing this. And turn-around for a development box is
>reasonable.
>
>My production NT 4.0 box has two active Oracle instances on it - Production
>and Training. Running Oracle Failsafe to fail both instances over when the
>primary box fails.
>
>So naa-naa to the NT nay-sayers.
>
>Tom Mercadante
>Oracle Certified Professional
>
>
>-----Original Message-----
>Sent: Friday, July 18, 2003 11:55 AM
>To: Multiple recipients of list ORACLE-L
>
>
>It's entirely possible to have multiple Oracle homes with multiple
>databases on windoze.
>
>Not as slick as unix, but it works.
>
>Jared
>
>
>
>
>
>
>"Gene Sais" <Gsais_at_co.palm-beach.fl.us>
>Sent by: ml-errors_at_fatcity.com
> 07/18/2003 06:59 AM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> cc:
> Subject: RE: Physical Design Question
>
>
>I do the same. One OH for each version. Listener uses the latest OH.
>Databases set env script for OH required. Simple and it works.
>I couldn't imagine having 14 OH's for 14 8i databases on one server :).
>Now if I were running on Windows then I would have one db per server hence
>one OH. Its all relative, do what you like!
>Gene
>
>
>
>>>>DGoulet_at_vicr.com 07/18/03 09:19AM >>>
>>>>
>>>>
>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_at_hypercom.com
>Each new user of a new system uncovers a new class of bugs. -- Kernighan
>
>
>
> Stephen.Lee_at_DTAG.
> Com To: ORACLE-L_at_fatcity.com
>
> Sent by: cc:
> ml-errors_at_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_at_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_at_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).
>
>
>
>
>
>

-- 
Joseph S Testa
Chief Technology Officer
Data Management Consulting
614-791-9000
It's all about the "CACHE"


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joe Testa
  INET: jtesta_at_dmc-it.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_at_fatcity.com (note EXACT spelling of 'ListGuru') and in