Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

11g RAC DB creation error: out of memory

Posted on 2011-02-22
3
Medium Priority
?
400 Views
Last Modified: 2012-06-27
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 ?
0
Comment
Question by:Dba_Oracledb
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 8

Expert Comment

by:Chakravarthi Ayyala
ID: 34956963
Please check your kernal.shmall in the /etc/sysctl.conf file.
Increase that if needed to 4GB and see.

Thanks.
0
 

Author Comment

by:Dba_Oracledb
ID: 34957350
i reduced the intial sga to 1.5g and installed db. and later changed sga to 3G.

Thanks
0
 
LVL 8

Accepted Solution

by:
Chakravarthi Ayyala earned 2000 total points
ID: 34957446
so did it help?
you are welcome.
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question