My Oracle Support Banner

MPS1 Upgrade Creating ORA-30036 Error (Doc ID 2098345.1)

Last updated on MARCH 29, 2019

Applies to:

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


On : version, Upgrade

User is upgrading the system from brm 7.5PS1 to 7.5PS13. While running PS13 Database upgrade script it had struck at update_bill_closed_t.source executed for 2-3 hours and failed

Installed the patch 21881008 and also followed the steps provided in note [Execution of Database Upgrade Perl Script Stuck While Executing update_bill_closed_t.source (Doc ID 2061023.1)] and readme also.

and re-run the upgrade script but it stuck at same step update_bill_closed_t.source and failed with same below Error :


1. Few times this sql "ALTER TABLE bill_t_new DROP COLUMN closed_t" took 20+ hours and failed.

2. bill_t and item_t contain 623 million rows.

The issue can be reproduced at will with the following steps:
1. Run PS13 Database upgrade script




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.