RE: How to handle the exception when remote db is down

From: Nick Tilbury _at_ Northampton <_at_>
Date: Wed, 16 Feb 2005 15:06:19 -0000
Message-ID: <6FF46F566A6CE14B92CD5F67A1DA8E40FC3905@nthexch2k3.eu.vte.com>

AQ is messaging functionality for Non-Oracle databases AND Oracle database. The reason you need it in this case is to take away some admin/management a= ctivities.
The way I read your requirements is that you want a local program to comple= te
correctly regardless of the status of the remote database.

It therefore makes sense to make the part of your program that deals with t= he remote
database a two-phase one.

EG, (A) insert into the local table.=20
(B) enqueue an AQ message to be asynchronously picked up and pushed to the = remote DB.

Using AQ for the remote task means simple admin tasks like handling queue e= xceptions and=20
attempting retries can be taken care of.

Nick
-----Original Message-----
From: Sami Seerangan [mailto:dba.orcl_at_gmail.com] Sent: 16 February 2005 14:40
To: Mercadante, Thomas F; Nick Tilbury @ Northampton Cc: oracle-l_at_freelists.org
Subject: Re: How to handle the exception when remote db is down

Thomas and Nick, Thanks for your responses.

AQ is to propagate messages to and from non-Oracle messaging systems. Here I just interact with another oracle database thru distributed transaction. Why do I need AQ in this place?

On Wed, 16 Feb 2005 08:37:23 -0500, Mercadante, Thomas F <thomas.mercadante_at_labor.state.ny.us> wrote:
> Sami,
>=20
> The problem is that Oracle is still holding the update to the remote
> database open. Try the following:
>=20
> You could also look at using savepoints. Nick had a good idea also about
> looking at Advanced Queueing.
>=20
> Tom
>=20
>=20
> -----Original Message-----
> Hi All,
>=20
> I am trying to do DML activity on both local and remore DB. If the
> remote db is down, I need to insert the values into temporary table on
> the local db so that later when the remore db becomes available I can
> push the records.
>=20
>

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D
This message is intended solely for the use of the individual or organisati=
on to whom it is addressed.  It may contain privileged or confidential info=
rmation.  If you have received this message in error, please notify the ori=
ginator immediately.  If you are not the intended recipient, you should not=
 use, copy, alter, or disclose the contents of this message.  All informati=
on or opinions expressed in this message and/or any attachments are those o=

f the author and are not necessarily those of VarTecTelecom Europe Ltd or i= ts affiliates. VarTec Telecom Europe Ltd accepts no responsibility for loss=  or damage arising from its use, including damage from virus.=20

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Feb 16 2005 - 10:09:17 CST