Re: Oracle Client showing time an hour behind
From: Harel Safra <harel.safra_at_gmail.com>
Date: Tue, 11 May 2010 19:16:37 +0300
Message-ID: <4BE982E5.10808_at_gmail.com>
Clients that connect through the listener inherit it's TZ settings. If you did the change to DST by changing the TZ in your database server the listener (an therefore the clients) won't detect the change until it's restarted.
I've seen it happen several times.
Date: Tue, 11 May 2010 19:16:37 +0300
Message-ID: <4BE982E5.10808_at_gmail.com>
Clients that connect through the listener inherit it's TZ settings. If you did the change to DST by changing the TZ in your database server the listener (an therefore the clients) won't detect the change until it's restarted.
I've seen it happen several times.
btw, restarting the listener isn't a traumatic event. Clients that are connected will stay connected, the only influence is that during the restart new clients can't connect to the database.
Harel Safra
On 11/05/2010 18:56, Saad Khan wrote:
>
> Harel, I'm not sure how listener start can help! I remember doing it
> in my previous change orders but I can try in non-prod env first.
>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue May 11 2010 - 11:16:37 CDT