VARIABLE DEFINITION for oracle user

[mohamed_42]

I want to ask how can i Define a req. variaable for oracle user and i copy my oracle CD on /var/ora how can i define req. variable according this path....

[Mel Burslan]

if you are talking about a shell variable, you can easily do this in either .profile or .kshrc /.cshrc (<--This one depends on your shell type) files located on oracle user's home directory.

Like:

ORACLE_BASE=/disk01/app/oracle
ORACLE_PATH=/disk01/app/oracle/product/8.1.7/bin:/opt/bin:/bin:/usr/local/bin
ora_db=/disk01/app/oracle/admin/INF
ORACLE_SID=XYZ
ORACLE_HOME=/disk01/app/oracle/product/8.1.7

Hope this helps

[Indira Aramandla]

Hi Mohamed,

You just do like

ORACLE_BASE=/opt/oracle
and when ever you want to refer this path you can say $ORACLE_BASE

Like ORACLE_HOME=/opt/oracle/product/8.1.7.4

Then you can say
ORACLE_HOME=$ORACLE_BASE/product/8.1.7.4
and refer it as $ORACLE_HOME in the script


Indira A

[Yogeeraj_1]

hi,

you can also do:
export MYVAR=/var/ora

regards
yogeeraj