重庆思庄Oracle、Redhat认证学习论坛

标题: 在WIN2016上安装EM13C EMREP配置时报错:ORA-01843: not a valid month [打印本页]

作者: 郑全 时间: 2024-5-30 20:10
标题: 在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.

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)