Re: [Q] How does UNIX know where $ORACLE_HOME is?

This is true if your shell type is sh or ksh - but if using csh, then it would be set using either .login or .cshrc

Also, it could be globally set in the /etc/profile (sh and ksh) or /etc/.login (chs)

Another alternative, is for the .profile or .login etc to call oraenv or coraenv (often found in /opt/bin). This is used to read the oratab file, and if ORAENV_ASK=NO is set in your .profile and an ORACLE_SID is set, then oraenv will determine the ORACLE_HOME from the oratab file according to the ORACLE_SID defined, without prompting the user.

HTH Henrik Meldgaard Frisk wrote:
>
> Hi
>
> The ORACLE_HOME directory is specified as an enviroment variable in a shell
> file.
> I presume that your are log in as the Oracle user an not someone else? Every
> user has it's own .profile. Maybe you are looking in the wrong .profile.
>
> Or maybe the .profile calls a shell file where it is all set.
> On our Unix server the .profile calls a enviroment shell file where all
> enviroment variables is set. Also ORACLE_HOME.
>
> Shell files has the extension .sh. Try to look for a file whit the extension
> <.sh> Or maybe you can sceach for the file whit the extension *.sh if you
> can't see it in your .profile.
>
> Hope this can help you.
> Henrik
> Denmark
>
> JOC <oconnorj_at_freenet.co.uk> wrote in message news:385e148c.8347087_at_NEWS...
> > Hi,
> >
> > This came up at work today and is pure curiosity. We all use
> > $ORACLE_HOME (HP-UX server), but we don't have it in our .profiles.
> > I've looked it up in the handbook, and it seems to be a mixture of
> > /etc/oratab and the listener, but I still can't work out how the OS
> > knows where ORACLE_HOME is.
> >
> > Please help - it's going to niggle me until I find out.
> >
> > Yours in anticipation
> >
> > Jo
> >
> >
> > *************************************************
> >
> > The usual - anything I say reflects on me, and not upon my current
> employer.
> >
> > *************************************************
Received on Mon Dec 20 1999 - 07:22:26 CST