ORAENV file in unix

[roukie_dba]

Dear members/moderators
Would some please explain to me what the ORAENV file is used for?

[marist89]

The oraenv file is used to setup your environment when you login.

[cib]

for more info on ORAENV check out:

http://www.vi.unizh.ch/oracle8i_816/...a77379/ch1.htm

[roukie_dba]

Thanks so much for the clarification!!!

[kris109]

Oraenv is used to set your ORALCE_HOME and ORACLE_SID.

It is typically used if you are running different oracle products, for example, sqlplus, sqlldr and also forms and reports. Then you use oraenv to change the oracle home to 8.1.7 for sqlldr and dev2k for forms.

You can run it from your .profile or from command line unix. It will prompt you with default oracle home and default oracle sid and you type the new sid and home if change is needed.


[Edited by kris109 on 06-29-2001 at 12:02 PM]