Re: Problem with $ORACLE_HOME variable

From: Jochen Van den Bossche <Jochen.Van-Den-Bossche_at_eurocontrol.be>
Date: Tue, 01 Dec 1998 08:05:29 +0000
Message-ID: <3663A349.74F5_at_eurocontrol.be>


I think (not sure) that oracle_home was designed to be ONE root directory for all Oracle products.
Try putting oracle_home to point to "/soft" (and nothing more)

Julien 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 Tue Dec 01 1998 - 09:05:29 CET

Original text of this message