shared memory lock failed with error [28]

[Zhenhao He]

Platform: HP9000 L2000 4CPU, 2G Memory

I am running Informatica (a data warehouse extraction, transformation, and loading software) to load data into an
Oracle database, which uses system resources - semphore and shared memory, I setup my kernel parameters controling semphore and shard memory according to the Informatica vendor suggestion. I encountered the following errors. Attached is the log file from Informatica session.


CMN_1010 System shared memory [11] allocated for [12000000] bytes.
CMN_1132 Semaphore [11815] created.
CMN_1569 Server Mode: [ASCII]
CMN_1570 Server Codepage: [ISO 8859-1 Western European]
TM_6151 Session Sort Order: [Binary]
TM_6050 Executing pre-session shell commands: session [s_SGF2_PR_CUSTOMER_DIMENSION]
TM_6051 Completed pre-session shell commands: session [s_SGF2_PR_CUSTOMER_DIMENSION]
Mon Mar 05 17:00:45 2001
CMN_1139 ERROR accessing synchronization object: shared memory lock failed with error [28]: No space left on device
Mon Mar 05 17:00:45 2001
CMN_1008 Internal error.