Re: Problem with DBlinks

From: Michael Marsden <michael.marsden_at_247media.com>
Date: Thu, 14 Sep 2000 12:04:13 +1000
Message-ID: <8pp899$fa1$1@nina.pacific.net.au>

Hi,

This sounds similar to a problem I recently encountered (which is apparently fixed in 8.1.7)
Reference to Note 116541.1 on Metallink.

Try adding the following to your init.ora file and bouncing the DB.

#
#  To solve bug #75713.1
#               Event 10127 disables the use of remote query blocks
#               Event 10176 disables the remote colocated joins
#
event                           = "10127 trace name context forever, level 1

: 10176 trace name
 context forever, level 1"

Cheers,
Michael

"H. Clare" <hclare_at_pharma.fraser-williams.com> wrote in message news:8pleri$jlu$1_at_gxsn.com...
> Hi,
>
> we've got a problem with inserting over a database link,
> The two databases are both 8.1.5, the insert is a single line insert
> (although it is part of a much larger process).
>
> The whole process seems to stop when it gets to an insert over the
 database
> link, only recoverable by shutting down the database with abort.
>
> Any suggestions as to why this might be? I've checked all of the v$ views
> for locks (the ones I know of anyway) and there doesn't seem to be a
 problem
> in that area.
>
> Cheers...
>
>
>
Received on Wed Sep 13 2000 - 21:04:13 CDT