OMS Upgrade Fails At Repository Configuration With Error ORA-20251
Yesterday, one of my blog readers asked me how I didn’t encounter ORA-20251 error when upgrading my EM12c to EM13c. He also pointed My Oracle Support document (Doc ID 2095025.1). The document says a new record will be inserted into EM_COST_CENTERS table (in fact the table name is EM_COST_CENTERS_E but it’s not important) for all users whose department value is not blank during the upgrade. If there are more than one records with blank cost center then the second record will be considered as duplicate, resulting in the above error during the repository configuration.
Here’s the sample output:
1 2 3 4 5 6 7 8 9 10 |
INFO: oracle.sysman.top.oms:Failure… INFO: oracle.sysman.top.oms:1 error(s) happened in performing the action: INFO: oracle.sysman.top.oms:1): ORA-20251: Cost Center already Exists : : ORA-06512: at “SYSMAN.EM_COST_CENTER”, line 147 ORA-06512: at “SYSMAN.EM_COST_CENTER”, line 209 ORA-06512: at “SYSMAN.EM_COST_CENTER”, line 266 ORA-06512: at “SYSMAN.EM_COST_CENTER”, line 436 ORA-06512: at line 64 File:…/cost_center/cost_center_data_upgrade.sql |
I asked my reader to examine the EM users and he said there are not any EM users whose department value is not blank. So today, I examined the upgrade script and see that it’s not just about the department value. The upgrade scrip also tries to insert new “cost center” records for the users whose Line of business value is not blank.