Installing Oracle OSM 7.5 on existing database 19c
We have followed below steps:-
- New database instance created
- Export done of existing database instance (19c) which is currently supporting Oracle OSM 7.4
- After step 2, Import is performed to new database instance created in step 1
- While installing Oracle OSM 7.5 on this newly imported database instance ( step 1+step3) - we are getting below error while running
To install the OSM DB schema, run the following command:
$ $OSM_INSTALLER_HOME/scripts/configDB.sh -n osm_env_name -c $OSM_CFG_HOME -
l $OSM_INSTALLER_HOME
ERROR:-
2, 27, om_dev1, type, om_t_audit_purge_order, om_t_audit_purge_order, , , create, , , FAILED, 2024-12-31 09:35:51.621, 2024-12-31 09:35:51.63, com.oracle.communications.semele.DbManagerException: java.sql.SQLException: ORA-02303: cannot drop or replace a type with type or table dependents