Go up

Next thread:	RDS instance:- ORA-29283: invalid file operation: nonexistent file or path [29434]
Prev thread:	Full DB export

Message	Score	Author	Date
Hi, The database is supposed to run on Active-P......		Balaji M	Mar 13, 2023, 16:41
SYSDATE has no time zone, it is just a copy of t......		Michel Cadot	Mar 13, 2023, 20:08
Thank you Michel <b>If you want the same SYSDAT......		Balaji M	Mar 14, 2023, 08:58

Follow up by mail

Click here

---

Subject:	DBTIMEZONE of both instances shows UTC.
Author:	Balaji M, India
Date:	Mar 13, 2023, 16:41, 82 days ago
Os info:	Red Hat Enterprise Linux Server release 7.9 (Maipo)
Oracle info:	19.0.0.0.0
Message:	Hi, The database is supposed to run on Active-Passive mode with one of the ExaCC node running and the other shut down. This is required as a workaround to the performance issues faced on RAC. However, we have observed that both nodes are in active state(running) . Moreover, there is mismatch in time zones as well, which is resulting in time mismatch depending on the nodes where the session is running. 1) demo1@server1 showing time in UTC when SYSDATE is used. 2) demo2@server2 showing time in CET(UTC-1) when SYSDATE is used. DBTIMEZONE of both instances shows UTC. The user wants to know A) Why both nodes are running when it was decided that DB will run in Active/Passive mode? B) Why there is mismatch in timezones in both instances? Regards, Balaji
Goto:	Reply - Top of page

If you think this item violates copyrights, please click here

---

Subject:	Re: DBTIMEZONE of both instances shows UTC.
Author:	Michel Cadot, France
Date:	Mar 13, 2023, 20:08, 81 days ago
Score:
Message:	SYSDATE has no time zone, it is just a copy of the system date/time without any time zone information. If both SYSDATE are different, this means that the server systems are in different time zones. If you want the same SYSDATE, your server systems must be in the same time zone (and, of course, have synchronized clocks).
Your rating?:	This reply is Good Excellent
Goto:	Reply - Top of page

If you think this item violates copyrights, please click here

---

Subject:	Re: DBTIMEZONE of both instances shows UTC.
Author:	Balaji M, India
Date:	Mar 14, 2023, 08:58, 81 days ago
Message:	Thank you Michel If you want the same SYSDATE, your server systems must be in the same time zone (and, of course, have synchronized clocks). How to make system have same time zone and synchronize the clock. Regards, Balaji
Your rating?:	This reply is Good Excellent
Goto:	Reply - Top of page

If you think this item violates copyrights, please click here