I have an 11g database on red hat linux and when I initially log into the machine as the Oracle user and do and export ORACLE_SID when I do a sqlplus / as sysdba it doesnt pick up the the database I specified(in this situation lumtest). If I do an . oraenv though it picks up the correct database. I cant seem to see what is missing as I have provided a dump of the user environment before and after I do the . oraenv.
I thought . oraenv set the base home and path so I'm not sure what else I should look for.
[oracle@adorcl ~]$ env|grep -i oracle
USER=oracle
LD_LIBRARY_PATH=/opt/oracle/product/11.2.0/dbhome_1/lib
ORACLE_SID=lumtest
ORACLE_BASE=/opt/oracle/
MAIL=/var/spool/mail/oracle
PATH=/opt/oracle/product/11.2.0/dbhome_1//bin:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/oracle/bin
PWD=/home/oracle
HOME=/home/oracle
LOGNAME=oracle
ORACLE_HOME=/opt/oracle/product/11.2.0/dbhome_1/
[oracle@adorcl ~]$ . oraenv
ORACLE_SID = [lumtest] ?
The Oracle base for ORACLE_HOME=/opt/oracle/product/11.2.0/dbhome_1 is /opt/oracle/
[oracle@adorcl ~]$ env|grep -i oracle
USER=oracle
LD_LIBRARY_PATH=/opt/oracle/product/11.2.0/dbhome_1/lib
ORACLE_SID=lumtest
ORACLE_BASE=/opt/oracle/
MAIL=/var/spool/mail/oracle
PATH=/opt/oracle/product/11.2.0/dbhome_1/bin:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/oracle/bin
PWD=/home/oracle
HOME=/home/oracle
LOGNAME=oracle
ORACLE_HOME=/opt/oracle/product/11.2.0/dbhome_1