Re: Database Link & ORA-02042

From: Brian Peasland <peasland_at_usgs.gov>
Date: Thu, 26 Apr 2001 12:42:37 GMT
Message-ID: <3AE817BD.45B12803@usgs.gov>

> In the cats session before exiting, do a "alter session close database link
> <YOUR DB LINK>;" to avoid dangling leftover database links. Hope this helps.

After you've tried Martin's good suggestion and you still find that you are receiving this error, you may need to increase the number of allowable distributed transactions. This can be accomplished by increasing the DISTRIBUTED_TRANSACTIONS parameter in your INIT.ORA. Default values are OS specific. After you've changed this parameter, don't forget to bounce your database for the changes to take effect.

HTH,
Brian

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================

Received on Thu Apr 26 2001 - 07:42:37 CDT