Environment Variable

UNIX for Beginners Q & A UNIX for Dummies Questions & Answers
1

$ . oraenv (when i type this at the prompt)
ORACLE_SID = [AHP2DD] ? ( I get this)

I understand that . oraenv is a startup script and it has the ENV variable ORACLE_SID.

But pls let me know what more it explains and also how to change the env variable here.

2

For changing the environment variables you need to change the
script that sets them i.e. in your .oraenv
like :
If running under Boune shell
export ORACLE_SID=<your value of ORACLE_SID>
If running under csh/tcsh
setenv ORACLE_SID <your value of ORACLE_SID>

A good idea would be to set these variables in your initialisation files.

3

Got it ,thx