| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle and DST changes
For version 10.2.0.1 I followed the steps in note 399832.1 and I don't
see any results at all. I have started an SR as there may be an issue or step I'm not seeing. The interpretation is that once you copy the files you are finished.... I have even restarted the database.
I have sucessfully updated a 10.2.0.2 database.
Joel Patterson
Database Administrator
joel.patterson_at_crowley.com
x72546
904 727-2546
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mercadante, Thomas F
(LABOR)
Sent: Friday, January 26, 2007 7:49 AM
To: Chandra.Pabba_at_fmr.com; nancy.malpass_at_cingular.com;
joseph.armstrong-champ_at_tufts.edu; Brandon.Allen_at_OneNeck.com
Cc: oracle-l_at_freelists.org
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.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Pabba, Chandra
Sent: Thursday, January 25, 2007 4:49 PM
To: nancy.malpass_at_cingular.com; joseph.armstrong-champ_at_tufts.edu;
Brandon.Allen_at_OneNeck.com
Cc: Mercadante, Thomas F (LABOR); oracle-l_at_freelists.org
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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Malpass, Nancy
Sent: Thursday, January 25, 2007 3:45 PM
To: joseph.armstrong-champ_at_tufts.edu; Brandon.Allen_at_OneNeck.com
Cc: Mercadante, Thomas F (LABOR); oracle-l_at_freelists.org
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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Joe Armstrong-Champ
Sent: Thursday, January 25, 2007 3:32 PM
To: Brandon.Allen_at_OneNeck.com
Cc: Mercadante, Thomas F (LABOR); oracle-l_at_freelists.org
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 inReceived on Fri Jan 26 2007 - 08:28:57 CST
> 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
 |
 |