Link to home
Start Free TrialLog in
Avatar of Dba_Oracledb
Dba_Oracledb

asked on

11g RAC DB creation error: out of memory

i am getting ora 27102 error, while creating new RAC db,

i have given sga and pga as 4GB

cat /etc/project
system:0::::
user.root:1::::
noproject:2::::
default:3::::
group.staff:10::::
user.oracle:100:Oracle:::project.max-shm-memory=(privileged,4294967296,deny)

top results

ast pid: 25972;  load avg:  0.11,  0.12,  0.13;       up 166+08:05:19                                              17:22:41
116 processes: 114 sleeping, 1 stopped, 1 on cpu
CPU states: 99.6% idle,  0.0% user,  0.4% kernel,  0.0% iowait,  0.0% swap
Memory: 32G phys mem, 25G free mem, 31G total swap, 31G free swap



how to solve this ?
Avatar of Chakravarthi Ayyala
Chakravarthi Ayyala
Flag of United States of America image

Please check your kernal.shmall in the /etc/sysctl.conf file.
Increase that if needed to 4GB and see.

Thanks.
Avatar of Dba_Oracledb
Dba_Oracledb

ASKER

i reduced the intial sga to 1.5g and installed db. and later changed sga to 3G.

Thanks
ASKER CERTIFIED SOLUTION
Avatar of Chakravarthi Ayyala
Chakravarthi Ayyala
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial