OraFAQ Forum: Streams & AQ » Enqueue when the db down

Home » Server Options » Streams & AQ » Enqueue when the db down

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Enqueue when the db down [message #271134]

Sat, 29 September 2007 22:33

hidnt
Messages: 2
Registered: September 2007

Junior Member

Hi there,

I'm able to get my AQ to work between two dbs. However, when one the database is down and the other database is enqueue a message. Since the database is down I thought the message would stay in the queue until the the second database is up and able to dequeue the message. Somehow, the message didn't stay in the queue. Is that anything I'm missing? Noted, I'm using db link.

Thanks

Report message to a moderator

Re: Enqueue when the db down [message #271146 is a reply to message #271134]

Sun, 30 September 2007 01:44

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

It depends on what you did.
So post what you did along with you Oracle version (4 decimals).
Please read and follow OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format. Use the "Preview Message" button.
Please always post your Oracle version (4 decimals).

Regards
Michel

Report message to a moderator

Re: Enqueue when the db down [message #271192 is a reply to message #271146]

Sun, 30 September 2007 12:58

hidnt
Messages: 2
Registered: September 2007

Junior Member

Hi Michael,

I'm new using this forum or any forums. My db version 10.2.0.2.

From my source db I enqueued the message while the target db is down. From my understand of AQ, I thought the message would stay in the queue until the target db is up.

1)exec enqueue_msg( 'FAILED', '<HOSTNAME>' );

My main question is when I enqueue a message while the target db down. What's to the message? Right now, it doesn't get queue. I have to enqueue again. Do I need to enqueue the message again when the target db is up? Is a method that I don't have too.

I'm using dblink as my target db.

Dave

Report message to a moderator

Previous Topic:	error in database link during propagation
Next Topic:	ddl changes - source & target schema name are diff

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 11 17:27:12 CST 2024