Re: ORACLE_BASE & ORACLE_HOME

<vasarpota_at_my-deja.com> wrote in message news:8n17g1$o6a$1_at_nnrp1.deja.com...
> If I have multiple databases and multiple versions of Oracle, how do
> these variables work?
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

Let's say we have the following structure

/u/oracle

---------- /u/oracle/admin
--------------------------/SID1
---------------------------------/bdump
---------------------------------/create
---------------------------------/pfile
---------------------------------udump
-------------------------/SID2
--------------------------------/bdump
-------------------------------/create (etc.
-----------------/product/7.3.4
-------------------------------/bin
------------------------------/rdbms (etc)
-----------------/product/8.1.5

ORACLE_BASE is going to be set to /u/oracle, *independent of version* you can cd to the udump directory for instance by issuing
cd $ORACLE_BASE/admin/$ORACLE_SID/udump

ORACLE_HOME is going to be set *preferably by use of oraenv* to a version specific directory
eg /u/oracle/product/8.1.5

This allows for
a) using a ? mark in filenames in sql*plus and init.ora when referring to ORACLE_HOME
b) using a @ in the same when referring to ORACLE_SID c) *most important* being able to develop version and instance independent maintenance scripts. The only thing you need to do is to set the ORACLE_SID and the ORACLE_HOME appriopiately and you are done. Final note: although officially the post-installation root.sh should set ORACLE_BASE, you still need to do it by hand in your own .login or .profile.

Hth,
Sybrand Bakker, Oracle DBA Received on Fri Aug 11 2000 - 00:00:00 CDT