Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Environment Variables

KannanBDec 29 2009 — edited Dec 29 2009
Hello All,

Im installing oracle 11g database in oracle linux 5.1.

Im a new user to linux. Installation was successful, but database is not starting up automatically.

When i run the command sqlplus from oracle user it says command not found. But when i run the command from root user command is working.

Following are the entries in my /home/oracle/.bash_profiles files,


TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR

ORACLE_HOSTNAME=localhost.localdomain; export ORACLE_HOSTNAME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.1.0/db_1; export ORACLE_HOME
ORACLE_SID=orcl; export ORACLE_SID
PATH=$PATH:$HOME/bin;export PATH
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH


What I have to do .

1. I want to auto start and stop the instance.
2. I have to login from oracle user.

Kindly help.

Regards,
Kannan B
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 26 2010
Added on Dec 29 2009
30 comments
2,574 views