Home » Server Options » Streams & AQ » ORA-2 5 2 2 6: Advanced queue related problem, urgent, pls help.
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.
Previous Topic: Streams Release Dates
Next Topic: No Capture: 1 way only -> Help needed
Goto Forum:
  


Current Time: Mon Dec 29 07:10:22 CST 2014

Total time taken to generate the page: 0.06537 seconds