RE: SQL*Plus With Instant Client 10.2.0.1 Hangs, When System Uptime Is More Than 248 Days

"At least this is restricted to the client....as far as we know....;-)"

Maybe not - the patch replaces the sltrg.o object in libcore10.a...

However, it did fix our problem - unable to start a /nolog (or any other) session on the server.

I now know what (exactly) the problem was, but the system uptime was at 198 days when the issue first presented and is at 222 now...  

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Bobak, Mark
Sent: Tuesday, April 18, 2006 3:11 PM
To: ramick_at_dotster.com; oracle-l_at_freelists.org Subject: RE: SQL*Plus With Instant Client 10.2.0.1 Hangs, When System Uptime Is More Than 248 Days

Heheh.....it's baaackkk....the infamous 248 days bug....

If I recall correctly, there was a bug back in 8.0.5, I think?, that caused your database to hang after 248 days. I remember getting reminder emails that we set up to work around the problem... "system has been up for xxx days, you have yyy days left to schedule a reboot"....;-)

At least this is restricted to the client....as far as we know....;-)

-Mark

PS Ah, here it is, note Note:118228.1, bug #1084273, affected 8.0.x through 8.1.6 inclusive.....

--

Mark J. Bobak
Senior Oracle Architect
ProQuest Information & Learning

For a successful technology, reality must take precedence over public relations, for Nature cannot be fooled. --Richard P. Feynman, 1918-1988

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of ramick Sent: Tuesday, April 18, 2006 5:43 PM
To: oracle-l_at_freelists.org
Subject: SQL*Plus With Instant Client 10.2.0.1 Hangs, When System Uptime Is More Than 248 Days

This bug is sort of nuts, but I thought everyone should know before they get hit in production - we may be hitting it in testing (10.2.0.1). See Note:
338461.1.

--

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

--

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

--

http://www.freelists.org/webpage/oracle-l Received on Wed Apr 19 2006 - 14:35:17 CDT