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!

How to set .oraenv in profile permanently in redhat linux?

RENGANATHANMGJun 11 2012 — edited Jun 11 2012
Hi All,

i am accessing sql loader and sqlplus through linux.

Every time when i logged in i need to setup . oraenv

then it will ask ORACLE_SID = [EIFLNXD1] ? and ORACLE_HOME = [opt/oracle] ?

I wanted to avoid this so i set my profile like this

export ORACLE_HOME=/usr/xxx/packages/oracle/oracle-11.2.0.1/
export PATH=$PATH:/usr/xxx/packages/subversion/1.6.9/bin/:/local/bin:/usr/local/libssh2/lib/:/usr/xxx/packages/subversion/current/bin:$ORACLE_HOME:.
export ORACLE_BASE=/usr/xxx/packages/oracle/oracle-11.2.0.1/
export TNS_ADMIN=/auto/engweb/oracle/sqlnet
export ORACLE_SID=SYSERT1
export ORAENV_ASK=NO
*. /usr/xxx/packages/oracle/oracle-11.2.0.1/bin/oraenv*

After saved and closed my session and i re opened again .......It shows this message.

Cisco Linux 5.50-5Server Kickstarted on: Fri Nov 5 16:07:44 PDT 2010.
-bash: dbhome: command not found
ORACLE_HOME = [] ?


How to fix this problem?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 9 2012
Added on Jun 11 2012
3 comments
2,586 views