How to resume Oradbi.exe for CCB 2.4 SP3 in case of any database upgrade failure (Doc ID 2116069.1)

Last updated on MARCH 15, 2016

Applies to:

Oracle Utilities Customer Care and Billing - Version 2.4.0.3.0 to 2.4.0.3.0 [Release 2.4]
Information in this document applies to any platform.

Goal

On the SP3 CCB database upgrade, if for some reason an error has been encountered and warrants a restart of the upgrade, error may reported like:
ERROR: ORA-25188: cannot drop/disable/defer the primary key constraint for index-organized tables or sorted hash cluster (DBD ERROR: OCIStmtExecute) occured while executing ALTER TABLE C1_LEAD_EVT_STEP_K DROP PRIMARY KEY CASCADE
 

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