Mir Sayeed Hassan – Oracle Blog

Oracle DBA – Tips & Techniques | Learn with real-time examples

  • Translate

  • It’s Me






  • My Certificates

  • Links

    My Acclaim Certification : Credly Profile
    My Oracle ACE Pro Profile

  • Achievements

    Awarded Top 100 Oracle Blogs from Worldwide - #RANK 39
  • VISITORS COUNT

  • Verified International Academic Qualification from World Education Service (WES)

    Verified International Academic Qualification from World Education Service (WES)

  • Jobs

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====