Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: $ORACLE_HOME environment variable

Re: $ORACLE_HOME environment variable

From: RP Data Solutions <rpdata_at_cyberus.ca>
Date: Mon, 30 Nov 1998 03:02:27 GMT
Message-ID: <36620a23.1755025883@news.cyberus.ca>


How about another unix account that is used for Dev 2000 and just set the variable in the profile...

"Julien" <Julien.Labbe_at_wanadoo.fr> wrote:

>Hi !
>
>I have a HP UX 10.20 system running Developer 2000 1.6.1 and Oracle Server
>7.3.3.
>
>I've got a problem with $ORACLE_HOME environment variable :
>Developer 2000 needs the variable to point to the Dev/2000 directory (for
>instance, /soft/dev161).
>But Oracle utilities such as SQL*Loader, Pro*C compiler, Import and Export
>need the ORACLE_HOME variable to point to the Oracle directory (for
>instance /soft/ora733).
>
>So if I want to run a form with Dev2000, I can't use SQL*Loader, for
>instance.
>(I can if I change the value of ORACLE_HOME each time I use SQL*Loader, but
>it's not a good solution because I need to change 100 scripts running
>SQL*Loader).
>Has anyone a better solution to solve this problem ?
>Thank you,
>Julien
>
Received on Sun Nov 29 1998 - 21:02:27 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US