OraFAQ Forum: Unix » What would cause ORA-01019: unable to allocate memory in the user side?

Home » Infrastructure » Unix » What would cause ORA-01019: unable to allocate memory in the user side?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

What would cause ORA-01019: unable to allocate memory in the user side? [message #148856]

Mon, 28 November 2005 13:32

ferkee
Messages: 3
Registered: November 2005
Location: Texas

Junior Member

We are in the process of configuring 2 new servers to take the place of older ones. The hardware is newer, the OS is newer, Oracle client is newer.

What are possible explanations for the following error I get from my application when it attempts to perform an INSERT:

ORA-01019: unable to allocate memory in the user side

Upon request, I can provide any additional details. The insert is rather large, as is the table, but the core code did not change, nor did anything on the server. (items of interest will most likely be my environment vars [PATH, ORACLE_HOME, LD_LIBRARY_PATH], the makefile)

If I cannot locate the problem, I will have to retreat to the VERY OLD client! Please help me avoid that!!

OLD oracle version 7.3.4.0.0
NEW oracle version 9.2.0.?

OLD : Pro*C/C++: Release 9.2.0.6.0
NEW : Pro*C/C++: Release 2.2.4.0.0

OLD : SunOS sterling2 5.6 Generic_105181-39 sun4u sparc SUNW,Ultra-4
NEW : SunOS cux029 5.8 Generic_117350-27 sun4u sparc SUNW,Ultra-80

IPC Related info from sysdef -i
OLD

*
* IPC Messages
*
 32768	max message size (MSGMAX)
 65535	max bytes on queue (MSGMNB)
  1024	message queue identifiers (MSGMNI)
  1024	system message headers (MSGTQL)
*
* IPC Semaphores
*
   256	semaphore identifiers (SEMMNI)
 65535	semaphores in system (SEMMNS)
   320	undo structures in system (SEMMNU)
   100	max semaphores per id (SEMMSL)
   100	max operations per semop call (SEMOPM)
 10240	max undo entries per process (SEMUME)
 32767	semaphore maximum value (SEMVMX)
 16384	adjust on exit max value (SEMAEM)
*
* IPC Shared Memory
*
   9097152	max shared memory segment size (SHMMAX)
     1	min shared memory segment size (SHMMIN)
   512	shared memory identifiers (SHMMNI)
   128	max attached shm segments per process (SHMSEG)

NEW

*
* IPC Messages
*
   100	entries in msg map (MSGMAP)
  2048	max message size (MSGMAX)
  4096	max bytes on queue (MSGMNB)
    50	message queue identifiers (MSGMNI)
     8	message segment size (MSGSSZ)
   256	system message headers (MSGTQL)
  1024	message segments (MSGSEG)
*
* IPC Semaphores
*
   258	entries in semaphore map (SEMMAP)
   256	semaphore identifiers (SEMMNI)
   512	semaphores in system (SEMMNS)
    80	undo structures in system (SEMMNU)
   100	max semaphores per id (SEMMSL)
    10	max operations per semop call (SEMOPM)
    10	max undo entries per process (SEMUME)
 32767	semaphore maximum value (SEMVMX)
 16384	adjust on exit max value (SEMAEM)
*
* IPC Shared Memory
*
   2097152	max shared memory segment size (SHMMAX)
     1	min shared memory segment size (SHMMIN)
   512	shared memory identifiers (SHMMNI)
    10	max attached shm segments per process (SHMSEG)

Report message to a moderator