OEM 13.5C Installation stuck at 54% at Repository Configuration due to locked statistics in sysman schema
Posted by Mir Sayeed Hassan on August 27th, 2023
OEM 13.5C Installation stuck at 54% at Repository Configuration due to locked statistics in sysman schema
<OMS_HOME>/cfgtoollogs/cfgfw/CfmLogger.log
INFO: oracle.sysman.top.oms:Still Running...
INFO: oracle.sysman.top.oms:Still Running...
Issue happens if locked statistics in sysman schema occur in database.
Verify using below SQL.
SQL> select stattype_locked FROM dba_tab_statistics WHERE owner = 'SYSMAN';
Solution
To fix this issue unlock schema statistics and run gather stats in another session connecting to repository when EM Install stuck.
Connect to Repsitory DB as sysman:
SQL> EXEC DBMS_STATS.unlock_schema_stats('SYSMAN');
SQL> EXECUTE DBMS_STATS.GATHER_SCHEMA_STATS(ownname => 'SYSMAN');
The installation will resume after unlocking schema stats and completed successfully without any issues.
====Hence tested & verified in our test env====