Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Unable to Allocate Bytes

Status
Not open for further replies.

jcshepp

Technical User
Dec 31, 2002
8
GB
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.
 
Have you checked whether your ulimits matches the requirement for Oracle?
 
I think this is an application error - most likely a memory leak

jcshepp said:
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top