2014. 12. 19. 19:01 오라클
EM 12.1.0.4 설치시 나는 에러 에러 처리법
EM 12.1.0.4 설치시 나는 에러 에러 처리법
아래와 같이 처리하고 Retry 하니 잘됨.
=======================================
1. 본인의 경우 MGMT_TABLESPACE 가 autoextend 임에도 불구하고 100% 여서 일단 늘여주었음
직접적인 에러의 원인은 아니라고 봄..예방차원
TABLESPACE_NAME FILE_NAME TOT_KB FREE_KB USAGE_P
-------------------- --------------------------------------------- ------------ ------------ -------
MGMT_AD4J_TS /u01/oradata/EMREP/mgmt_ad4j.dbf 204,800 203,072 .8
MGMT_ECM_DEPOT_TS /u01/oradata/EMREP/mgmt_depot.dbf 40,960 19,008 53.6
MGMT_TABLESPACE /u01/oradata/EMREP/mgmt.dbf 1,126,400 78,784 93.0
SYSAUX /u01/oradata/EMREP/sysaux01.dbf 614,400 193,152 68.6
SYSTEM /u01/oradata/EMREP/system01.dbf 716,800 1,408 99.8
UNDOTBS1 /u01/oradata/EMREP/undotbs01.dbf 952,320 0 100.0
USERS /u01/oradata/EMREP/users01.dbf 5,120 4,096 20.0
2. 파티션 추가 (요게 중요. 파티션 없음)
SQL> conn sysman/welcome1
Connected.
SQL> exec gc_interval_partition_mgr.partition_maintenance;
SQL> exec mgmt_audit_admin.add_audit_partition;
=======================================
EM 12c: Enterprise Manager Cloud Control OMS Installation Fails At OMS Configuration Stage With Message 'ORA-14400: inserted partition key does not map to any partition' Reported In CfmLogger*.log (문서 ID 1663277.1)
Applies to:
Enterprise Manager Base Platform - Version 12.1.0.1.0 and later
Information in this document applies to any platform.
Symptoms
OMS installation fails at oms configuration
From <OMS_HOME>/cfgtoollogs/cfgfw/CfmLogger_<timestamp>.log:
=======================
INFO: oracle.sysman.top.oms:java.sql.SQLException: ORA-14400: inserted partition key does not map to any partition
INFO: oracle.sysman.top.oms:ORA-06512: at "SYSMAN.EM_SELF_UPDATE", line 1537
INFO: oracle.sysman.top.oms:ORA-06512: at line 1
INFO: oracle.sysman.top.oms:
INFO: oracle.sysman.top.oms:OMSCA-ERR:Post deploy operations failed. Check the trace file:/u01/app/em/middleware/oms/cfgtoollogs/omsca/omsca_20140402160051.log
INFO: oracle.sysman.top.oms:
Check the OMS Configuration Assistant logs at: /u01/app/em/middleware/oms/cfgtoollogs/omsca
INFO: oracle.sysman.top.oms:The plug-in OMS Configuration has failed its perform method
=======================
Cause
The Partitions are not created in the Database used as Repository and hence oms configuration fail due to missing partitions. This issue is documented in following bug:
BUG 18307758 - AUDIT PARTITIONS NOT CREATED ON EM INSTALL, WHEN DB TEMPLATE IS USED
Solution
1. Run the query below as SYSMAN to manually add partitions
SQL> exec gc_interval_partition_mgr.partition_maintenance;
SQL> exec mgmt_audit_admin.add_audit_partition;
2. Resume OMS installation
If OUI is open, click on Retry on the OUI
If OUI is closed, then resume the installation by executing the following command:
$ export ORACLE_HOME=<OMS_HOME>
$ <OMS_HOME>/oui/bin/runConfig.sh ORACLE_HOME=<oms_home_path> MODE=perform ACTION=configure COMPONENT_XML={encap_oms.1_0_0_0_0.xml}
