Re: ORA-2042

From: Joel Garry <joel-garry_at_home.com>
Date: 14 Apr 2004 17:05:51 -0700
Message-ID: <91884734.0404141605.2febcb0f@posting.google.com>

"Roger" <roger.sjolin_at_telia.com> wrote in message news:<uBefc.89698$dP1.268587_at_newsc.telia.net>...
> Hi
> When I do a query "select ....." from my database several times for instance
> 12000 times I got error 2042 during query nr 150 and 9000 but all other
> times it works fine.
> Whats the problem? The select query contains 15 different fields and every
> query return 5-1500 rows.
> Thanks in advance

Upgrade.

$ oerr ora 2042
02042, 00000, "too many distributed transactions"

// *Cause: the distributed transaction table is full, because too many
//      distributed transactions are active.
// *Action: increase the INIT.ORA "distributed_transactions" or run
fewer
//      transactions.  If you are sure you don't have too many
concurrent
//      distributed transactions, this indicates an internal error and
support
//      should be notified.  Instance shutdown/restart would be a

work-around.

http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76961/ch144.htm#2404

Don't forget to post version/platform information with questions.

jg

--
@home.com is bogus.
http://sun.soci.niu.edu/~rslade/bkcvp2.htm

Received on Wed Apr 14 2004 - 19:05:51 CDT