My Oracle Support Banner

DBService Fails to Start With "**FATAL** Current times of NMS server and database server do not match" Error (Doc ID 3002768.1)

Last updated on JULY 17, 2024

Applies to:

Oracle Utilities Network Management System - Version 2.6.0.1.0 and later
Oracle Network Management for Utilities - DMS - Version 2.6.0.1.0 and later
Information in this document applies to any platform.

Symptoms

NMS 2.6: DBService failed with UTC issue

When launching services, DBService (and other database services, i.e. MBDBService, TCDBService) fail with this error:

02/02/24 14:22:56Z: dbrdwr:7624 Connection info: service=[database hostname] hostname=[database host] instance=[RDBMS HOST]
02/02/24 14:22:56Z: dbrdwr:7624 **FATAL** Current times of NMS server and database server do not match (02/02/2024 14:22:56, 02/02/2024 09:22:56). Check TZ environment variable on database server.

Please see the settings on database server and NMS service server sides.

  1. Settings on Database server side:
    $ echo $TZ
    UTC

    $ date
    Fri Feb 2 14:24:55 UTC 2024

    SQL> SELECT SESSIONTIMEZONE, DBTIMEZONE FROM DUAL;
    SESSIONTIMEZONE DBTIME
    --------------------------------------------------------------------------- ------
    +00:00 +00:00

  2. Settings on NMS services server side:
    $ echo $TZ
    UTC

    $ ISQL
    SQL> SELECT SESSIONTIMEZONE, DBTIMEZONE FROM DUAL;
    SESSIONTIMEZONE
    ---------------------------------------------------------------------------
    DBTIME
    ------
    UTC
    +00:00

  3. DBService log file:
    02/02/24 14:22:56Z: dbrdwr:7624 Connection info: service=[database hostname] hostname=[database host] instance=[RDBMS HOST]
    02/02/24 14:22:56Z: dbrdwr:7624 **FATAL** Current times of NMS server and database server do not match (02/02/2024 14:22:56, 02/02/2024 09:22:56). Check TZ environment variable on database server.

Changes

 The both the database server and the NMS server were switched to use the UTC timezone.

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
Changes
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.