Problem:
Jboss Server does not start up due to ORA-00955: name is already used by an existing object
The server.log file shows the following message:
INFO [ims.Main] (ServerService Thread Pool -- 115) * Startup Step 1 : Attempting to start ServiceLocator.
ERROR [ims.tmt.CreateDatabaseSchema] (ServerService Thread Pool -- 115)
Error in creating Task Persistence database schema.: java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object
Environment:
CA Identity Manager 12.6.06.0.214
JBoss EAP 6.3.0.GA
jdk1.7.0_71
Oracle Database
Cause:
Persistence Database tables are created when you start the application Server (jboss)
The problem was caused after deploying new JAR files to do some tests.
Resolution:
1. Identify which table is trying to create during Jboss starting up.
For example: the tables appear similar to the following text:
TMP_BULKLOADER12_5
ARCHIVE_TMP_BULKLOADER12_5
2. Delete those tables names from the database.
3. The same tables will be created based on the JAR file during the Jboss service startup.
Additional Information :
For MSSQL, Determine Which Queries Are Holding Locks
https://technet.microsoft.com/en-us/library/bb677357(v=sql.110).aspx
For Oracle , How to see lock on table and query?
https://community.oracle.com/thread/1034701?tstart=0
For further details, please refer to your MSSQL or your Oracle Database Documentation.