Home » RDBMS Server » Networking and Gateways » Re: ORA-02042: too many distributed transactions while using database link
Re: ORA-02042: too many distributed transactions while using database link [message #66169] Mon, 07 January 2002 23:49 Go to next message
Ewoks
Messages: 1
Registered: January 2002
Junior Member
Increase the DISTRIBUTED_TRANSACTIONS parameter in the initialization parameter file, shut down and restart Oracle, or run fewer transactions. If it is certain there are not too many concurrent distributed transactions, this may be an internal error. In this case, contact customer support. Shutting down and restarting the instance could be a work-around.
Re: ORA-02042: too many distributed transactions while using database link [message #66753 is a reply to message #66169] Wed, 11 December 2002 18:39 Go to previous message
amelia
Messages: 2
Registered: December 2002
Junior Member
Hi, I am not very tech savvy but I need to solve a problem for my customer.

How do I ascertain that there are not too many concurrent distributed transactions? Is there an SQL query I can use?

And wouldn't shutting down Oracle disable the system for quite a while?

Thanks.
Previous Topic: Re: Can't Install java 2 on Pentium 4 ?
Next Topic: NAMES SERVER MIGRATION
Goto Forum:
  


Current Time: Fri Mar 29 01:44:57 CDT 2024