Getting "ORA-00955: name is already used by an existing object" ERROR on server start-up after dropping jUDDI database tables used by SOA-P instance

Solution Verified - Updated -

Issue

  • As part of the instructions [1] to clean the jUDDI tables created by SOA-P installations, all the tables whose name start with j3 were dropped from the Oracle Database schema used by the SOA-P instance. However, When the SOA-P node is started, it gives the below exception. It seems the jUDDI registry is not created successfully. How to fix this issue and ensure that the SOA-P server creates the jUDDI database tables cleanly?
ERROR [org.jboss.kernel.plugins.dependency.AbstractKernelController] (main) Error installing to Start: name=jboss.esb:service=JUDDIDatabaseInitializer state=Create mode=Manual requiredState=Installed
java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object
...

[1] How to clean up the jUDDI Registry in Red Hat JBoss SOA-P?

Environment

  • Red Hat JBoss SOA Platform (SOA-P)
    • 5.3.x
  • Oracle Database
    • 11g R2
    • 10g R2

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In