The referenced database doesn't contain a valid management Repository.

 

OEM installation fails with below error during installation.

It is due to the previous installation failed and we did not cleanup repository.

Drop users :

SQL> DROP USER SYSMAN CASCADE;

User dropped.

SQL> DROP USER SYSMAN_MDS CASCADE;

User dropped.

SQL> DROP USER SYSMAN_STB CASCADE;

User dropped.

SQL> DROP USER SYSMAN_BIPLATFORM CASCADE;

User dropped.

SQL>

SQL> DROP USER SYSMAN CASCADE;

User dropped.

SQL> DROP USER SYSMAN_MDS CASCADE;

User dropped.

SQL> DROP USER SYSMAN_STB CASCADE;

User dropped.

SQL> DROP USER SYSMAN_BIPLATFORM CASCADE;

User dropped.

SQL>

REMOVE SYNONYMS OF SYSMAN USER.

DECLARE

  CURSOR l_syn_csr IS

    SELECT 'DROP ' ||

      CASE owner

        WHEN 'PUBLIC'

          THEN 'PUBLIC SYNONYM '

        ELSE 'SYNONYM ' || owner || '.'

      END ||

      synonym_name AS cmd

    FROM

      dba_synonyms

    WHERE

      table_owner IN (

        'SYSMAN',

        'SYSMAN_MDS',

        'MGMT_VIEW',

        'SYSMAN_BIP',

        'SYSMAN_APM',

        'BIP',

        'SYSMAN_OPSS',

        'SYSMAN_RO'

      );

BEGIN

  FOR l_syn_rec IN l_syn_csr LOOP

    BEGIN

      EXECUTE IMMEDIATE l_syn_rec.cmd;

    EXCEPTION

      WHEN OTHERS THEN

        dbms_output.put_line( '===> ' || l_syn_rec.cmd );

        dbms_output.put_line( sqlerrm );

    END;

  END LOOP;

END;

/

PL/SQL procedure successfully completed.

SQL> DROP USER mgmt_view CASCADE;

User dropped.

SQL> DROP TABLESPACE mgmt_ecm_depot_ts INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS;

Tablespace dropped.

SQL> DROP TABLESPACE mgmt_tablespace   INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS;

Tablespace dropped.

SQL> DROP TABLESPACE mgmt_ad4j_ts      INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS;

Tablespace dropped.

SQL> DELETE

FROM

schema_version_registry

 WHERE

(comp_name,owner) IN (

('Authorization Policy Manager','SYSMAN_APM'),

('Metadata Services','SYSMAN_MDS'),

 ('Oracle Platform Security Services','SYSMAN_OPSS')

  );

2 rows deleted.

SQL> commit;

Commit complete.

SQL> ALTER SYSTEM SET optimizer_dynamic_sampling = 0 SCOPE=both;

System altered.

SQL>

Verify if any of the following users already exists.

CLOUD_ENGINE_USER
CLOUD_SWLIB_USER
MGMT_VIEW
SYSMAN_TYPES
SYSMAN_OPSS
SYSMAN_STB
SYSMAN_RO

select username from dba_users where username in ('CLOUD_ENGINE_USER',
'CLOUD_SWLIB_USER',
'MGMT_VIEW',
'SYSMAN_TYPES',

'SYSMAN_OPSS',

'SYSMAN_STB',
'SYSMAN_RO');

Drop above users.

In Summary, Follow below steps :

1. Drop the repository users:

 drop user sysman cascade;

 drop user sysman_types cascade;

 drop user sysman_stb cascade;

 drop user sysman_opss cascade;

 drop user sysman_biplatform cascade;

 drop user sysman_bip cascade;

 drop user sysmanupgr_opss cascade;

 drop user sysman_apm cascade;

 drop user sysman_ro cascade;

 drop user sysman_mds cascade;

 drop user cloud_engine_user cascade;

 drop user cloud_swlib_user cascade;

 drop user mgmt_view cascade;

 drop user eus_engine_user cascade;

 drop role mgmt_user;

2. Verify if there are any leftover synonyms:

 spool synonyms.lst

 select owner,synonym_name from dba_synonyms where table_owner in ('SYSMAN', 'SYSMAN_MDS', 'MGMT_VIEW', 'SYSMAN_BIP', 'SYSMAN_APM', 'SYSMAN_OPSS', 'SYSMAN_RO', 'SYSMAN_BIPLATFORM', 'SYSMANUPGR_OPSS', 'CLOUD_ENGINE_USER', 'CLOUD_SWLIB_USER', 'EUS_ENGINE_USER', 'SYSMAN_TYPES', 'SYSMAN_STB') ;

 spool off

 @synonyms.lst

If any synonyms listed, drop them using below syntax

 DROP SYNONYM schema.synonym_name;

 3. Drop the tablespaces:

 drop tablespace MGMT_ECM_DEPOT_TS including contents and datafiles cascade constraints;

 drop tablespace MGMT_TABLESPACE including contents and datafiles cascade constraints;

 drop tablespace MGMT_AD4J_TS including contents and datafiles cascade constraints;

4. Delete the entries from registry:

 delete from SCHEMA_VERSION_REGISTRY where COMP_NAME='Metadata Services';

 delete from SCHEMA_VERSION_REGISTRY where COMP_NAME='Authorization Policy Manager';

 delete from SCHEMA_VERSION_REGISTRY where COMP_NAME='Oracle Platform Security Services';

 delete from SCHEMA_VERSION_REGISTRY where COMP_NAME='OracleBI and EPM';

 delete from SCHEMA_VERSION_REGISTRY where COMP_NAME='Service Table';

 commit;