Home » Developer & Programmer » Precompilers, OCI & OCCI » ORA-01019: unable to allocate memory in the user side
icon9.gif  ORA-01019: unable to allocate memory in the user side [message #147933] Mon, 21 November 2005 16:15
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.?

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

    uname -a
  • 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)


Previous Topic: PCC-S-02015 and oci.h
Next Topic: Distinguish between VARCHAR & NVARCHAR using data type code
Goto Forum:
  


Current Time: Fri Jul 10 15:29:19 CDT 2020