My Oracle Support Banner

13.5: Installing OMS Fails During Repository Configuration with the Error: ORA-01843: not a valid month (Doc ID 2792225.1)

Last updated on MAY 27, 2024

Applies to:

Enterprise Manager Base Platform - Version 13.5.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Installing 13.5 OMS fails during the Repository Configuration phase with the error:

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

INFO: oracle.sysman.top.oms:The transx command execution completed with the status 255.
INFO: oracle.sysman.top.oms:transx_retCode:255
INFO: oracle.sysman.top.oms:The transx action failed. Execute RepManager with -action transx.
INFO: oracle.sysman.top.oms:process_id:1jhs6ux2n17xo
INFO: oracle.sysman.top.oms:Failure...
INFO: oracle.sysman.top.oms:1 error(s) happened in performing the action:
INFO: oracle.sysman.top.oms:1):
ORA-01843: not a valid month
File:/u01/app/oracle/middleware/sysman/admin/emdrep/sql/core/latest/target/target_tables.sql
Statement:CREATE TABLE EM_TT_CHG_WORK_ITEM_HIST_E
(
target_type VARCHAR2(64),
added_ts TIMESTAMP NOT NULL,
run_ts TIMESTAMP NOT NULL,
process_started_ts TIMESTAMP NOT NULL,
processed_ts TIMESTAMP DEFAULT SYSTIMESTAMP NOT NULL,
new_value VARCHAR2(1000),
status NUMBER DEFAULT 0 NOT NULL,
message VARCHAR2(4000),
CONSTRAINT em_tt_chg_work_item_hist_pk PRIMARY KEY
(target_type, processed_ts)
USING INDEX COMPRESS ADVANCED LOW LOCAL
)
ROW STORE COMPRESS ADVANCED
PARTITION BY RANGE (processed_ts) INTERVAL (NUMTOYMINTERVAL(1,'MONTH'))
(PARTITION "1990-01-01 00:00" VALUES LESS THAN ('01-JAN-1990'))

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.