| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
