2010-02-06

SQLPLUS hangs in linux

Sfat : upgrade la 10.2.0.4

Metalink note id : 361680.1

Cause
Bug.4930777/4612267 SQLPLUS HANGS ON MACHINES WITH LARGE UPTIME -- EVEN SQLPLUS HANGS

which says it happens when machine is up for more than 248 days.

Checked in truss output and uptime output exactly maching these symtoms...


Solution
To implement the solution, please execute the following steps:

1.Download one off patch from metalink for bug 4612267 ( 10.2.0.1 )
2. apply patch and rerun sqlplus.

OR
Reboot Server

Un comentariu:

  1. I initially though, 'Why 248 days?'. But then I did the math...

    248(days)*86400(seconds/day)*100=2142720000

    Very close to 2147483647 (MAX 4 byte INT )

    The problem probable starts when the machine has been up for 248 days 13:13:56.48

    Interesting

    RăspundețiȘtergere