RE: DST - new time not shownig in alert file

From: <Jay.Miller_at_tdameritrade.com>
Date: Mon, 12 Mar 2007 17:50:05 -0400
Message-ID: <304CF4722010DD4FA19829D09DDB956B21D67C@prdhswsemlmb01.prod-am.ameritrade.com>

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:

SOLUTION / ACTION PLAN

To implement the solution, please execute the following steps:: Restart the databases that are affected.

-----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

Received on Mon Mar 12 2007 - 16:50:05 CDT