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!

Setting ORACLE_HOME env. in OE Linux

user645637Aug 20 2013 — edited Aug 23 2013

Hi All,

I have Installed Oracle Database 11g successfully on OEL 5.3

In order to start the database

I have a following script to start my database called as start_db.sh

export ORACLE_HOME=/u01/app/oracle/Database/11.2.0/orcl

export ORACLE_SID=orcl

$ORACLE_HOME/bin/lsnrctl start

$ORACLE_HOME/bin/sqlplus "/ as sysdba" <<!

startup

exit

!

when I run this script with oracle user login

I get the following error :

/bin/lsnrctl: No such file or directoryorcl

/bin/sqlplus: No such file or directoryorcl

However when I go to the shell prompt $

and run the individual line manually as

export ORACLE_HOME=/u01/app/oracle/Database/11.2.0/orcl

export ORACLE_SID=orcl

$ORACLE_HOME/bin/lsnrctl start

$ORACLE_HOME/bin/sqlplus "/ as sysdba" <<!

startup

every command runs successfully till I am able to startup the database.

what is missing in the start_db.sh script which give me the error as No such file or directory.

I am stuck in this issue, please help me to resolve this.

If any mail replies, please send it to ajazahmednet@gmail.com ASAP.

Thanks

Ajaz Ahmed

This post has been answered by user645637 on Aug 23 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 20 2013
Added on Aug 20 2013
35 comments
13,142 views