Re: Oracle Client showing time an hour behind
- From: Saad Khan <saad4u@xxxxxxxxx>
- To: Harel Safra <harel.safra@xxxxxxxxx>
- Date: Tue, 11 May 2010 14:40:29 -0400
I'm testing it in non-prod right now.
One more thing, the dbtimezone , I changed it to -05:00 But the
sessiontimezone is still showing -04:00.
How can I change the sessiontimezone now?
On Tue, May 11, 2010 at 12:16 PM, Harel Safra <harel.safra@xxxxxxxxx> wrote:
> 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.
>>
>>
Other related posts:
