My Oracle Support Banner

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

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Communications Billing and Revenue Management - Version to [Release 7.4.0]
Information in this document applies to any platform.


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 '' 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"
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?


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.