Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

ORA-27102 out of memory error

SOLVED
Go to solution
Leah Chow
Frequent Advisor

ORA-27102 out of memory error

When the application users try to connect to the database, they receive the ora-27102 error.

The machine we have is HPUX 9000 64 bits 11i server, only have one oracle instance. The oracle version is 9.2.0.1.

Here are my server kernel information, inlcuding oracle SGA size. The answers I got from Oracle is: I need to increase the size of my maxdsiz, maxssiz. Also i need to apply the 9.2.0.4 patches on my server.

SQL> show sga

Total System Global Area 969501240 bytes
Fixed Size 735800 bytes
Variable Size 251658240 bytes
Database Buffers 716800000 bytes
Redo Buffers 307200 bytes
SQL>



Parameter Current Dyn Planned Module Version
===============================================================================

dbc_max_pct 50 - 50
dbc_min_pct 5 - 5
default_disk_ir 0 - 0
desfree - - 0
max_async_ports 50 - 50
max_fcp_reqs 512 - 512
max_mem_window 0 - 0
max_thread_proc 256 - 256
maxdsiz 1073741824 - 1073741824
maxdsiz_64bit 2147483648 - 2147483648
maxfiles 60 - 60
maxfiles_lim 1024 Y 1024
maxqueuetime - - 0
maxssiz 134217728 - 134217728
maxssiz_64bit 1073741824 - 1073741824
maxswapchunks 16384 - 16384
maxtsiz 0x4000000 Y 0X4000000
maxtsiz_64bit 0x40000000 Y 0X40000000
maxuprc 3686 Y ((NPROC*9)/10)
maxusers 32 - 32
maxvgs 10 - 10
mesg 1 - 1
minfree - - 0
modstrmax 500 - 500
msgmap 4098 - (2+MSGTQL)
msgmax 8192 Y 8192
msgmnb 16384 Y 16384
msgmni 4096 - (NPROC)
msgseg 32767 - 32767
msgssz 8 - 8
msgtql 4096 - (NPROC)
semaem 16384 - 16384
semmap 4098 - (SEMMNI+2)
semmni 4096 - 4096
semmns 8192 - (SEMMNI*2)
semmnu 4092 - (NPROC-4)
semmsl 2048 Y 2048
semume 10 - 10
semvmx 32768 - 32768
sendfile_max 0 - 0
shmem 1 - 1
shmmax 2147483648 Y 2147483648
shmmni 512 - 512
shmseg 32 Y 32


Anyone could tell me how big I should increase?

Thanks
6 REPLIES
Steven E. Protter
Exalted Contributor
Solution

Re: ORA-27102 out of memory error

For performance reasons fix this.

change:
dbc_max_pct 50 - 50
dbc_min_pct 5 - 5

dbc_max_pct 7 - 7
dbc_min_pct 5 - 5

Thats a kernel change, if you are new, get your sysadmin to do it with sam.

Next:
swapinfo -tam

Do you have enough swap. If you are utilizing a lot of swap, you need more. Maybe you want to increase it. Post the results.

ipcs

See that you have adequate shmmax and shmseg(also a kernel deal).

There is also an Oracle patch that takes 9.2.0.1 to 9.2.0.4

You need to get that installed, it involves a data conversion.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Joseph Loo
Honored Contributor

Re: ORA-27102 out of memory error

Hi,

You must have read Metalink Note: 169706.1?

On the Kernel Parameter settings on the HP-UX 11.11 (64bit), to run 9.2.0 :

KSI_ALLOC_MAX (NPROC*8)
MAX_THREAD_PROC 256
MAXDSIZ 1073741824 bytes
MAXDSIZ_64BIT 2147483648 bytes
MAXSSIZ 134217728 bytes
MAXSSIZ_64BIT 1073741824
MAXSWAPCHUNKS 16384
MAXUPRC ((NPROC*9)/10)
MSGMAP (MSGTQL+2)
MSGMNI NPROC
MSGSEG 32767
MSGTQL NPROC
NCALLOUT (NKTHREAD+16)
NCSIZE ((8*NPROC+2048)+VX_NCSIZE)
NFILE (15*NPROC+2048)
NFLOCKS 4096
NINODE (8*NPROC+2048)
NKTHREAD (((NPROC*7)/4)+16)
NPROC 4096
SEMMAP (SEMMNI+2)
SEMMNI 4096
SEMMNS (SEMMNI*2)
SEMMNU (NPROC - 4)
SEMVMX 32768
SHMMAX AvailMem
SHMMIN 1
SHMMNI 512
SHMSEG 32
VPS_CEILING 64

which you should have follow.

May I know what is the size of your physical memory?

regards.
what you do not see does not mean you should not believe
T G Manikandan
Honored Contributor

Re: ORA-27102 out of memory error

I am not sure about the RAM size on the server.

Make sure your

#ulimit
is unlimited.

make sure you have higher values for the shared memory (SHMMAX) and semaphore kernel parameters.

Bring down your dbc_max_pct.THis is dynamic buffer cache.By default it is 50% of memory value.Bring down to a percentage where the value is around 300MB.

REvert on the server model,its configuration and the kernel parameters
Leah Chow
Frequent Advisor

Re: ORA-27102 out of memory error

Thank you guys for the reply. I will make change during the weekend, here is my system information:

HP-UX pics01a B.11.11 U 9000/800 110434670 unlimited-user license
CPU Count: 4
CPU Speed: 875 MHz
CPU HW Support: 64-bit
Kernel Support: 64-bit
RAM Size: 2048 MB
bufpages: 336 MB
maxuprc: 3686
maxvgs: 10
maxfiles: 60
max_thread_proc: 256
nfile: 63498
nflock: 4096
nproc: 4096
ninode: 34816
shmmax: 1073741824
shmmni: 512
dbc_max_pct: 50


Thanks
Leah
Bill Hassell
Honored Contributor

Re: ORA-27102 out of memory error

Is your Oracle instance running in 64bit mode? If not, it will be very difficult to get 1000megs of SGA (shared memory) because 32bit programs all share the same shared memory map. While there may be enough space in the map, it may have become fragmented by stopping and starting the Oracle instance as well as other processes that use shared memory (such as fbackup). Note that use of kill -9 will make this situation even worse as shared memory segments are orphaned by this command option. Check on memory maps with the shminfo program: ftp://contrib:9unsupp8@hprc.external.hp.com/sysadmin/programs/shminfo/


Bill Hassell, sysadmin
Johan Lorimier
Frequent Advisor

Re: ORA-27102 out of memory error


For a small db you can also setup the following parameters:
maxfiles 1024
maxfiles_lim 2048

have a nice WE