Unable to Allocate Bytes

[jcshepp]

One of our customers has a document archive that stores scanned versions of documents in an oracle database as blobs. Recently they started getting the following message. There are no errors in the alert.log or in the aix error logs. The database remains up when the error happens. The process that inserts the images into the database has failed and needs to be restarted.

The Application has a logfile and the following error appears in the application logfile. Has anyone seen this error before ? Is there an AIX parameter that needs to be tuned or is this an Oracle Issue ?

Aix Version is 5.3 Oracle version : 10g

Error is :--

Unable to allocated 312008 bytes for search buffer : 12
CreateSQLSearch:Error during adding search row
Finished processing message , took approx 9 seconds.

 

[khalidaaa]

I would go with that this is an Oracle issue!

 

[HelloNair]

Have you checked whether your ulimits matches the requirement for Oracle?

 

[jcshepp]

Ulimit is set to unlimited

 

[p5wizard]

I think this is an application error - most likely a memory leak

Unable to allocated 312008 bytes for search buffer : [red]12[/red]
CreateSQLSearch:Error during adding search row
Finished processing message , took approx 9 seconds.

[tt]# grep -w [red]12[/red] /usr/include/sys/errno.h
#define ENOMEM 12 /* Not enough space */[/tt]

log in as the user that runs the image-inserter process and run the command
[tt]ulimit -a[/tt]



HTH,

p5wizard