| ORA-2 5 2 2 6: Advanced queue related problem, urgent, pls help. [message #45162] |
Tue, 17 February 2004 15:45 |
Julia
Messages: 30
Registered: December 1999
|
Member |
|
|
9.2.0.3.0 on solaris.
The application is using AQ. I took a full export of the db. after the app finished their test, they ask me to restore the exported data back. So I dropped two related schemas, and imported the two schema in a user mode. everything seems went perfect with all the tables/data and priviledges. but seems like the app is having a problem with the 'dequeue' from their java application with error log like below:
2004-02-17 17:10:39,343 [[main]] ERROR - 1 - 1001 - Messaging-1001 has occurred (null) - Unab
le to dequeue a message, check the configuration of your queues and confirm that they exist
in the database. Exception Messaging-1001 has occurred (null) (
Inner Exception: oracle.jms.AQjmsException: JMS-120: Dequeue failed
Inner Exception: java.sql.SQLException: ORA-25226: dequeue failed, queue THEXSEM.FT_Q_LISTE
N is not enabled for dequeue
ORA-06512: at "SYS.DBMS_AQIN", line 263
ORA-06512: at line 1
).
2004-02-17 17:10:39,345 [[main]] ERROR - 1 - 1001 - Messaging-1001 has occurred (null) - Unable to dequeue a message, check the configuration of your queues and confirm that they exist
in the database. Exception Messaging-1001 has occurred (null) (
Inner Exception: oracle.jms.AQjmsException: JMS-120: Dequeue failed
Inner Exception: java.sql.SQLException: ORA-25226: dequeue failed, queue THEXSEM.FT_Q_LISTEN is not enabled for dequeue
ORA-06512: at "SYS.DBMS_AQIN", line 263
ORA-06512: at line 1
).
Since the instance has been shutdown once before the import and plus the schema has be dropped, do I or the application need some sort of efforts to get the job queue started or as oracle mentioned for ORA-25226, need to start_queue? but I thought the app should be knowing that if so.
thanks for any insight, appreciated,
julia.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
