ORACLE_SID unix help(ASAP)

the Unix box have a 8.1.5 oracle server, and I just installed oracle 8.1.6 in the same machine using a different ORACLE_HOME directory.
I put different oracle_home directories according to the SID_NAME in the oratab file.

For example
HOST:/export/oracle/app/product/8.1.5:N
CODE:/export/oracle/app/product/8.1.6:N

If I ran profile file whenever I change the ORACLE_SID, Oracle read a right ORACLE_HOME directory, but if I change ORACLE_SID in the shell prompt.

export ORACLE_SID=HOST
echo $ORACLE_SID
>HOST
echo $ORACLE_HOME
>/export/oracle/app/product/8.1.6
then shows me a wrong ORACLE_HOME path.

What do I need to put to the profile file for the user oracle to manage both ORACLE_SID and ORACLE_HOME separately?
Thanks.

I think you have to edit the profile (add an entry) in order for it to reflect the new db created with 8.1.6

I think that oracle pick up ORALCE_HOME path from oratab.
and I already put the following in the profile file.

ORACLE_SID=HOST; export
. /usr/local/bin/oraenv
TNS_ADMIN=$ORACLE_HOME/network/admin; export ORACLE_HOME
LD_LIBRARY_PATH=$ORACLE_HOME/lib; export LD_LIBRARY_PATH

Now, I can not connect to the existing database.
It says that
ld.so.1: oracleHOST: fatal: relocation error: file /export/oracle/app/product/8.1.6/lib/libjox8.so: symbol joxsgal_: referenced symbol not found
ERROR:
ORA-12547: TNS:lost contact

So I issued lsnrctl> status
then
ld.so.1: lsnrctl: fatal: relocation error: file lsnrctl: symbol naemd5s: referenced symbol not found
Killed.

Is there anybody who is familiar with this issue?

Changing your environment after you login is a real pain.

We try to source the oraenv script every time we change the ORACLE_SID. In a previous company, we had scripts for each instance that we would source. Those scripts would re-source .profile and then tack on the apropriate environment variables.

With using oraenv, I find it easier to logout and log back in...

I would change
LD_LIBRARY_PATH=$ORACLE_HOME/lib; export LD_LIBRARY_PATH
to
LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH; export LD_LIBRARY_PATH
Hope it helps

So far it seems that the only wat to change ORACLE_HOME path dynamically is to run profile file.

Thanks.

At this point , I am using 8.1.5's listener and I put each SID's Home directory like the following
BEFORE:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CODE)
)
(SID_DESC =
(SID_NAME = HOST)
)
)
AFTER:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME=/export/oracle/app/product/8.1.6)
(SID_NAME = CODE)
)
(SID_DESC =
(ORACLE_HOME=/export/oracle/app/product/8.1.5)
(SID_NAME = HOST)
)
)
Then I reloaded Lstener

LSNRCTL> reload

Connecting to (ADDRESS=(PROTOCOL=TCP)(HOST=XXXXX)(PORT=XXXX))
TNS-01201: Listener cannot find executable /epxort/oracle/app/product/8.1.6/bin/oracle for SID CODE

If I remove all the directory I entered and then It work
LSNRCTL> status
Connecting to (ADDRESS=(PROTOCOL=TCP)(HOST=XXXXX)(PORT=XXXX))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Solaris: Version 8.1.5.0.0 - Production
Start Date 22-MAY-00 11:13:55
Uptime 184 days 4 hr. 10 min. 0 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /export/oracle/app/product/8.1.5/network/admin/listener.ora
Listener Log File /export/oracle/app/product/8.1.5/network/log/listener.log
Services Summary...
CODE has 1 service handler(s)
The command completed successfully

Please help me ~

1. You can have one value for each variable in your profile file.e.g.
If you have the following parameters in your profile file:

ORACLE_HOME=/export/oracle/app/product/8.1.5

ORACLE_SID=HOST

And, you want to start CODE database, you need to change the ORACLE_HOME and ORACLE_SID at $prompt.

2. oratab file parameters:

HOST:/export/oracle/app/product/8.1.5:N
CODE:/export/oracle/app/product/8.1.6:N

This is for starting the database at system bootup.

3. For listener.ora: I guess you need to add one more ADDRESS for the new software i.e. oracle 8.1.6.0 with change SID_LIST_LISTENER that you did already.

Regards,

abhijit

Thank you for the all the help.
LISTENER PROBLEM is related to prot setting.
Since two listerner are running in different version, I needed two ports and different listener name.

SID problem:
whatever I do I could not change ORACLE_HOME path accoding to ORACLE_SID change.
temporary, I will change PATH in shell prompt explicitly.
I need to think about this more.

Again thanks.