10g $ORACLE

From: Thomas Jeff <jeff.thomas_at_thomson.net>
Date: Mon, 9 Aug 2004 10:10:33 -0500
Message-ID: <358728A276824E419580403633AABFD0021F6239@INDYSMAIL03.am.thmulti.com>

If your site has installed 10g, what $ORACLE_HOME setting are you using?

Historically, we've used the format $ORACLE_BASE/product/release, so that
for say, 9i, we would see:

$ORACLE_BASE/product/9.2.0.2
$ORACLE_BASE/product/9.2.0.4

Oracle has tweaked the OFA so that it now recommends ORACLE_HOME be=20 set like this:

$ORACLE_BASE/product/10.1.0/{type}_{counter}
where type is the product name: db - database server, client, etc

So for our first enterprise install, ORACLE_HOME would be set thus:

$ORACLE_BASE/product/10.1.0/db_1 (which actually is version
10.1.0.2)

Now, let's say we want to patch to 10.1.0.2. What we would do is clone db_1=20
into db_2 and then patch the db_2 version, giving us:

$ORACLE_BASE/product/10.1.0/db_1
$ORACLE_BASE/product/10.1.0/db_2

Oracle cites the advantages of the new OFA structures as:

o You can install different products with the same release number in the same=20
$ORACLE_BASE
o You can install the same product more than once in the same $ORACLE_BASE However, it's not visually apparent as to the specific release you are looking=20
at when perusing the directory structure under the new OFA structure. =20

Thanks!

Jeff T.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Mon Aug 09 2004 - 10:06:41 CDT

10g $ORACLE_HOME