Hi
I have Oracle 10.2.0 installed on Redhat 4 linux. My $ORACLE_HOME is like
/home/oracle/oracle. Which i set in .bash_profile file. I have checked using OUI i have only one Oracle home.
ORACLE_BASE=/home/oracle; export ORACLE_BASE;
ORACLE_HOME=$ORACLE_BASE/oracle; export ORACLE_HOME;
ORACLE_OWNER=oracle; export ORACLE_OWNER;
ORACLE_SID=orcl; export ORACLE_SID;
ORACLE_TERM=xterm; export ORACLE_TERM;
TNS_ADMIN=/home/oracle/oracle/network/admin; export TNS_ADMIN;
LD_LIBRARY_PATH=/home/oracle/oracle/bin; export LD_LIBRARY_PATH;
PATH=$PATH:$ORACLE_HOME/bin;
export PATH
unset USERNAME
even i have done same settings in /ect/profile file.
and after doing it i restart the system but each time i login like
[oracle@satish ~]$ echo $ORACLE_HOME
/home/oracle/oracle/product/10.2.0/client_1
[oracle@satish ~]$ cd /home/oracle/oracle/bin
[oracle@satish bin]$ ./sqlplus
Error 6 initializing SQL*Plus
Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
My problum is
*[oracle@satish ~]$ echo $ORACLE_HOME*
*/home/oracle/oracle/product/10.2.0/client_1*
but don't know how to solve it.
[oracle@satish bin]$ ORACLE_HOME=/home/oracle/oracle
[oracle@satish bin]$ export ORACLE_HOME
[oracle@satish bin]$ ./sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on Wed May 20 15:52:17 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
I work fine if i do now ORACLE_HOME is set correctly. but i don't wan to do it again and again i logIn. I want set ORACLE_HOME correct in one time.
Thanks
Umesh
Edited by: Umesh Sharma on May 21, 2009 2:40 AM
Edited by: Umesh Sharma on May 21, 2009 5:46 AM