Control-M/Enterprise Manager upgrade to 9.0.21.000 from 9.0.19.200 completed successfully but got ORA-00054 error in the install log.

SCA microservice is not able to start with ORA-00904 error in the maint_diag* log.
Error:
06/05/2023 23:18:25.208 [2] hadatahandler HADataHandler::GetFromDiskIsActiveKafkaCluster Reader not valid: DL_STAT_ERR_EXEC_QUERY
06/05/2023 23:18:25.208 [1] tcomponentselector TComponentSelector::HandleSCA Failed to get list of Kafka cluster machines.
06/05/2023 23:18:35.212 [1] emdb EMDB::DLDBErrorHandlerImp errorCode = -9
06/05/2023 23:18:35.212 [1] emdb EMDB::DLDBErrorHandlerImp message  = DL_STAT_ERR_EXEC_QUERYsql, code:904, state: 42000-java.sql.SQLSyntaxErrorException: ORA-00904: "INTERFACE_ADDRESS": invalid identifier
06/05/2023 23:18:35.212 [1] emdb EMDB::DLDBErrorHandlerImp vendorMessage1 = java.sql.SQLSyntaxErrorException: ORA-00904: "INTERFACE_ADDRESS": invalid identifier
06/05/2023 23:18:35.212 [1] emdb EMDB::DLDBErrorHandlerImp isSql  = 1
06/05/2023 23:18:35.212 [1] emdb EMDB::DLDBErrorHandlerImp vendorError1 = 904
06/05/2023 23:18:35.212 [1] emdb EMDB::DLDBErrorHandlerImp This thread stack:

In the EM install log, ORA-00054 error was found.
Error:
[06@18:18:57.286:] :  [CON:1] SQL> DECLARE
num_rows integer;
BEGIN
Select count(*) into num_rows
from user_tab_cols
where column_name = 'SITE_NAME'
and table_name = 'MFT';
if (num_rows = 0) then
execute immediate 'ALTER TABLE MFT ADD
(SITE_NAME  varchar(40)    null,
GATEWAY_ADDRESS   varchar(255)   null)';
end if;   
END;
.
[06@18:18:57.286:] :  dald[5] setFetchSize,DLStatement.cpp:443 Setting fetch size to 100.
[06@18:18:57.590:] :  dald[0] showJavException,DBCommon.cpp:139 Exception occurred: 
Source native location: execute,DLStatement.cpp:241; 
.
[06@18:18:57.590:] :  dald[0] showJavthrowable,DBCommon.cpp:16 Cause.
[06@18:18:57.590:] :  dald[0] showJavthrowable,DBCommon.cpp:23 java.sql.SQLException: ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
ORA-06512: at line 9
 

It is recommended to raise a RFA to the R&D for further investigation.

Below are the steps that is provided to resolve this issue.
- Run command to backup the mft table: create table mft_backup as select * from mft;
- Run these command to fix the MFT Table:  
>> ALTER TABLE MFT ADD SITE_NAME varchar(40) null;
>> ALTER TABLE MFT ADD (GATEWAY_ADDRESS varchar(255) null);
>> ALTER TABLE CONFIG_HA ADD (INTERFACE_ADDRESS varchar(256) null);

- Run these command to add the data to the missing coloumn in config_ha: 
em /sft/controlm/ctm_em/bin/bmcpython /sft/controlm/ctm_em/services/bin/apache_kafka_config.py config --setDbDefaultInterfaceAddress
em /sft/controlm/ctm_em/bin/bmcpython /sft/controlm/ctm_em/services/bin/apache_kafka_config.py sync

- Restart SCA service