Forum Stats

  • 3,782,577 Users
  • 2,254,668 Discussions
  • 7,880,129 Comments

Discussions

ORA-02289: sequence does not exist

Hi All,

I'm getting the following error during ESB startup. Any pointers on resolving?

Environment: SOA 10.1.3.3 MLR15 (HA - 2 nodes); Oracle RAC DB (10.2.0.3)

09/01/20 13:01:20 oracle.tip.esb.server.dispatch.QueueHandlerException: Error creating "ORA-02289: sequence does not exi
st
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 5751
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_AQJMS", line 129
ORA-06512: at line 1
"

09/01/20 13:01:20 at oracle.tip.esb.server.dispatch.JMSDequeuer.createConnection(JMSDequeuer.java:527)
09/01/20 13:01:20 at oracle.tip.esb.server.dispatch.JMSDequeuer.<init>(JMSDequeuer.java:116)
09/01/20 13:01:20 at oracle.tip.esb.server.dispatch.agent.ESBAgentListener.createProcessor(ESBAgentListener.java:1
47)
09/01/20 13:01:20 at oracle.tip.esb.server.dispatch.agent.ESBAgentListener.performWork(ESBAgentListener.java:125)
09/01/20 13:01:20 at oracle.tip.esb.server.dispatch.agent.ESBAgentListener.performWork(ESBAgentListener.java:112)
09/01/20 13:01:20 at oracle.tip.esb.server.dispatch.agent.ESBAgentListener.start(ESBAgentListener.java:94)
09/01/20 13:01:20 at oracle.tip.esb.server.common.RuntimeESBSystem.start(RuntimeESBSystem.java:239)
09/01/20 13:01:20 at oracle.tip.esb.common.system.SystemFactory.startSystemsForCluster(SystemFactory.java:105)
09/01/20 13:01:20 at oracle.tip.esb.server.bootstrap.RuntimeResourceAdapter.startListenersForSystems(RuntimeResour
ceAdapter.java:105)
09/01/20 13:01:20 at oracle.tip.esb.server.bootstrap.RuntimeResourceAdapter.startListeners(RuntimeResourceAdapter.
java:95)
09/01/20 13:01:20 at oracle.tip.esb.server.bootstrap.ESBBaseResourceAdapter.startESBListeners(ESBBaseResourceAdapt
er.java:605)
09/01/20 13:01:20 at oracle.tip.esb.server.bootstrap.ESBBaseResourceAdapter.setupRuntime(ESBBaseResourceAdapter.ja
va:373)
09/01/20 13:01:20 at oracle.tip.esb.server.bootstrap.ESBBaseResourceAdapter.initializeESB(ESBBaseResourceAdapter.j
ava:325)
09/01/20 13:01:20 at oracle.tip.esb.server.bootstrap.ESBBaseResourceAdapter$PingTester.run(ESBBaseResourceAdapter.
java:886)
09/01/20 13:01:20 at oracle.j2ee.connector.work.WorkWrapper.runTargetWork(WorkWrapper.java:242)
09/01/20 13:01:20 at oracle.j2ee.connector.work.WorkWrapper.doWork(WorkWrapper.java:215)
09/01/20 13:01:20 at oracle.j2ee.connector.work.WorkWrapper.run(WorkWrapper.java:190)
09/01/20 13:01:20 at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:814)
Tagged:
This discussion has been closed.