Have you verified the time on each OS? On both nodes, issue the 'date' command to see the current time on that node. Oracle gets its time from the OS. Also make sure that the OS has its timezone set correctly. Lastly, verify that your NTP daemon is working correctly.
Thanks, yes i review the time en each OS, apparently all environment variables are the same in both nodes but I get the same result, the TZ
variable is set TZ = CST6CDT # Mexico on both nodes
Thanks Levi, a review the notes and to the end, i did change the nodeapps environment TZ with value CST6CDT:
- srvctl setenv nodeapps -n node1 -t 'TZ= CST6CDT’'
- srvctl setenv nodeapps -n node2 -t 'TZ= CST6CDT’'
restarting cluster but i get same result
The DB time depends on the OS time.
- Check the links that LEvi sent you.
- Check your TimeZone on each node:
select DBTIMEZONE from dual;
Check this to change the TIme Zone for one instance:
- What are you using to keep your RAC Synchronized ? NTP, CTSS ?
- Run this and send the output for each node:
./crsctl check ctss
service ntpd status