Forum Stats

  • 3,751,797 Users
  • 2,250,414 Discussions


Configuring Oracle Enterprise Manager Cloud Control 13.5 throws error

SunnyG Member Posts: 1 Green Ribbon
edited Jun 4, 2021 12:34PM in Enterprise Manager


I am testing out the installation of Oracle Enterprise Manager Cloud Control 13.5.

The installtions are being performed on Oracle Linux 8.

An issue that I am coming up against is when performing the configuration the component EM Repository Creation Configuration fails:

having looked thtough the logs the only errors I am seeing being reported are java.sql.SQLDataException: ORA-01850: hour must be between 0 and 23

I am following the steps given here:

Are there additional steps that missing or is this an expected error which can be ignored?


  • BluShadow
    BluShadow Member, Moderator Posts: 41,317 Red Diamond

    *Moderator Note: I've moved this over to the Enterprise Manager forum for you, as it's certainly not a SQL or PL/SQL question which is the forum you posted in. Please try and locate the correct forum for your questions in future, so the correct people can see you question and help you.

  • EricvdS
    EricvdS Member Posts: 972 Bronze Trophy

    Hi Sunny,

    It is in Chinees but if you use Chrome translate you can read this blog:

    After the software installation it comes down to changing in /u02/Middleware/OMS/sysman/admin/emdrep/sql/core/latest/target/target_tables.sql

    (PARTITION "1990-01-01 00:00" VALUES LESS THAN ('01-JAN-1990')) into

    (PARTITION "1990-01-01 00:00" VALUES LESS THAN (to_date('01-01-1990','DD-MM-YYYY')))

    I don't use EM 13.5 myself yet so I did not run into this issue.