Apparently I hit bug 5927717 which is not viewable in Metalink so I don't know why only some databases are affected. Their only rec is to restart the database which I had already told them wasn't possible in some cases. I wish I had known about this possibility before Sunday morning so I could have checked it then (and probably gotten permission for some db restarts). CAUSE DETERMINATION =================== Bug 5927717 CAUSE JUSTIFICATION =================== Bug matches customer's issue where alert log is reporting incorrect time from that in the database. PROPOSED SOLUTION(S) ==================== Restart the database PROPOSED SOLUTION JUSTIFICATION(S) ================================== Based on the bug: Customers who applied their OS DST fix without restarting their DB instance see some dates such as timestamps in alert.log and V$LOG incorrect, also clients that connect via listener get incorrect SYSDATE. Restarting the instance corrects this problem. Affects ALL DB versions at least up through 10.1.0.3, have not verified affect on 10.2. SOLUTION / ACTION PLAN ====================== -- To implement the solution, please execute the following steps:: Restart the databases that are affected. CAUSE DETERMINATION =================== Bug 5927717 CAUSE JUSTIFICATION =================== Bug matches customer's issue where alert log is reporting incorrect time from that in the database. PROPOSED SOLUTION(S) ==================== Restart the database PROPOSED SOLUTION JUSTIFICATION(S) ================================== Based on the bug: Customers who applied their OS DST fix without restarting their DB instance see some dates such as timestamps in alert.log and V$LOG incorrect, also clients that connect via listener get incorrect SYSDATE. Restarting the instance corrects this problem. Affects ALL DB versions at least up through 10.1.0.3, have not verified affect on 10.2. SOLUTION / ACTION PLAN ====================== -- To implement the solution, please execute the following steps:: Restart the databases that are affected. -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Powell, Mark D Sent: Monday, March 12, 2007 2:34 PM To: oracle-l@xxxxxxxxxxxxx Subject: RE: DST - new time not shownig in alert file We have 9.2.0.6 running on AIX 5.2 and the alert log date/time is correct. No patch applied to Oracle; however, we did patch the OS for DST. -- Mark D Powell -- Phone (313) 592-5148 -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jay.Miller@xxxxxxxxxxxxxxxx Sent: Monday, March 12, 2007 1:19 PM To: don@xxxxxxxxx; aregularjoe8@xxxxxxxxx Cc: oracle-l@xxxxxxxxxxxxx Subject: RE: DST - new time not shownig in alert file Sorry, this is in my 9.2 instances. Jay Miller Sr. Oracle DBA x68355 -----Original Message----- From: dtseiler@xxxxxxxxx [mailto:dtseiler@xxxxxxxxx] On Behalf Of Don Seiler Sent: Monday, March 12, 2007 1:17 PM To: aregularjoe8@xxxxxxxxx Cc: Miller, Jay; oracle-l@xxxxxxxxxxxxx Subject: Re: DST - new time not shownig in alert file I have an unpatched 10.2.0.2 on RHEL3 in Green Bay, WI that is doing just fine. Don. On 3/12/07, Joe Cooper <aregularjoe8@xxxxxxxxx> wrote: > Which version/platform? > > I have a patch-neglected 10.1.0.3 running on Solaris 8, and the alert log > seems just fine. > > Joe Cooper > Senior Oracle DBA > Dep't of Veteran Affairs > Austin Automation Center > Austin, TX > > > Jay.Miller@xxxxxxxxxxxxxxxx wrote: > > > > In boxes we didn't bother to patch or restart (no timezone datatypes, etc.) > while the sysdate is showing correctly the alert log is displaying the old > time. > > Does anyone have a fix for this other than restarting the database (that > works but there are some that we can't restart until the weekend)? > > > Jay Miller > Sr. Oracle DBA > x68355 > > > > > ________________________________ > 8:00? 8:25? 8:40? Find a flick in no time with theYahoo! Search movie > showtime shortcut. > > -- Don Seiler http://seilerwerks.blogspot.com -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l