Re: OCI Multiple homes

On 9 mayo, 11:42, 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

Hello.

Put apropriate aliases in both tnsnames.ora and use the proper connect string aliases to connect.

HTH. Cheers.

Carlos. Received on Wed May 09 2007 - 12:50:31 CEST