Shulou(Shulou.com)05/31 Report--

This article will explain in detail about Oracle database server modification operating system time considerations, Xiaobian think quite practical, so share to you as a reference, I hope you can read this article after harvest.

Oracle Database Server considerations for modifying operating system time:

Single machine or ha

1. The database itself has no impact. Because scn does not depend on os time

2. For apps, if sysdate is used in the app, it does have an impact.

Based on this situation, we generally recommend that the time to change os not to the previous time, but to the future time to change.

Recommended: Notes when installing oracle10g & modifying oracle database character set encoding

[Notes when installing oracle10g: 1. Close network connection 2... Modify oracle database character set code: log in SQLPLUS with system and password first, and then: 1. log in oracle with sys connect sys/password as sy

rac

1. For the database itself, there is an impact, because CRS needs the os time of the nodes to be synchronized, otherwise it may cause node eviction.

2. For apps, if sysdate is used in the app, it does have an impact.

Based on this situation, we generally recommend that the time to change os not to the previous time, but to the future time to change.

Knowledge Point Extension:

Does Oracle RAC require a reboot for subsequent OS modifications?

User 10G system with 2-node RAC but no time synchronization. Then there were 2 instances where one of the instances went down due to time out of sync. Since the user has several other systems with time differences of 1 minute and 10 seconds, but no problems have occurred, the user wants to know if the time synchronization is not the root cause of these two failures.

First of all, time synchronization is a must for RAC, and not just the best advice. If you have a lot of time difference and there is no problem, it does not mean that there will be no problems in the future. Second, time synchronization is also very important for applications. Imagine what happens if two instances in RAC accept service requests, but the time of two nodes is inconsistent.

So how do you handle it? NTP is used for general time synchronization, and Cluster Time Synchronization Daemon (CTSSD) is also supported if it is 11gr2 or above. Since the user system is 10g, it is also possible to configure one of the two hosts as a time server and the other synchronized with it.

Also, after changing the time, does the database service need to be restarted? To avoid database and business impact, it is best to restart database services.

About "Oracle database server modify operating system time what matters needing attention" This article is shared here, I hope the above content can be of some help to everyone, so that you can learn more knowledge, if you think the article is good, please share it to let more people see.

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.