environmental variable issue

[learn]

Hello,
Can anybody explain to me what an environmental variable is?

Assuming I have 2 database on one machine, and I want to create a third database, do I need to set again an environmental variable? Or since there are two databases already running on that machine that means the environmental variable has already being set so there is no need to set it?

still learning,
learn

[sreddy]

the following are environment variables :

ORACLE_TERM
ORACLE_BASE
ORACLE_PATH
LD_LIBRARY_PATH
ORACLE_SID
ORACLE_HOME


Paths will point to the right binaries
Home point to the right version of home for respective sid
If your version doesn't change, you don't need to worry about O_H but, still you need to set O_S to be logged into...
If version does change, you need to export the oraenv/coraenv after setting O_S and O_H. which updates all the paths for that particular user/profile of that user.

[linda]

sreddy,

What is Oraenf/Coraenv? Thanks!

[sreddy]

Oraenv z the environment script provided by Oracle for Bourne/K-shell and Coraenv is for C-Shell.

Those two files will either in

/usr/bin/ or
/usr/local/bin