topic Re: VARIABLE DEFINITION for oracle user in Operating System - HP-UX

VARIABLE DEFINITION for oracle user

mohamed_42 — Wed, 01 Jun 2005 12:43:28 GMT

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....

Re: VARIABLE DEFINITION for oracle user

Mel Burslan — Wed, 01 Jun 2005 15:41:17 GMT

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

Re: VARIABLE DEFINITION for oracle user

Indira Aramandla — Wed, 01 Jun 2005 22:59:02 GMT

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

Re: VARIABLE DEFINITION for oracle user

Yogeeraj_1 — Thu, 02 Jun 2005 05:13:03 GMT

hi,

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

regards
yogeeraj