Exported an Oracle APM/CEM Database configuration and dropped the database using dbdrop.sh (.bat) script.
When trying to import the Database configuration using the same Oracle userid receives this error:
[ERROR] [main][ root] [ConfigImport] - Oracle Schema should be empty before importing.
The ConfigImport checks that the Oracle user does not own any objects by executing this SQL:
SELECT count(Object_type) from user_objects order by object_type;
The dbdrop.sh (.bat) script will only drop APM related objects so any other objects that still exist in the schema will cause ConfigImport to fail.
Request the DBA to verify the presence of the other schema objects and remove them to resolve the problem.
Release: CEMUGD00200-9.7-Introscope to CA Application-Performance Management-Upgrade Main