Hi Folks,
Having trouble getting sqlplus to run on unix for a 10g version of the database i am running. Works fine for the training 9i version and i cannot see any environment issues.

9i environment
Code:
#TRAIN
alias TRAIN='ORACLE_SID=TRAIN ; export ORACLE_SID; \
ORACLE_BASE=/app/oracle ; export ORACLE_BASE
ORACLE_HOME=/app/oracle/general/9.2.0; export ORACLE_HOME \
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib:/usr/ucblib
export LD_LIBRARY_PATH ; PATH=/app/oracle/general/9.2.0/bin:$PATH'
10g environment
Code:
#TEST
alias TEST='ORACLE_SID=TEST ; export ORACLE_SID; \
ORACLE_BASE=/app/oracle ; export ORACLE_BASE
ORACLE_HOME=/app/oracle/test/10.2.0; export ORACLE_HOME \
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib:/usr/ucblib
export LD_LIBRARY_PATH ; PATH=/app/oracle/test/10.2.0/bin:$PATH'
If i run the TRAIN environment i can connect to sqlplus but if i run the TEST environment i get the following
Code:
Error 6 initializing SQL*Plus
Message file sp1.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
ORACLE_HOME is set.
This is the same environment settings i have for the oracle unix user and it works fine for that user. This is for a different unix user that i get these problems, same .profile.

Any idea?