Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Trigger gets disabled, why?

Re: Trigger gets disabled, why?

From: Fred Stojentin <stojentin_at_orgdv.din.de>
Date: Fri, 18 Jun 1999 10:37:43 GMT
Message-ID: <376a1ff6.3448356@news.cis.dfn.de>


On Wed, 16 Jun 1999 12:14:25 -0600, "Terry Dykstra" <tdykstra_at_cfol.ab.ca> wrote:

>I have triggers on a table that copy inserted, updated records to another
>database through a database link. Every few weeks these triggers somehow
>get disabled. Both databases are always shutdown, started up every night in
>the same script. These are production databases. No development is being
>done, no table changes or anything like that. Any suggestions why this
>happens? I'm running Oracle 7.3.4.3.0 on NT.
>
>--
>Terry Dykstra
>Canadian Forest Oil Ltd.
>
>

Hi,
take a look at dbs_2pc_pending and dba_2pc_neighbors, are there any pending transactions via the db link? The problem could be, that the triggers are invalid because of a db link which is not actually available, when a transaction need it in the prepare phase of 2pc (two phase commit).

 Look at the script
   $ORACLE_HOME/rdbms/admin/dbmsutil.sql for a quick explanation of 2pc and the states the transaction across more then one database can have.

Fred Stojentin Received on Fri Jun 18 1999 - 05:37:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US