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

Article Id: 196610
Status: Published
Updated On: 18-08-2020 05:40
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