Unable to drop Oracle schema 10.7 SP1

book

Article ID: 106287

calendar_today

Updated On:

Products

APP PERF MANAGEMENT CA Application Performance Management Agent (APM / Wily / Introscope) CUSTOMER EXPERIENCE MANAGER INTROSCOPE

Issue/Introduction

After a clean APM 10.7 installation, we tried cleaning up the Oracle schema. 

./dbdrop.sh -databaseName xxxx -databaseType Oracle -host x.y.z.t -port xxxx -user xxxx -password xxxx -releaseVersion 10.7.0.0 -scriptsDir /introscope/product-10.7/install/oracle/database-scripts/ 

[INFO] [main] [root] [DropSchema] - DBDetails: hostName: x.y.z.t port: xxx databaseName: xxxx user: xxx 
[INFO] [main] [root] [DropSchema] - DBType: Oracle 
[INFO] [main] [root] [DropSchema] - Release Version: 10.7.0.0 
[INFO] [main] [root] [DropSchema] - Scripts location: /introscope/product-10.7/install/oracle/database-scripts/ 
[ERROR] [main] [root] [DropSchema] - No Major release version found from the given releaseVersion - 10.7.0.0 

Scripts are in the folder /introscope/product-10.7/install/oracle/database-scripts/ 

APM schema version in Oracle 

SQL> select ts_db_versions from ts_domains; 

TS_DB_VERSIONS 
-------------------------------------------------------------------------------- 
10.7.0.0 

The same command with an APM 10.5.2 works
 

Cause

When dropping the schema, the APM10.7 version was not seen in the list. This caused it to error out stating that there was no major release version found.

 

Environment

Release: MSPAPJ99000-10.7.0-Application Performance Mgmt-Java and .NET Agent-MSP
Component:

Resolution

This is fixed in  APM 10.7.0 SP2.