在WIN2016上安装EM13C EMREP配置时报错:ORA-01843: not a valid month

郑全

M 13.5: OMS Installation Fails in Repository Configuration Phase with the Error: ORA-01843: not a valid month (Doc ID 2880634.1)       

In this Document
Symptoms
Changes
Cause
Solution
References

APPLIES TO:
Enterprise Manager Base Platform - Version 13.5.0.0.0 and later
Information in this document applies to any platform.
SYMPTOMS
Enterprise Manager Cloud Control 13.5 OMS installation fails in the Repository Configuration phase with the error:

<OMS_HOME>/cfgtoollogs/cfgfw/CfmLogger_<timestamp>.log

INFO: oracle.sysman.top.oms:after starting RCU

INFO: oracle.sysman.top.oms:************java.lang.Exception: The last RCUModel exit status code is not SUCCEEDED.

INFO: oracle.sysman.top.oms: at oracle.sysman.emdrep.schemamanager.SchemaAction.perform(SchemaAction.java:727)

INFO: oracle.sysman.top.oms: at oracle.sysman.emdrep.schemamanager.EMRCURunner.run(EMRCURunner.java:118)

INFO: oracle.sysman.top.oms:[Initializing the EM RCU Runner, Running the Schema Action, Schema Action Failed]

INFO: oracle.sysman.top.oms:1 error(s) happened in performing the action:

INFO: oracle.sysman.top.oms:1):

INFO: oracle.sysman.top.oms: ORA-01843: not a valid month

INFO: oracle.sysman.top.oms:ORA-06512: line 3

INFO: oracle.sysman.top.oms:File:<OMS_HOME>\plugins\oracle.sysman.emct.oms.plugin_13.5.1.0.0\sql\cat\13.5.1.0.0\cpa\cat_cpa_template_data_spec2017.sql

INFO: oracle.sysman.top.oms:Statement:BEGIN

INFO: oracle.sysman.top.oms:delete  from EMCT_SPEC_RATE_LIB  where benchmark='CINT2006rate';

INFO: oracle.sysman.top.oms:Insert into EMCT_SPEC_RATE_LIB (SPEC_RATE_ID,DATA_SOURCE_ID,BENCHMARK,HARDWARE_VENDOR,SYSTEM_CONFIG,CORES,CHIPS,CORES_PER_CHIP,THREADS_PER_CORE,PROCESSOR,PROCESSOR_MHZ,PROCESSOR_CHARACTERISTICS,FIRST_LEVEL_CACHE,SECOND_LEVEL_CACHE,THIRD_LEVEL_CACHE,MEMORY,RESULTS,BASELINE,PUBLISHED,NORM_HARDWARE_VENDOR,NORM_SYSTEM,NORM_CPU_VENDOR,NORM_CPU_FAMILY,NORM_CPU_MODEL,NORM_CPU_THREADS,NORM_1ST_CACHE_MB,NORM_2ND_CACHE_MB,NORM_3RD_CACHE_MB,NORM_MEMORY_GB,SPEC_RATE,SPEC_RATE_ORIGIN_FLAG,BOPS,BOPS_PER_JVM,JVM,JVM_INSTANCES) values (109230,4,'CINT2017rate','XXXX','Altos R380 F4 (Intel Xeon Silver 4110)',16,2,8,2,'Intel Xeon Silver 4110',2100,'None','32 KB I + 32 KB D on chip per core','1 MB I+D on chip per core','11 MB I+D on chip per chip','192 GB (12 x 16 GB 2Rx4 PC4-2400T-R, running at 2400)',0,72.7,to_date('01-OCT-18','DD-MON-RR'),'XXXX','Altos R380','Intel',' Xeon Silver ','4110',32,0.0625,1,11,192,72.7,0,null,null,null,null);



CHANGES


CAUSE
The problem is reported as

BUG 34923519 - Enterprise Manager Cloud Control installation fails with ORA-01843

SOLUTION
Set below environment variable before invoking the Enterprise Manager Cloud Control Installation Wizard.

    export LANG=en_US.utf8
    export LC_ALL=en_US.utf8
    export NLS_LANG=american_america.XXX("XXX" depends on the specific environment, e.g., utf8)

    <Software_Location>/em13500_<platform>.bin

The issue is specific to Oracle Consolidation Planning and Chargeback plugin.
If it's not easy to change LANGUAGE setting (for example Windows OS),
please exclude Oracle Consolidation Planning and Chargeback plugin, when install Cloud Control.