Re: error with dblink.

From: Faivre Dominique <faivred_at_ecp.fr>
Date: Fri, 06 Feb 2009 09:42:48 +0100
Message-ID: <gmgtc5$v95$1_at_guepard.ecp.fr>

Vladimir M. Zakharychev wrote:

> On Feb 5, 7:48 pm, 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)

> 
> 
> This parameter in pre-9i databases controls if the database can
> participate in distributed transactions (which are performed via db
> links,) and in how many at a time. There is direct connection between
> this parameter and db links: even remote queries are transactions. In
> 9i it was replaced with open_links and open_links_per_instance
> parameters. Set this parameter to a non-zero value in your 8.1.7 db
> (for example, the same as in 8.0.6 db.)
> 
> Regards,
>    Vladimir M. Zakharychev
>    N-Networks, makers of Dynamic PSP(tm)
>    http://www.dynamicpsp.com

Hello
Thanks for your answer i will try this asap when it will be possible because I suppose I must stop start oracle after modifying the parameters ?

-- 
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)

Received on Fri Feb 06 2009 - 02:42:48 CST