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
Solved

11g RAC DB creation error: out of memory

Posted on 2011-02-22
3
396 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
  • 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 500 total points
ID: 34957446
so did it help?
you are welcome.
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

829 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