Upgrading an Existing OTM DB to 5.5.3 - Non-Partioned Option Used With Initial Install

(Doc ID 470877.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Transportation Management - Version: 5.5.02 and later   [Release: 5.5 and later ]
Information in this document applies to any platform.
***Checked for relevance on 08-Oct-2010***

Symptoms

-- Problem Statement:
Non-partitioning option selected when OTM 5.5.2 database was originally installed. Oracle partitioning is installed/enabled in the database. Some of the new OTM 5.5.3 database installations encountered error ORA-00959 when running dbpatch_55 script when non-partitioning option was selected. The solution in that case was to re-install with partitioning.

The dbpatch_55.sql was run to upgrade the non-partitioned OTM db to 5.5.3 and received the same
error as before which is "VISIBILITY_PIECE ORA-00959: tablespace 'PART_1' does not exist".  The
data in the current 5.5.2 database must be preserved when upgrading to 5.5.3.

-- Steps To Reproduce:
Run dbpatch_55 against OTM database to upgrade from 5.5.2 (installed with non-partitioning option)
to 5.5.3.

-- Business Impact:
Need verification that the proposed solution will preserve the integrity of the existing data.

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