Re: error with dblink.
From: Vladimir M. Zakharychev <vladimir.zakharychev_at_gmail.com>
Date: Fri, 6 Feb 2009 03:04:50 -0800 (PST)
Message-ID: <2889e73a-57d0-4418-b1f6-1eb50bbb12df_at_p2g2000prf.googlegroups.com>
On Feb 6, 11:42 am, Faivre Dominique <faiv..._at_ecp.fr> wrote:
> 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)
Date: Fri, 6 Feb 2009 03:04:50 -0800 (PST)
Message-ID: <2889e73a-57d0-4418-b1f6-1eb50bbb12df_at_p2g2000prf.googlegroups.com>
On Feb 6, 11:42 am, Faivre Dominique <faiv..._at_ecp.fr> wrote:
> 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)
Yes, distributed_transactions is not session- or system-modifiable, you should edit your init.ora and restart the instance for the change to take effect.
Regards,
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm)
http://www.dynamicpsp.com
Received on Fri Feb 06 2009 - 05:04:50 CST