Re: error with dblink.

From: ddf <oratune_at_msn.com>
Date: Thu, 5 Feb 2009 10:42:00 -0800 (PST)
Message-ID: <ba5def69-0720-4b9d-b546-e61d276be5d5_at_a39g2000prl.googlegroups.com>



On Feb 5, 10:48 am, Faivre Dominique <faiv..._at_ecp.fr> wrote:
> I need to access a oracle serveur in 8.0.6 from a client 10g.
> As I got the error "ORA-03134: Connections to this server version are no
> longer supported." someone told me to create a dblink on a 8.1.7 server.
> (in fact I had tested that  from the client 10g
> to 8.1.7 it was  ok and from a 8.1.7 to the serveur 8.0.6 it was also ok
> ) .So I created the dblink .
> But when I run a "select" on a table from the 8.0.6  on the 10g client
> with connection to the 8.1.7 where I have the dblink , I got the
> following error :
>
> ERROR at line 1:
> ORA-02042: too many distributed transactions
>
> I have verified the parameters on the 8.1.7 server I have
> distributed_transactions=0 and on the 8.0.6, I have "5" .
>
> What must I do ? I don't understand what is the link beetween the dblink
> and this parameter ? .Thanks in advance for help. Regards
>
> --
> Faivre Dominique        Administrateur systeme
>
>   « La décroissance ne propose pas de vivre moins, mais mieux avec moins
> de biens et plus de liens. » (Charte de la décroissance)

I believe you need to increase the distributed_transactions parameter value on the 8.1.7 database.

David Fitzjarrell Received on Thu Feb 05 2009 - 12:42:00 CST

Original text of this message