| Error "ORA-27102:out of memory" during database creation using dbca [message #658209] |
Wed, 07 December 2016 03:14  |
 |
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?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
