MPS1 Upgrade Creating ORA-30036 Error
Last updated on OCTOBER 03, 2017
Applies to:Oracle Communications Billing and Revenue Management - Version 184.108.40.206.0 to 220.127.116.11.0 [Release 7.5.0]
Information in this document applies to any platform.
On : 18.104.22.168.0 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
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