tjl7666
13th April 2004, 21:53
We have had this error in sessions tisfc0505m000 and tisfc0507m000.

Full error message

Fatal error : Error 9224 (bdb_errno 9224) on select
Fatal error : Can not continue in tisfc0507m000 (get.actual.occ.min)

The log has the error ORA-8224 in fetched item.

Has anyone seen this?

NPRao
13th April 2004, 22:13
Never seen that one :(

Here is the info I found online-

[DEV:bsp]/app/common/home/bsp>oerr ora 8224
[DEV:bsp]/app/common/home/bsp>oerr ora 7224
07224, 00000, "sfnfy: failed to obtain file size limit; errno = %s."
// *Cause: The ulimit system call returned an error.
// *Action: Check errno and contact customer support.

Check the Unix ulimits -

$ulimit
unlimited
$ulimit -a
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) 1048576
stack(kbytes) 392192
memory(kbytes) unlimited
coredump(blocks) 4194303
$ulimit -s
392192

Also check with your Oracle DBA's, I found this info on the Oracle metalink-

Doc ID: Note:20783.1
Subject: OERR: ORA 8224 "sfccf: Invalid logical block size"
Type: REFERENCE
Status: PUBLISHED
Content Type: TEXT/PLAIN
Creation Date: 02-MAR-1995
Last Revision Date: 10-JUN-1999

Error: ORA 8224 Text: sfccf: Invalid logical block size
-------------------------------------------------------------------------------
Cause: Oracle attempted to create a file with an invalid block size.
Action: Check that your init.ora parameters specify valid block sizes.