Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Trigger gets disabled, why?
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