RE: DST - new time not shownig in alert file

Investigating all our servers about half of them are affected and half aren't. Oddly, there is no consistency for database version or OS version, the only consistency is which company the database existed in prior to our merger (the ones from my old company are experiencing the error). We treated the servers identically for DST prep. There is a hardware difference (we used Sun and they used Fujitsu).

I have an SR open with Oracle and will report back when I have an answer.

Jay Miller
Sr. Oracle DBA
x68355  

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Powell, Mark D Sent: Monday, March 12, 2007 2:34 PM
To: oracle-l_at_freelists.org
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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jay.Miller_at_tdameritrade.com
Sent: Monday, March 12, 2007 1:19 PM
To: don_at_seiler.us; aregularjoe8_at_yahoo.com Cc: oracle-l_at_freelists.org
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_at_gmail.com [mailto:dtseiler_at_gmail.com] On Behalf Of Don Seiler
Sent: Monday, March 12, 2007 1:17 PM
To: aregularjoe8_at_yahoo.com
Cc: Miller, Jay; oracle-l_at_freelists.org
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_at_yahoo.com> 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_at_tdameritrade.com 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
--
http://www.freelists.org/webpage/oracle-l


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


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