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=
The way I read your requirements is that you want a local program to comple=
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.

-----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,
> The problem is that Oracle is still holding the update to the remote
> database open.  Try the following:
> You could also look at using savepoints.  Nick had a good idea also about
> looking at Advanced Queueing.
> Tom
> -----Original Message-----
> Hi All,
> 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.

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


Other related posts: