installation of apm database fails in Oracle database server

Products

• CA Application Performance Management (APM / Wily / Introscope)

Issue/Introduction

During the fresh install of the APM database schema in Oracle database server, installation fails with error messages.

Schema creation failed

The detail error messages will be saved in

<EM-Install-Director>\install\schematools.log

In schematools.log, following ERROR are seen.

Sql error in file: createtables-oracle-10.8.0.0.sql

java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object

Cause

it looks like some other object/process already using some database items which looks like related to this Oracle/schema.

Resolution

Completely delete the schema that may have been created.

Stop all EMs that is connecting to this Oracle/schema.

Start the install again and install new schema.