Shulou(Shulou.com)06/01 Report--

Oracle rac 11.2.0.4 the time of two nodes is out of sync

Check the time zone of the database and find that it is different:

Node oracle3:

SQL > SELECT TZ_OFFSET (SESSIONTIMEZONE), TZ_OFFSET (DBTIMEZONE) FROM DUAL

TZ_OFFS TZ_OFFS

--

+ 08:00 + 00:00

Node Oracle4:

SQL > SELECT TZ_OFFSET (SESSIONTIMEZONE), TZ_OFFSET (DBTIMEZONE) FROM DUAL

TZ_OFFS TZ_OFFS

--

+ 00:00 + 00:00

Then check the cluster time synchronization server and find that the status is in observation mode and the normal state should be active!

Node Oracle3

[oracle@oracle3 ~] $crsctl check ctss

CRS-4700: The Cluster Time Synchronization Service is in Observer mode.

Node Oracle4

[oracle@oracle4 ~] $crsctl check ctss

CRS-4700: The Cluster Time Synchronization Service is in Observer mode.

View the current time zone of the Linux server with the following command:

[root@oracle4 ~] # date + "Z% z"

Or

[root@oracle4] # date-R

Specific results, as follows, found to be different!

Node Oracle3:

[root@oracle3 ogg] # date + "Z z"

UTC + 0000

Node Oracle4:

[oracle@oracle3 ~] $date + "Z% z"

CST + 0800

Modify the setting time zone, method 2 I use

Method 1, and then select

Tzselect

Method 2

Copy the appropriate time zone file, replace the system time zone file, or create a link file

Cp / usr/share/zoneinfo/$ Primary time Zone / $Sub time Zone / etc/localtime

For example, in China, you can use:

Cp / usr/share/zoneinfo/Asia/Shanghai / etc/localtime

Then, after adjusting the time zone, check the cluster time synchronization service again and find that the status is still incorrect.

Node Oracle3

[oracle@oracle3 ~] $crsctl check ctss

CRS-4700: The Cluster Time Synchronization Service is in Observer mode.

Node Oracle4

[oracle@oracle4 ~] $crsctl check ctss

CRS-4700: The Cluster Time Synchronization Service is in Observer mode.

Some people on the Internet say that they need to stop the ntpd service of Linux. The person who checks me is stop.

[root@oracle3 Asia] # service ntpd status

Ntpd is stopped

[root@oracle4 Asia] # service ntpd status

Ntpd is stopped

Others say that the configuration file needs to be deleted, and the status of the cluster time synchronization service is still incorrect after deletion.

Mv / etc/ntp.conf / etc/ntp.conf.bak

After the operation is completed, it is still not good.

It turns out that the time difference between my two machines is so great that they can't be synchronized after more than a second.

Then modify the time for the other one.

[root@oracle3 Asia] # date-s "15:41:26 CST"

Check again that the status of ctss time synchronization service is active:

[oracle@oracle3 ~] $crsctl check ctss

CRS-4701: The Cluster Time Synchronization Service is in Active mode.

CRS-4702: Offset (in msec): 1729800

[oracle@oracle4 ~] $crsctl check ctss

CRS-4701: The Cluster Time Synchronization Service is in Active mode.

CRS-4702: Offset (in msec): 1729800

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.