龙空技术网

手动删除oem 13c EM REPOSITORY 数据库

思庄认证培训 82

前言:

此时小伙伴们对“oracleoem创建数据库”大概比较关切,姐妹们都想要了解一些“oracleoem创建数据库”的相关资讯。那么小编在网上搜集了一些对于“oracleoem创建数据库””的相关内容,希望看官们能喜欢,咱们一起来学习一下吧!

在EM13C安装失败,想重新安装EM,需要按以下步骤把EM repostiory删除,具体参照如下文档:

13c Cloud Control Repository: How to Manually Drop Repository Database Objects in 13c Cloud Control (文档 ID 2107485.1)

In this Document

GoalSolutionReferences

APPLIES TO:

Enterprise Manager Base Platform - Version 13.1.0.0.0 and later

Information in this document applies to any platform.

GOAL

This document provides the steps for dropping the 13c Cloud Control Repository Database Objects manually.

Note:

- "RepManager dropall" is the supported method for dropping the Repository objects and it is highly recommended to drop repository objects only using the RepManager utility as described here:

Enterprise Manager Cloud Control Administrator's Guide

Release 13.2

Chapter 20 Maintaining and Troubleshooting the Management Repository

20.3 Dropping and Recreating the Management Repository

20.3.1 Dropping the Management Repository

- This document should be used in extreme cases like:

1) The OMS home is lost or removed and there is no RepManager utility availableto drop the repository objects

2) The RepManager utility fails to completely remove all repository objects.

SOLUTION

Login to repository database as sys user and perform the following steps to cleanup the repository database manually:

1. Drop the repository users:

SQL> drop user sysman cascade;

SQL> drop user sysman_types cascade;

SQL> drop user sysman_stb cascade;

SQL> drop user sysman_opss cascade;

SQL> drop user sysman_biplatform cascade;

SQL> drop user sysman_bip cascade;

SQL> drop user sysmanupgr_opss cascade;

SQL> drop user sysman_apm cascade;

SQL> drop user sysman_ro cascade;

SQL> drop user sysman_mds cascade;

SQL> drop user cloud_engine_user cascade;

SQL> drop user cloud_swlib_user cascade;

SQL> drop user mgmt_view cascade;

SQL> drop user eus_engine_user cascade;

SQL> drop role mgmt_user;

2. Verify if there are any leftover synonyms:

SQL> spool synonyms.lst

SQL> 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') ;

SQL> spool off

SQL> @synonyms.lst

3. Drop the tablespaces:

SQL> drop tablespace MGMT_ECM_DEPOT_TS including contents and datafiles;

SQL> drop tablespace MGMT_TABLESPACE including contents and datafiles;

SQL> drop tablespace MGMT_AD4J_TS including contents and datafiles;

4. Delete the entries from registry:

SQL> delete from SCHEMA_VERSION_REGISTRY where COMP_NAME='Metadata Services';

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

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

SQL> delete from SCHEMA_VERSION_REGISTRY where COMP_NAME='OracleBI and EPM'

SQL> delete from SCHEMA_VERSION_REGISTRY where COMP_NAME='Service Table';

SQL> commit;

REFERENCES

NOTE:2096776.1 - EM13c: 13c Cloud Control Installation Fails at Repository Configuration With "ORA-02303: cannot drop or replace a type with type or table dependents"

标签: #oracleoem创建数据库