OSM Upgrade Failed - Version 7.2.4 To 7.3 "ORA-00955: name is already used by an existing object sql: CREATE TABLE om_$install$plan" (Doc ID 2054460.1)

Last updated on JANUARY 12, 2016

Applies to:

Oracle Communications Order and Service Management - Version 7.3.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Upgrade of OSM from version 7.2.4 to 7.3 failed
Below is an extract from the logs,

BUILD FAILED
/opt/OSM/Database/dbinstall/install/instplb.xml:47: oracle.communications.ordermanagement.install.db.plan.InstallActionException: com.mslv.install.db.util.DbManagerException: ORA-00955: name is already used by an existing object
sql: CREATE TABLE om_$install$plan(
  plan_id number(9) NOT NULL,
  from_version varchar2(60 char) NOT NULL,
  version varchar2(60 char) NOT NULL,
  status varchar2(30) NOT NULL,
  start_ts timestamp(6),
  end_ts timestamp(6))
TABLESPACE LARGE_DATANested Exception: ORA-00955: name is already used by an existing object

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms