Home » Server Options » Streams & AQ » Deqeueing is not progressing after a RAC instance fails
Deqeueing is not progressing after a RAC instance fails [message #352218] Mon, 06 October 2008 11:59
rolex.mp
Messages: 161
Registered: February 2007
Senior Member
I am using Oracle 10.2.0.1 on Solaris 10.

The database is a RAC database and JMS queues are used by the application.
The connection string for the queues is like
jdbc:oracle:thin:@(description=(address_list=(address=(HOST=db1-vip.test.com)(protocol=tcp)(port=1521))(address=(HOST=db2-vip.test.co m)(protocol=tcp)(port=1521))(load_balance=yes)(failover=yes))(connect_data=(service_name=SRV.test.com))) "

The queue tables are created similar to this

dbms_aqadm.create_queue_table (
queue_table =>'upd_qt',
queue_payload_type =>'SYS.AQ$_JMS_OBJECT_MESSAGE',
multiple_consumers => true,
compatible => '8.1.5'
);

The primary instance parameter is not specified so I suppose the default value 0 indicates any available instance. So if a instance fails hopefully dequeing should be done by the other instance which is not happening .

Dequeuing stops once the primary instance fails . The application does run by dequeing doesn't work.

I haven't worked on queues much ,any inputs or suggestions will be very helpful.

Thanks
Previous Topic: job for refreshing materialized view is failed
Next Topic: Do not want to loose any data after Apply process abort
Goto Forum:
  


Current Time: Thu Mar 28 06:14:28 CDT 2024