Cannot Start DevTest Registry Due To Error: ORA-00955- no current activation was found in the local

Document ID : KB000105889
Last Modified Date : 10/07/2018
Show Technical Document Details
Issue:
Trying to install DevTest 10.1. The enterprise dashboard successfully installed, but the registry cannot be started.  We are seeing the below error in Registry logs.

2018-07-05 20:17:49,822Z (15:17) [main] ERROR System.err                     -
2018-07-05 20:17:49,822Z (15:17) [main] ERROR System.err                     - The Enterprise Dashboard Server at 'http://<EDhost>:1506'
2018-07-05 20:17:49,822Z (15:17) [main] ERROR System.err                     - could not be contacted, and no current activation was found in the local
2018-07-05 20:17:49,822Z (15:17) [main] ERROR System.err                     - activation cache for this registry.
2018-07-05 20:17:49,829Z (15:17) [main] ERROR System.err                     -
2018-07-05 20:17:49,829Z (15:17) [main] ERROR System.err                     - This registry will not be allowed to start until it can be activated by a
2018-07-05 20:17:49,829Z (15:17) [main] ERROR System.err                     - valid Enterprise Dashboard Server.


We were also seeing database related errors in the registry logs.

com.mchange.v2.c3p0.impl.NewPooledConnection - com.mchange.v2.c3p0.impl.NewPooledConnection@36fe2a56 handling a throwable.
java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)
Environment:
All supported DevTest Environments
Cause:
The error is because the table already exists in the database. There might be some constrains that still remained in the existing database. 


 
Resolution:
Create a clean Schemas for Registry database or if you are using an existing database make sure all tables are dropped and no constrains remain.   Ensure that the character set of the Oracle database supports Unicode. In addition, for the initial creation of the database, the Oracle user must have the CREATE VIEW system privilege. Without this privilege, the following error might be generated during installation: Schema creation failed: ORA-01031: insufficient privileges.