This document has not been formally reviewed for accuracy and is provided "as is" for your convenience.
Summary
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##.