Re: rac & client connection

yup alex,
my original issue was resolved by using ip address on all tns entries. including the tns entry that specified on local_listener or remote_listener.

regarding TAF, i'm testing it by using sqlplus. i think that sqlplus is a tool which RAC ready.

regard
ujang

On 2/20/07, Alex Gorbachev <gorbyx_at_gmail.com> wrote:
>
> That's another problem. Your app should actually be RAC compatible
> including connection management and failover handling.
> Regarding you original issue, perhaps, you should try specifying IP
> address instead of hostname in tnsnames.ora.
>
> On 2/19/07, Ujang Jaenudin <ujang.jaenudin_at_gmail.com> wrote:
> > tnsping is always OK.
> >
> > I got a funny things over linux.
> > when trying Failover, this error comes:
> >
> > ERROR:
> > ORA-25401: can not continue fetches
> >
> > scenario select * from sh.sales on a node and the instance I aborted for
> > that session, but the select could not continue....
> >
> >
> > regards
> > Ujang
> >
> >
> >
> > On 2/20/07, Eric Gross <egross_at_gridapp.com> wrote:
> > >
> > >
> > >
> > >
> > > What are the results from tnsping? If this is a random error, I
> suggest
> > trying tnsping multiple times to see if the results are consistant.
> > >
> > >
> > >
> > >
> > > Eric Gross
> > >
> > > Mr. Database
> > >
> > > GridApp Systems
> > >
> > > Ph: 646-452-4050
> > >
> > > egross_at_gridapp.com
> > >
> > > ________________________________
> >
> > >
> > > From: oracle-l-bounce_at_freelists.org [mailto:
> > oracle-l-bounce_at_freelists.org] On Behalf Of Ujang Jaenudin
> > > Sent: Monday, February 19, 2007 9:22 PM
> > > To: oracle-l_at_freelists.org
> > > Subject: Re: rac & client connection
> > >
> > >
> > >
> > >
> > > ERROR:
> > > ORA-12545: Connect failed because target host or object does not exist
> > >
> > > and this only happen on windows client, while in linux client it
> doesn't
> > happen.
> > >
> > > regards
> > > ujang
> > >
> > >
> > >
> > >
> > > On 2/20/07, Alex Gorbachev <gorbyx_at_gmail.com> wrote:
> > >
> > > What's the error number?
> > >
> > > On 2/19/07, Ujang Jaenudin <ujang.jaenudin_at_gmail.com> wrote:
> > > > the problem is:
> > > >
> > > > when connect through sqlplus on client (windows), i got error
> randomly,
> > and
> > > > can connect randomly too.
> > >
> > > --
> > > Best regards,
> > > Alex Gorbachev
> > >
> > > http://www.oracloid.com
> > >
> > >
> > >
> > >
> > > --
> > > regards
> > > ujang
> >
> >
> >
> > --
> > regards
> > ujang
>
>
> --
> Best regards,
> Alex Gorbachev
>
> http://www.oracloid.com
>

-- 
regards
ujang

--
http://www.freelists.org/webpage/oracle-l