RE: Physical Design Question

From: Stephen Lee <Stephen.Lee_at_DTAG.Com>
Date: Thu, 17 Jul 2003 17:16:15 -0500
Message-Id: <25946.338337@fatcity.com>

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. Received on Thu Jul 17 2003 - 17:16:15 CDT