Re: OCI Multiple homes
Date: 9 May 2007 22:53:29 -0700
Message-ID: <1178776409.096841.12250_at_e51g2000hsg.googlegroups.com>
Hi,
I merged the two tnsnames.ora file and kept in /etc It worked fine.
It works even though TNS_ADMIN is not set. This we have tried on 10g.
Thanks a lot
Manoj
On May 9, 10:40 pm, sybra..._at_hccnet.nl wrote:
> On 9 May 2007 06:46:58 -0700, Carlos <miotromailcar..._at_netscape.net>
> wrote:
>
> >Sybrand, I'm afraid I disagree.
>
> >Different ORACLE_HOMEs may have different aliases in their respective
> >tnsnames.ora (maybe they will connect to different groups of
> >instances, different environments, etc, etc...)
>
> >What I said is that the OP should put the *apropriate* alias in the
> >files and connect using them in the correct way (whatever this way
> >is).
>
> >It was you who figured out that the two tnsnames.ora should be the
> >same, not me.
>
> >Cheers.
>
> Carlos,
> I'm afraid I consider this as promoting maintaining messes.
> The mess you describe above is the perfect reason to
> either set up a central tnsnames.ora or abandon tnsnames.ora
> completely and setup OID.
> Apparently you never have been in the situation you describe. I have.
> I don't want to jump around every individual workstation because
> Oracle was upgraded. In fact this was on of the reasons NOT to
> upgrade, and to continue to use desupported versions, without a proper
> support contract in place.
>
> Sorry to say so, but you shouldn't learn people how NOT to do their
> job.
>
> --
> Sybrand Bakker
> Senior Oracle DBA
Received on Thu May 10 2007 - 07:53:29 CEST