APM Failed to create DB schema oracle 19C

  • KM03813652
  • 11-Jun-2021
  • 11-Jun-2021

This document has not been formally reviewed for accuracy and is provided "as is" for your convenience.

Summary

at configuration wizard, got failed message when creating new schema in Oracle 19C

Question

Failed to create APM schema when running configuration wizard:

- Oracle 19 C

- Customer created DB as container DB

 

Answer

 

- Checking configserver_all.log, make sure you see the error like below:

ERROR - Task execution failed
com.mercury.infra.flowmngr.exceptions.JavaTaskInstantiationException: Failed to instantiate java task com.mercury.topaz.setmanagementdb.dbimplementation.ManagementSchemaTask
 at com.mercury.infra.flowmngr.model.JavaTask.execute(JavaTask.java:89)
 at com.mercury.infra.flowmngr.model.Step.executeStep(Step.java:79)
 at com.mercury.infra.flowmngr.FlowManager.run(FlowManager.java:206)
 at com.mercury.infra.wizard.WizardController$FlowManagerRunner.doInBackground(WizardController.java:87)
 at com.hp.acm.swing.executor.SwingJob$SwingJobWorker.doInBackground(SwingJob.java:319)
 at javax.swing.SwingWorker$1.call(SwingWorker.java:295)
 at java.util.concurrent.FutureTask.run(FutureTask.java:266)
 at javax.swing.SwingWorker.run(SwingWorker.java:334)
 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
 at java.lang.Thread.run(Thread.java:748)
Caused by: com.mercury.infra.db.exceptions.DBException: Failed creating Oracle database 'APMMGDB'
 at com.mercury.infra.db.operations.OracleDatabaseCreator.createDatabase(OracleDatabaseCreator.java:52)
 at com.mercury.topaz.dbverify.creator.SchemaBuilderImpl.createOracleDatabase(SchemaBuilderImpl.java:367)
 at com.mercury.topaz.dbverify.creator.SchemaBuilderImpl.createSchema(SchemaBuilderImpl.java:97)
 at com.mercury.topaz.dbverify.creator.SchemaBuilderImpl.createSchema(SchemaBuilderImpl.java:81)
 at com.mercury.topaz.dbverify.creator.GenericSchemaBuilder.createSchema(GenericSchemaBuilder.java:103)
 at com.mercury.topaz.setmanagementdb.dbimplementation.ManagementSchemaTask.execute(ManagementSchemaTask.java:58)
 at com.mercury.infra.flowmngr.model.JavaTask.execute(JavaTask.java:79)
 ... 10 more
Caused by: java.sql.SQLException: [mercury][Oracle JDBC Driver][Oracle]ORA-65096: invalid common user or role name

 

Solution:

To create user in Oracle conatiner DB we need to add prefix C##.