Re: Oracle10g issue - times() call fails

[Leos Bitto <nahant-list leos cz>]

I have had a very similar problem some time ago and I have filed a 
support request via metalink.oracle.com. The answer was that this was a 
known bug affecting Oracle 10.2.0.1.0 and servers with high uptime. The 
recommended solution was to either restart the server, or install a 
special patch from Oracle, or wait until 10.2.0.2.0 comes out and 
upgrade. In my case I have moved the application to another server with 
lower uptime and that helped. After 10.2.0.2.0 was published I have 
upgraded and now even the server with high uptime works fine. YMMV

Leos

Marko Asplund wrote:
> i'm having weird problems with Oracle10gR2 on RHEL 4 Update 3 (WS) on an 
> IA32 system.
>
> the Oracle server has been running fine for quite a while now but all of 
> a sudden it started eating up processing resources and now the load is 
> at 15 with only the Oracle server running.
>
> i tried connecting to the database instance using sqlplus but strangely 
> 'sqlplus /nolog' command just seems to wait forever without giving any 
> output.
>
> i did a strace for this command, here's how it looks like:
>
> ...
> open("/opt/oracle10g/u01/app/oracle/product/10.2.0/db_1/rdbms/mesg/ocius.msb", 
> O_RDONLY) = 6
> fcntl64(6, F_SETFD, FD_CLOEXEC)         = 0
> lseek(6, 0, SEEK_SET)                   = 0
> read(6, "\25\23\"\1\23\3\t\t\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 
> 256) = 256
> lseek(6, 512, SEEK_SET)                 = 512
> read(6, "\337y\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 
> 512) = 512
> lseek(6, 1024, SEEK_SET)                = 1024
> read(6, "\25\7\'\0072\7>\7j\7\276\17$\'\6K5S\24TfT\307T(VsV\222"..., 86) 
> = 86
> times(NULL)                             = -2147233465
> times(NULL)                             = -2147233465
> times(NULL)                             = -2147233465
> ...
>
> the times() system call is called over and over until i terminate the 
> process.
>
> i made a small test program which just calls times() and prints the 
> value (printf("%d") and times() gives similar values in the test program 
> as in the strace. errno is set to 0.
>
> any ideas on why times() calls fail?
>
> uptime is at 198 and kernel version is 2.6.9-22.ELsmp.
>
>
> --
>     aspa
>
> --
> nahant-list mailing list
> nahant-list redhat com
> https://www.redhat.com/mailman/listinfo/nahant-list