Re: ORA-02055 followed by ORA-02067

Re: ORA-02055 followed by ORA-02067

 

  

Jyotika,

Soulds like part of your transaction is timing out
(e.g. profile limit exceeded, etc...). Are you using
MTS connections?

What version of Oracle? Are the transactions being
pushed synchronously or asynchronously? I recommend
using a dedicated server connection for the connect
string used by the dblinks involved in replication.

HTH,

-- Anita

--- Jyotika Bhandarkar <[Email Address Removed] wrote:
> Hi,
>
> My application keeps encountering oracle errorcode
> - ORA-02055. This
> is invariably followed by ORA-02067.
> Just an FYI - The application runs against a
> database which is
> replicated (using Oracle8i's Multi-Master
> replication). It makes around
> 40 oracle connections at startup. So it is possible
> that a number of
> these connections could be catering to different
> distributed
> transactions at any given point of time.
>
> What causes oracle to give this error code
> (ORA-02055) ? Could it be
> a oracle configuration issue ?
>
> Can anybody help ?
>
> Thanks in advance
> Jyotika
>
>
*********************************************************
> Disclaimer
>
> This message (including any attachments) contains
> confidential information intended for a specific
> individual and purpose, and is protected by law.
> If you are not the intended recipient, you should
> delete this message and are hereby notified that
> any disclosure, copying, or distribution of this
> message, or the taking of any action based on it,
> is strictly prohibited.
>
>
*********************************************************
> Visit us at http://www.mahindrabt.com
>
> --------
> Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to
> oracledba-[Email Address Removed] To subscribe: send a blank email to
> oracledba-[Email Address Removed] Visit the list archive:
> http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>


__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
Oracle LazyDBA home page