Running the Database Schema Upgrade Script For PatchSet 2 (PATCH 9254093) Fails

(Doc ID 1070937.1)

Last updated on SEPTEMBER 24, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.4.0.0.0 to 7.4.0.1.0 [Release 7.4.0]
Information in this document applies to any platform.
Checked for relevance on 19-Oct-2011.
Checked for relevance on 01-Oct-2013

Goal

After a fresh install of BRM 7.4, we installed <Patch 8943067> successfully. We then installed PatchSet 2 (<Patch 9254093>).

The install of the 'bin' file was successful but when we tried upgrading the database schema as written in the install documentation of the patch, it failed.

We followed every step but running 'pin_upgrade_74ps2.pl' always fails.
The error message in the 'tmp.out' file is as follows:-

Executing sqlplus -s pin/pin_brm_2009@OCVTBRD1 < "/opt/portal/7.4/tmp/tmp.sql"
DECLARE
*
ERROR at line 1:
ORA-20001: INDEX CREATION FAILED FOR i_au_coll_action_created__id ORA-01408:
such column list already indexed
ORA-06512: at line 28
ORA-01408: such column list already indexed


Why is this?

Solution

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