APM 10.7 Oracle Database Upgrade fails with "Upgrade Database Schema Failed"

Products

• CA Application Performance Management Agent (APM / Wily / Introscope)
• CA Application Performance Management (APM / Wily / Introscope)
• INTROSCOPE
• DX Application Performance Management

Issue/Introduction

Trying to build a new APM 10.7 environment.

Want to use an existing Oracle 12c database instance  with a new APM Database Scheme in it.

Selecting "Database Only Option" and "Upgrade schema or Create Schema" the installation fails on APM Database:

 

Upgrade Database Schema Failed
                          Status: ERROR
                          Additional Notes: ERROR - . Check /opt/ca/Introscope_10.7/install/schematools.log for more details

No schematools.log is created either. 

Cause

 Insufficient Oracle User privileges to run using UI. 

Environment

APM 10.7 

Oracle 12C

Linux 

Resolution

Run the Schema creation manually off from Introscope Oracle database Scripts , OS folder. 

 

cd <EM_Home>/install/database-scripts/unix

./createschema.sh -databaseName IOWILYL -databaseType Oracle -host test-brcm.cabrcm.com -user BRCMOWNER -password "[email protected]&56" -port 1524 -releaseVersion 10.7 -scriptsDir /opt/ca/Introscope/install/oracle/database-scripts/>/tmp/createschema.log

 

 

Note: Per Oracle ,put the password in double quotes. 

 

Additional Information

Create the APM Database Schema Manually