changing system date on HP-UX server with Oracle 9i running

[ckchai]

Hi,

What is the impact if I change a system date on a HP-UX 11.11 server with Oracle9i database running?

[RAC_1]

Chaos...

You may be running into a problem. Oracle might have transactions in future date etc...

Not a good idea to do it.

[Rajeev Shukla]

Changing the date to forward wouldn't make difference to Oracle9i, however changing backwards would.

[ckchai]

Sorry I missed so informations here.

The server is a production server running Oracl9i data base.

And configure with MC/Service Guard clustering.

Can anyone give a details on what will happen if we change the system date to move forward 5minutes.

Thanks.

[Rajeev Shukla]

Ckchai,

I have not tried with Oracle but i have production servers with MC/SG and Informix database. And i have moved the time a head couple of times and never had any issues.

[Muthukumar_5]

Do you want to change system date permanently? Then reboot is needed to there in the machine first to get *Effect*.

It is not problem to go forward. But problem when doing backward.

--
Muthu

[RAC_1]

did you think about NTP? It would adjust the time slowly and would allow to be in sync with NTP server.

[Patrice Le Guyader]

hi ckchai,

According to my little oracle knowledge, if you are using oracle application you can have problems such as if the scheduler launch some sql transactions and you get 5 min earlier it can launch them again. If you launch an sql transaction wich take more than that time you can have end time before start time. You may have trouble with the sequence number of your files(control files).

Hope this helps
Pat

[Senthil Kumar .A_1]

Hi,

As muthu points it again and again, forwarding/advancing the time to future does not pose any problems to the HPUX system per say. But moving it backward needs a reboot. Not too sure ,how Oracle will take this advancement, but I think it should be safe, unless and otherwise specifically mentioned by Oracle inc. Try getting info from oracle forums aswell.

I absolutely vote for RAC's response. Try setting the desired time on a non-prod hpux box in your environment and configure it as NTP server. After doing so, you can configure the Oracle 9i production cluster as NTP client to the configured NTP server. By this the time would progress to the desired time in small increments. That way , you would be entirely safer.

Regards,
Senthil Kumar .A

[Peter Godron]

ckchai,
have you had any problems in the past, when Summer/Winter Time happened?