Home » Infrastructure » Linux » Error "ORA-27102:out of memory" during database creation using dbca (Oracle 12.1.0.2 64bit , Oracle Enterprise Linux 6.7 64bit)
Error "ORA-27102:out of memory" during database creation using dbca [message #658209] Wed, 07 December 2016 03:14 Go to next message
fabi88
Messages: 112
Registered: November 2011
Senior Member
I ran into a problem during creating Database using dbca.

The following error raised in "Creating and starting oracle instance " step:(as attached)
Quote:
"ORA-27102:out of memory"

System information :
OS = Oracle Enterprise Linux 6.7 64bit
RAM Size = 256 G

I set Memory Size (SGA and PGA) equals 194 G and select "Automatic Memory Management" During Installation.

The kernel parameters are as follows:

Quote:
net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 1
net.ipv4.conf.default.accept_source_route = 0
kernel.sysrq = 0
kernel.core_uses_pid = 1
net.ipv4.tcp_syncookies = 1
kernel.msgmnb = 65536
kernel.msgmax = 65536
kernel.shmall = 1073741824
fs.file-max = 6815744
kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
kernel.shmmax = 4398046511104
kernel.panic_on_oops = 1
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 9000 65500


tmpfs size is set in /etc/fstab as follow:
Quote:
tmpfs /dev/shm tmpfs size=750G 0 0

tmpfs used value is as follows when the error is raised:
Quote:
Filesystem Size Used Avail Use% Mounted on
tmpfs 750G 111G 640G 15% /dev/shm


Could anyone help me how can I resolve this problem?



Re: Error "ORA-27102:out of memory" during database creation using dbca [message #658210 is a reply to message #658209] Wed, 07 December 2016 03:23 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

ORA-27102: out of memory
 *Cause: Out of memory
 *Action: Consult the trace file for details
Re: Error "ORA-27102:out of memory" during database creation using dbca [message #658212 is a reply to message #658210] Wed, 07 December 2016 03:46 Go to previous messageGo to next message
fabi88
Messages: 112
Registered: November 2011
Senior Member
Thanks for your reply


Quote:

Tue Dec 06 14:30:42 2016
Dump of system resources acquired for SHARED GLOBAL AREA (SGA)

Tue Dec 06 14:30:42 2016
Per process system memlock (soft) limit = 227G
Tue Dec 06 14:30:42 2016
Expected per process system memlock (soft) limit to lock
SHARED GLOBAL AREA (SGA) into memory: 194G
Tue Dec 06 14:30:42 2016
Available system pagesizes:
4K, 2048K
Tue Dec 06 14:30:42 2016
Supported system pagesize(s):
Tue Dec 06 14:30:42 2016
PAGESIZE AVAILABLE_PAGES EXPECTED_PAGES ALLOCATED_PAGES ERROR(s)
Tue Dec 06 14:30:42 2016
4K Configured 46006279 1870 ORA-27102
Tue Dec 06 14:30:42 2016
Reason for not supporting certain system pagesizes:
Tue Dec 06 14:30:42 2016
2048K - Dynamic allocate and free memory regions
Tue Dec 06 14:30:42 2016

Re: Error "ORA-27102:out of memory" during database creation using dbca [message #658219 is a reply to message #658212] Wed, 07 December 2016 04:49 Go to previous messageGo to next message
fabi88
Messages: 112
Registered: November 2011
Senior Member
Trace file content:

Quote:
Trace file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_14479.trc

sskgm_fileatt1: mmap failed addr 0x80000000 flags 17 errno 12
ASGA/ISGA using npools = 1 based on nfobs = 3400 and initcount = 1656920
Shared memory segment allocated: shmid: 142540823 size: 7659520 bytes pagesize: 4096 startaddr: 0x60000000
sskgm_fileatt1: mmap failed addr 0x80000000 flags 17 errno 12
ORA-27102: Failed to allocate segment: (size 190G, pagesize 4K
sskgm_fileatt1: mmap failed addr 0x80000000 flags 17 errno 12
Re: Error "ORA-27102:out of memory" during database creation using dbca [message #658220 is a reply to message #658212] Wed, 07 December 2016 04:54 Go to previous messageGo to next message
wanear
Messages: 8
Registered: December 2016
Junior Member
hi,maybe sth wrong with your os env,you can do as following step by step
change to user :root and execute
#getconf PAGE_SIZE
it will returns a value,assume as 8196

next
256*1024*1024/8196=327520078

at last,change the kernel values as root user
#echo "327520078">/proc/sys/kernel/shmall

lucky.





Re: Error "ORA-27102:out of memory" during database creation using dbca [message #658223 is a reply to message #658220] Wed, 07 December 2016 05:26 Go to previous messageGo to next message
fabi88
Messages: 112
Registered: November 2011
Senior Member
Hi,

# getconf PAGE_SIZE
4096

# cat /proc/sys/kernel/shmall
1073741824
Re: Error "ORA-27102:out of memory" during database creation using dbca [message #658229 is a reply to message #658220] Wed, 07 December 2016 06:42 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
wanear wrote on Wed, 07 December 2016 11:54
hi,maybe sth wrong with your os env,you can do as following step by step
change to user :root and execute
#getconf PAGE_SIZE
it will returns a value,assume as 8196

next
256*1024*1024/8196=327520078

at last,change the kernel values as root user
#echo "327520078">/proc/sys/kernel/shmall

lucky.
Maybe you should take care of what OP posted:

1/ pagesize: 4096
2/ kernel.shmall = 1073741824 so greater than the value you advise (even changing your 8192 to 4096).

In the end, what is the rationale behind your advice?

Re: Error "ORA-27102:out of memory" during database creation using dbca [message #658463 is a reply to message #658229] Thu, 15 December 2016 02:06 Go to previous messageGo to next message
wanear
Messages: 8
Registered: December 2016
Junior Member


in shortly,the default os kernel limits the source.

Re: Error "ORA-27102:out of memory" during database creation using dbca [message #658468 is a reply to message #658463] Thu, 15 December 2016 02:58 Go to previous message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
More likely that the /dev/shm file system is not large enough. It needs to be at least as big as all the SGAs on the system (or all the memory_targets if using AMM). This is something that (if I remember correctly) is not mentioned in the Linux installation guides.
Previous Topic: No usable disks have been found
Next Topic: Want to view .gz file contents from particular text onwards.
Goto Forum:
  


Current Time: Thu Mar 28 03:42:55 CDT 2024