Home » Developer & Programmer » JDeveloper, Java & XML » 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 #92044] Tue, 17 February 2004 15:50 Go to next message
Juila
Messages: 8
Registered: June 2003
Junior 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,
Re: ORA-2 5 2 2 6: Advanced queue related problem, urgent, pls help [message #92250 is a reply to message #92044] Wed, 05 May 2004 09:05 Go to previous message
Paolo
Messages: 6
Registered: February 2001
Junior Member
I'm the same problem and for us the solution are:
connect like dba to the DB
alter package SYS.ADBMS_AQIN compile;

I know that it's very very strange, but in our enviroment works...
I opend a tar in Oracle 2 years later but at this moment no solution...
Regards.
Previous Topic: How can i encoded XML Stream with Oracle procedure
Next Topic: Calling Oracle report from JDeveloper
Goto Forum:
  


Current Time: Tue Jul 27 23:41:46 CDT 2021