Re: Oracle Client showing time an hour behind

From: Saad Khan <saad4u_at_gmail.com>
Date: Tue, 11 May 2010 11:56:01 -0400
Message-ID: <AANLkTinJ_YR33E9L0Aoe-fQX57P0cSWZ2UTYG9irDQVI_at_mail.gmail.com>

Dave, its happening with every client including my machine which has timezone GMT-5, autoadjustable to DST

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.

On Mon, May 10, 2010 at 7:11 PM, David Fitzjarrell <oratune_at_yahoo.com>wrote:

> Have you checked the client environment for any timezone settings?
>
> David Fitzjarrell
>
>
>
> ------------------------------
> *From:* Saad Khan <saad4u_at_gmail.com>
> *To:* oracle-l_at_freelists.org
> *Sent:* Mon, May 10, 2010 5:43:42 PM
> *Subject:* Oracle Client showing time an hour behind
>
> Hi fellows,
>
> We have a oracle environment with 64-bit oracle 10.2.0.4 running on AIX
> 5.3.
>
> I was notified about one strange behaviour by the app support guyz after
> the last DST change.
>
> When we check the timestamp on oracle server, it shows the correct
> timestamp on both OS as well as Oracle. However, when run the command from
> sqlplus client or any other oracle client tool or the app, it shows the
> timestamp/sysdate of one hour behind the actual time.
>
> The database server timing is in EDT. The app doesnt use any TSTZ or TSLTZ
> datatypes but I know there are data dictionary columns with that.
>
> I ran the scripts from one of the metalink notes and found the following
> details:
> SQL> select * from TZ$overview;
>
> USAGE_TYPE VALUE
> --------------------------- ----------------------------------------
> DESCRIPTION
> ------------------------------------------------------------------------
> DBTIMEZONE -05:00
> Database Time Zone, if this is an 'offset' then not affected by DST
>
> NAMED_TSTZ_TABLE_USE_NONSYS 0
> Number of TSTZ columns using named time zones in tables not owned by SYS
>
> NAMED_TSTZ_TABLE_USE_SYS 12
> Number of TSTZ columns using named time zones in tables owned by SYS
>
>
> USAGE_TYPE VALUE
> --------------------------- ----------------------------------------
> DESCRIPTION
> ------------------------------------------------------------------------
> NAMED_TSTZ_VIEW_USE_NONSYS 0
> Number of TSTZ columns using named time zones in views not owned by SYS
>
> NAMED_TSTZ_VIEW_USE_SYS 23
> Number of TSTZ columns using named time zones in views owned by SYS
>
> TSLTZ_TABLE_USE 0
> Number of TSLTZ columns used in tables
>
>
> USAGE_TYPE VALUE
> --------------------------- ----------------------------------------
> DESCRIPTION
> ------------------------------------------------------------------------
> TSLTZ_VIEW_USE 0
> Number of TSLTZ columns used in views
>
> TZ_ARGUMENTS 0
> Number of PL/SQL objects with Time Zone arguments
>
> ---
>
> I found on one of the metalink note that rel 10.2.0.4 has the patchset for
> DST change so it doesnt require any patch, but we are still encountering
> this issue. I also tried after upgrading the oracle client to 10.2.0.4 but
> same result. Any suggestion??
>
> Thanks for the help.
>
> Saad
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Tue May 11 2010 - 10:56:01 CDT