When using the silent install process to upgrade just the Oracle APM Database what properties need to be set in the response file.

Document ID : KB000010061
Last Modified Date : 08/08/2018
Show Technical Document Details
Introduction:

When using the silent install process to upgrade just the Oracle APM Database what properties need to be set?

Environment:
APM 9.x, 10.x
Instructions:

The following properties need to be set:

silentInstallChosenFeatures=Database

shouldUpgrade=true

chosenDatabaseIsOracle=true

upgradeSchema=true 

useExistingSchemaForOracle=false

oracleDbHost

oracleDbPort

oracleDbSidName

oracleDbUsername

oracleDbPassword

 

Note in particular the 2 highlighted properties:

For the schema upgrade the combination of "upgradeSchema=true" with "useExistingSchemaForOracle=false" is required.

If useExistingSchemaForOracle is not explicitly set it will default to true which will cause the installer to try to recreate tables in the existing schema instead of upgrading them. In the default supplied SampleResponseFile.Introscope.txt file useExistingSchemaForOracle is explicitly set to false.

Additional Information:

https://docops.ca.com/ca-apm/10-7/en/installing/apm-installation/launch-the-installer