-
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
-
Two Server in the same Unix box. Ungent
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...
Jeff Hunter
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|