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:::p roject.max -shm-memor y=(privile ged,429496 7296,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 ?
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:::p
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 ?
ASKER
i reduced the intial sga to 1.5g and installed db. and later changed sga to 3G.
Thanks
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Increase that if needed to 4GB and see.
Thanks.