One of our guys found this in a note note on the metalink:
Workarounds when time zone patches are not available
Note: Always try to use the official patch listed above.
Oracle's time zone definitions are stored in 2 time zone files,
timezone.dat and timezlrg.dat, in $ORACLE_HOME/oracore/zoneinfo.
Note: Portability across patchsets, but not releases and platforms.
The time zone files can be freely copied across patchset versions on the
same platform, but they are unique on each platform and for each
release. Therefore they should never be copied across platforms and/or
across releases - but they can be copied to different patchset versions
of the same release.
So for example:
A set of 10.2.0.2 files should never be applied to a 10.1.0.5
release
A set of 10.2.0.2 files for 'Linux 32 bit' should never be
applied to a 10.2.0.2 Solaris installation.
But this same set of 10.2.0.2 'Linux 32 bit' files can be copied
to a 10.2.0.1 'Linux 32 bit' installation
A set of 9.2.0.7 files can be used by any database between
versions 9.2.0.1 and 9.2.0.8 on the same platform.
But this same set of 9.2.0.7 files can not be used by a database
version 10.1 or 10.2, or by 9.2.0.x on a different platform.
etc. etc.
Andrew W. Kerber
Oracle DBA
UMB
"If at first you dont succeed, dont take up skydiving"
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Sam Bootsma
Sent: Friday, January 26, 2007 11:58 AM
To: Thomas.Mercadante@xxxxxxxxxxxxxxxxx; Chandra.Pabba@xxxxxxx;
nancy.malpass@xxxxxxxxxxxx; joseph.armstrong-champ@xxxxxxxxx;
Brandon.Allen@xxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: RE: Oracle and DST changes
According to Oracle FAQ#223 in Metalink Note 402742.1, the timezone
files are picked up whenever database or client software is started up.
So the act of stopping and restarting sqlplus would cause the files to
be re-read. Here is the FAQ:
223. Is any relinking needed after the patches are applied?
No.
The time zone file patch only gives you 2 new time zone files. These are
picked up automatically by the database or client software the next time
they start up.
The JVM patch requires the JVM in the database to be updated after the
patch has been installed, but this is a action "inside" the database.
For details refer to the readme files of the JVM patches.
Sam Bootsma
Oracle Database Administrator
Information Technology Services
George Brown College
Phone: 416-415-5000 x4933
Fax: 416-415-4836
E-mail: sbootsma@xxxxxxxxxxxxxx
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Mercadante, Thomas F
(LABOR)
Sent: January 26, 2007 7:49 AM
To: Chandra.Pabba@xxxxxxx; nancy.malpass@xxxxxxxxxxxx;
joseph.armstrong-champ@xxxxxxxxx; Brandon.Allen@xxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: RE: Oracle and DST changes
This is crazy. It looks like a new session gets the new information.
I connect to the database with the old files in place in the zoneinfo
directory. I ran the script and the results were wrong.
I loaded the new files without disconnecting from sqlplus and ran the
script again. The results were wrong.
I restarted sqlplus and ran the script and the results were correct.
It looks like a new database session reads the zoneinfo files?
Another great testing job from Oracle support. At least they are
consistent.
--------------------------------------------------------
This transmission may contain confidential, proprietary, or privileged
information which is intended solely for use by the individual or entity
to whom it is addressed. If you are not the intended recipient, you are
hereby notified that any disclosure, dissemination, copying or
distribution of this transmission or its attachments is strictly
prohibited. In addition, unauthorized access to this transmission may
violate federal or State law, including the Electronic Communications
Privacy Act of 1985. If you have received this transmission in error,
please notify the sender immediately by return e-mail and delete the
transmission and its attachments.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Pabba, Chandra
Sent: Thursday, January 25, 2007 4:49 PM
To: nancy.malpass@xxxxxxxxxxxx; joseph.armstrong-champ@xxxxxxxxx;
Brandon.Allen@xxxxxxxxxxx
Cc: Mercadante, Thomas F (LABOR); oracle-l@xxxxxxxxxxxxx
Subject: RE: Oracle and DST changes
Yes, I did notice the same thing. Without restarting the instance, I
was able to see the updated results.
Thanks
Chandra
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Malpass, Nancy
Sent: Thursday, January 25, 2007 3:45 PM
To: joseph.armstrong-champ@xxxxxxxxx; Brandon.Allen@xxxxxxxxxxx
Cc: Mercadante, Thomas F (LABOR); oracle-l@xxxxxxxxxxxxx
Subject: RE: Oracle and DST changes
That would be great to no have to restart each database.
Anyone else do this and found that a restart is not necessary?
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Joe Armstrong-Champ
Sent: Thursday, January 25, 2007 3:32 PM
To: Brandon.Allen@xxxxxxxxxxx
Cc: Mercadante, Thomas F (LABOR); oracle-l@xxxxxxxxxxxxx
Subject: Re: Oracle and DST changes
This actually turns out not to be true. I just applied the patch to a
test db without shutting down and when I ran the confirmation sql I got
the updated results:
SQL> select to_timestamp_tz('20070311 00:00:00 US/EASTERN','YYYYMMDD
HH24:MI:SS TZR') + to_dsinterval('0 08:00:00') TEST from dual;
TEST
------------------------------------------------------------------------
---
11-MAR-07 09.00.00.000000000 AM US/EASTERN
(solaris 64-bit/oracle 10.1.0.4)
Joe
Allen, Brandon wrote:
It also confirms that the timezone files are in
> fact only read at startup, so a restart is necessary for the new rules
> to take effect.
>
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
------------------------------------------------------------------------------
NOTICE: This electronic mail message and any attached files are confidential.
The information is exclusively for the use of the individual or entity intended
as the recipient. If you are not the intended recipient, any use, copying,
printing, reviewing, retention, disclosure, distribution or forwarding of the
message or any attached file is not authorized and is strictly prohibited. If
you have received this electronic mail message in error, please advise the
sender by reply electronic mail immediately and permanently delete the original
transmission, any attachments and any copies of this message from your computer
system. Thank you.
==============================================================================
--
http://www.freelists.org/webpage/oracle-l