Posts

java.sql.SQLException: ORA-25226: dequeue failed

--------------------------error---------------------------- java.sql.SQLException: ORA-25226: dequeue failed, queue PRD_SOAINFRA.EDN_OAOO_QUEUE is not enabled for dequeue ORA-06512: at "SYS.DBMS_AQ", line 335 ORA-06512: at "PRD_SOAINFRA.EDN_DEQUEUE_OAOO_DELIVERY", line 14 ----------------------------------------------------------- Solution: begin  dbms_aqadm.start_queue(queue_name => 'PRD_SOAINFRA.EDN_OAOO_QUEUE'); end;  ----------------------------------------------------------- Verify: select owner,name,enqueue_enabled,dequeue_enabled from dba_queues where name = 'EDN_OAOO_QUEUE' order by 4; -----------------------------------------------------------
Post a Comment
Read more

Not able to start Listener on windows server.

--------------------------error---------------------------- C:\Users\ecm_admin>lsnrctl start LISTENER LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 30-AUG-2017 13:06 :27 Copyright (c) 1991, 2010, Oracle.  All rights reserved. Starting tnslsnr: please wait... TNS-12560: TNS:protocol adapter error  TNS-00530: Protocol adapter error  ----------------------------------------------------------- Solution:  --> run command prompt as --"run as administrator" then start listener -->  LSNRCTL START  done.
Post a Comment
Read more