ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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


Article ID: 196610


Updated On:


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


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. 


 Insufficient Oracle User privileges to run using UI. 


APM 10.7 

Oracle 12C



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


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

./ -databaseName IOWILYL -databaseType Oracle -host -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