【12c】一文教你详细了解如何安装Oracle Enterprise Manager Cloud Control 12c

Caused by: oracle.sysman.emInternalSDK.core.selfupdate.integration.OperationFailedException: ORA-14400: inserted partition key does not map to any partition

ORA-06512: at "SYSMAN.EM_SELF_UPDATE", line 1546

ORA-06512: at line 1

at oracle.sysman.emInternalSDK.core.selfupdate.InventoryManager.registerOutOfBoxEntity(InventoryManager.java:847)

at oracle.sysman.core.selfupdate.EntityInstRegistration.parse(EntityInstRegistration.java:185)

... 5 more

Caused by: java.sql.SQLException: ORA-14400: inserted partition key does not map to any partition

ORA-06512: at "SYSMAN.EM_SELF_UPDATE", line 1546

ORA-06512: at line 1

MOS文档号

EM 12c: Enterprise Manager Cloud Control OMS Installation Fails At OMS Configuration Stage With Message Reported In CfmLogger*.log: ORA-14400: inserted partition key does not map to any partition (Doc ID 1663277.1)

解决方案

方案一：

Run the query below as SYSMAN to manually add partitions

SQL> exec gc_interval_partition_mgr.partition_maintenance;

PL/SQL procedure successfully completed.

SQL> exec mgmt_audit_admin.add_audit_partition;

PL/SQL procedure successfully completed.

方案二：

Resume OMS installation

    If OUI is open, click on Retry on the OUI

oms库执行sql后，回头点Retry

    If OUI is closed, then resume the installation by executing the following command:

        $ export ORACLE_HOME=<OMS ORACLE_HOME>

        $ $ORACLE_HOME/oui/bin/runConfig.sh ORACLE_HOME=<OMS ORACLE_HOME> MODE=perform ACTION=configure COMPONENT_XML={encap_oms.1_0_0_0_0.xml}

修复后点击Retry

９）Root用户下执行脚本

[root@emcc ~]# /u01/app/oracle/middleware/oms/allroot.sh



Starting to execute allroot.sh .........



Starting to execute /u01/app/oracle/middleware/oms/root.sh ......

Running Oracle 11g root.sh script...



The following environment variables are set as:

ORACLE_OWNER= oracle

ORACLE_HOME= /u01/app/oracle/middleware/oms



Enter the full pathname of the local bin directory: [/usr/local/bin]:

The file "dbhome" already exists in /usr/local/bin. Overwrite it? (y/n)

[n]:

The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n)

[n]:

The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n)

[n]:



Entries will be added to the /etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root.sh script.

Now product-specific root actions will be performed.

/etc exist



Creating /etc/oragchomelist file...

/u01/app/oracle/middleware/oms

Finished execution of /u01/app/oracle/middleware/oms/root.sh ......





Starting to execute /u01/app/oracle/agent/core/12.1.0.4.0/root.sh ......

Finished product-specific root actions.

/etc exist

Finished execution of /u01/app/oracle/agent/core/12.1.0.4.0/root.sh ......

10）安装完成，点击Close

11）登录https://192.168.56.111:7802/em输入用户名、密码，点击登录

12）登录后，对页面做默认设置，设置后进入页面

至此，Oracle Enterprise Manager Cloud Control 12c安装完成，后面将对EM CC的配置进行介绍。

【12c】一文教你详细了解如何安装Oracle Enterprise Manager Cloud Control 12c

标签：term   entity   log   rev   fbo   proc   message   模板   com