Got the following error during the latest step the EM13.5 RU17 patching.
[Oct 3, 2023 8:17:46 AM] DB user name: sysman is used for db connection
[Oct 3, 2023 8:17:47 AM] Executing submit job ….
[Oct 3, 2023 8:17:48 AM] ORA-06533: Subscript beyond count
ORA-06512: at "SYSMAN.NZDT_ADD_OMS_JOB", line 36
ORA-06512: at line 1
Issue is that the system believe that the configuration is multiOMS when it is not. Indeed, the number of OMS has been reduced into this environment.
Solution is to delete the reference to the former OMS in the mgmt_oms_parameters and mgmt_emrep_oms_name tables
#1 Check these tables
select * from mgmt_oms_parameters; select * from mgmt_emrep_oms_name;
#2 Save their content
create table mgmt_oms_parameters_bkp as select * from mgmt_oms_parameters; create table mgmt_emrep_oms_name_bkp as select * from mgmt_emrep_oms_name;
#3 Run the datafix
delete from mgmt_oms_parameters where host_url='<oldOMS>:4889_Management_Service'; commit; delete from mgmt_emrep_oms_name where oms_name='<oldOMS>:4889_Management_Service' commit;