适用范围

Oracle Database Exadata Cloud Machine - Version N/A and later

问题概述

数据库的时间与集群时间不一致？

问题原因

1. 检查OS时区

[oracle@snyxdb ~]$ date -R
Mon, 25 Dec 2023 10:10:50 +0800
[oracle@snyxdb ~]$

2. 集群时间配置文件检查

[root@snyxdb install]# su - grid
Last login: Mon Dec 25 10:00:51 CST 2023 on pts/1
[grid@snyxdb ~]$ cat $ORACLE_HOME/crs/install/s_crsconfig_hostname_env.txt

This file can be used to modify the NLS_LANG environment variable, which determines the charset to be used for messages.

For example, a new charset can be configured by setting NLS_LANG=JAPANESE_JAPAN.UTF8

Do not modify this file except to change NLS_LANG, or under the direction of Oracle Support Services

#TZ=Asia/Shanghai

TZ=Africa/Luanda

NLS_LANG=AMERICAN_AMERICA.AL32UTF8
TNS_ADMIN=
ORACLE_BASE=
[grid@snyxdb ~]$

3. 小结

1). 集群配置文件与OS时区不一致，造成集群时间和数据库不一致。

2). 集群自动启动db时，数据库时区与集群一致，数据库手工启动时，数据库时区与os时区一致。

解决方案

修改集群配置文件中的时区参数与OS一致。

参考文档

1. HOW TO CHANGE TIME ZONE SETTINGS ON AN ORACLE SUN DATABASE MACHINE ENVIRONMENT (Doc ID 1099573.1)
2. Pacific-New - DB Sessions Connected Through Tns Listeners Showing Incorrect Time Zone In 19c RAC DB After Patching (Doc ID 2831909.1)
3. What Determines The Language Character Code Of ASM Alert log? (Doc ID 2538617.1)