Re: OCI Multiple homes

[Quoted] On May 9, 11:42 am, kvma..._at_gmail.com wrote:
> Hi,
>
> I have 2 Oracle Homes(both 10g) on Linux and each has one Database.
> I have an Application which uses OCI to connect to DB and fetch data
> from it.
>
> When I set the ORACLE_HOME to one of the homes, I am able to connect
> and fetch the data from that HOME. But I am not able to connect to
> the other HOME.
>
> My requirement needs that I need to connect to databases on different
> homes from my application.
>
> I have searched OCI documentation help provided by Oracle but couldnot
> find much about this.
>
> Can anyone help me in this regard.
>
> Thanks,
> Manoj

merge the two different tnsnames.ora files (in each ORACLE_HOME/ network/admin directory) in /etc/tnsnames.ora and point the env var TNS_ADMIN to /etc.

The solution of Carlos will force you to keep those files in sync manually.

--
Sybrand Bakker
Senior Oracle DBA