OraFAQ Forum: Server Administration » How to set ORAENV in linux

Home » RDBMS Server » Server Administration » How to set ORAENV in linux

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to set ORAENV in linux [message #271834]

Wed, 03 October 2007 01:56

altafhk
Messages: 45
Registered: June 2007
Location: Islamabad

Member

Every time when i open terminal, I have to set ORAENV variable in linux. I tried to find out .bash_profile but i can't find where it resides.

Report message to a moderator

Re: How to set ORAENV in linux [message #271847 is a reply to message #271834]

Wed, 03 October 2007 02:52

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Don't use this pink color, it is awful.

Quote:

I have to set ORAENV variable

Why?
There is no ORAENV variable for Oracle.
Check if it is this variable or another one.

Regards
Michel

Report message to a moderator

Re: How to set ORAENV in linux [message #272062 is a reply to message #271834]

Wed, 03 October 2007 22:10

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Do you mean oraenv file which is under /usr/local/bin .

Report message to a moderator

Re: How to set ORAENV in linux [message #272080 is a reply to message #272062]

Thu, 04 October 2007 00:02

mson77
Messages: 208
Registered: August 2007
Location: Brazil

Senior Member

Hello altafhk,

Regarding your question, I will post an example:

[oracle@mylinux ~]$ env|grep ORA
ORACLE_SID=MYSID
ORACLE_BASE=/u01/app/oracle
ORACLE_TERM=xterm
ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
[oracle@mylinux ~]$

And to have these variables set you should place these lines below into .bash_profile file:

ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1; export ORACLE_HOME
ORACLE_SID=MYSID; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM

Regards,

mson77

Report message to a moderator

Re: How to set ORAENV in linux [message #297646 is a reply to message #272080]

Fri, 01 February 2008 23:02

altafhk
Messages: 45
Registered: June 2007
Location: Islamabad

Member

Thank you, mson77. My question was about .bash_profile location because I have very limited knowledge about linux. Now I knew that dot means hidden file. It is a hidden file that can be edited by file giving command 'vi .bash_profile'

Report message to a moderator

Re: How to set ORAENV in linux [message #297647 is a reply to message #297646]

Fri, 01 February 2008 23:18

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,
you can set oracle home directory ".bash_profile".
http://www.linux.org/docs/ldp/howto/Oracle-9i-Fedora-3-Install-HOWTO/sect_04.html

you can also set all this variable in user login shell ".profile".

hope this helps

Report message to a moderator

Re: How to set ORAENV in linux [message #537905 is a reply to message #297647]

Mon, 02 January 2012 15:26

anwarhussain07
Messages: 1
Registered: January 2012
Location: India

Junior Member

Report message to a moderator

Re: How to set ORAENV in linux [message #537990 is a reply to message #297646]

Tue, 03 January 2012 05:57

tim2boles
Messages: 38
Registered: August 2008
Location: Clarksburg, WV

Member

Yes you can edit it with

vi .bash_profile

That is if you are in the home directory.

Regards
Tim

Report message to a moderator

Re: How to set ORAENV in linux [message #538020 is a reply to message #271834]

Tue, 03 January 2012 09:06

hua052011
Messages: 2
Registered: January 2012
Location: canada

Junior Member

Hi

I read some opinions in this topic. I do not agree above ideal. We can find out some articles at spam.com by using Google search.

[Updated on: Fri, 13 January 2012 08:15] by Moderator

Report message to a moderator

Re: How to set ORAENV in linux [message #538021 is a reply to message #538020]

Tue, 03 January 2012 09:20

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>We can find out some articles at about.com by using Google search.
Not everything found on the 'Net is true.

Report message to a moderator

Re: How to set ORAENV in linux [message #538024 is a reply to message #538021]

Tue, 03 January 2012 10:27

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

And the post seems to be just a blatant spam.

Regards
Michel

Report message to a moderator

Re: How to set ORAENV in linux [message #539330 is a reply to message #538024]

Fri, 13 January 2012 07:59

hua052011
Messages: 2
Registered: January 2012
Location: canada

Junior Member

Hi

You can find this info by using search box in the top of website with some keywords related before posting questions.

If you want to get more materials that related to this topic, you can visit: spam url removed by jd

Best regards.

[Updated on: Fri, 13 January 2012 08:08] by Moderator

Report message to a moderator

Previous Topic:	Oracle Questions
Next Topic:	Time remaining to complete table statistics

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 16:13:21 CDT 2024