RE: How to handle the exception when remote db is down
- From: "Nick Tilbury @ Northampton" <ntilbury@xxxxxxxxxxxx>
- To: "Sami Seerangan" <dba.orcl@xxxxxxxxx>, "Mercadante, Thomas F" <thomas.mercadante@xxxxxxxxxxxxxxxxx>
- Date: Wed, 16 Feb 2005 15:06:19 -0000
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@xxxxxxxxx]
Sent: 16 February 2005 14:40
To: Mercadante, Thomas F; Nick Tilbury @ Northampton
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
