Home » RDBMS Server » Server Administration » How to set ORAENV in linux
How to set ORAENV in linux [message #271834] Wed, 03 October 2007 01:56 Go to next message
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.
Re: How to set ORAENV in linux [message #271847 is a reply to message #271834] Wed, 03 October 2007 02:52 Go to previous messageGo to next message
Michel Cadot
Messages: 64098
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
Re: How to set ORAENV in linux [message #272062 is a reply to message #271834] Wed, 03 October 2007 22:10 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Do you mean oraenv file which is under /usr/local/bin .
Re: How to set ORAENV in linux [message #272080 is a reply to message #272062] Thu, 04 October 2007 00:02 Go to previous messageGo to next message
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
Re: How to set ORAENV in linux [message #297646 is a reply to message #272080] Fri, 01 February 2008 23:02 Go to previous messageGo to next message
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'
Re: How to set ORAENV in linux [message #297647 is a reply to message #297646] Fri, 01 February 2008 23:18 Go to previous messageGo to next message
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
Re: How to set ORAENV in linux [message #537905 is a reply to message #297647] Mon, 02 January 2012 15:26 Go to previous messageGo to next message
anwarhussain07
Messages: 1
Registered: January 2012
Location: India
Junior Member
login as Oracle user and type the below command to find the .bash_profile file.



Fal -a
Re: How to set ORAENV in linux [message #537990 is a reply to message #297646] Tue, 03 January 2012 05:57 Go to previous messageGo to next message
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
Re: How to set ORAENV in linux [message #538020 is a reply to message #271834] Tue, 03 January 2012 09:06 Go to previous messageGo to next message
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 Go to previous messageGo to next message
BlackSwan
Messages: 25032
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.
Re: How to set ORAENV in linux [message #538024 is a reply to message #538021] Tue, 03 January 2012 10:27 Go to previous messageGo to next message
Michel Cadot
Messages: 64098
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And the post seems to be just a blatant spam.

Regards
Michel
Re: How to set ORAENV in linux [message #539330 is a reply to message #538024] Fri, 13 January 2012 07:59 Go to previous message
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:
  


Current Time: Fri Dec 02 12:15:59 CST 2016

Total time taken to generate the page: 0.11139 seconds