No question at this time
DBA Top 10
1 M. Cadot 7400
2 B. Vroman 1700
3 P. Wisse 1300
4 P. Tsongayinwe 1200
5 J. PĂ©ran 800
6 J. Schnackenberg 400
7 J. Alcroft 200
7 D. Walgude 200
7 B. M 200
10 A. Hudspith 100
10 L. Ywema 100
10 D. Johnson 100
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48726
Total active users1323
Act. users last 24h0
Act. users last hour0
Registered user hits last week35
Registered user hits last month263
Go up

DBTIMEZONE of both instances shows UTC.
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...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts 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, 12 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, 12 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
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, 11 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