Sriram Sanka

Databases | Cloud | Infrastructure | Security |

ORA-27102: out of memory” While Creating a Database


Today ,While Installing Oracle V 10g Using DBCA On a 32 bit Linux machine with 16 GB of RAM,(allocated 5GB as SGA ) We were encountered with this Error and unable to go further.

[oracle@db ~]$ oerr ORA 27102
27102, 00000, “out of memory”
// *Cause: Out of memory
// *Action: Consult the trace file for details
[oracle@db ~]$

 

This is Because of  On 32 Bit version,It cannot allocate more than 4 GB of Memory  to a process Directly.For this either we need to upgrade to 64 bit and start the Installation or decrease the Memory total value.

So we decreased the total memory size to 2.5 GB and It went successful without any issues.

Read Oracle Meta link Document ID 430492.1  to get  More Information on this.

 

Happy reading 😉

 

 

Published by

Sriram Sanka
Hi there, This is SCP Ranga Rao Sanka working as (A product Manager/Principal DBA)., I have a broad range of Experience in Administration and Implementation in the areas of Database, Cloud, and Other Servers. I am one of the moderators at ORAFAQ. The primary purpose of this blog is to share knowledge. All the code snippets, URLs, and everything in this blog are from My experience, My Learnings from different websites & forums. so please test the posts on your testing Environment first. The experiences, Test cases, views, and opinions, etc., expressed on this website are my own and do not reflect the views or opinions of my employer. This site is independent of and does not represent Oracle Corporation in any way. Oracle does not officially sponsor, approve, or endorse this site or its content. Product and company names mentioned on this website may be the trademarks of their respective owners. I am not responsible for any kind of Damage or any legal activities.

7 responses to “ORA-27102: out of memory” While Creating a Database”

  1. Heike Avatar
    Heike

    Great beat ! I would like to apprentice even as you amend your website, how could i subscribe for a blog site?

    The account helped me a applicable deal. I had
    been tiny bit acquainted of this your broadcast offered vivid transparent idea

    Like

    Reply
  2. thiet bi dien cong nghiep Avatar
    thiet bi dien cong nghiep

    Hey there, I think your site might be having browser compatibility issues.
    When I look at your blog site in Opera, it looks fine but when opening
    in Internet Explorer, it has some overlapping.

    I just wanted to give you a quick heads up! Other then that, amazing blog!

    Like

    Reply
  3. impressive memory foam Avatar
    impressive memory foam

    I’m not tɦat much of a internet reader to be
    honest but yoᥙr bloցs гeally nice, қeep it up!
    I’ll go ahead and bookmɑrk your website to come back latеr.

    All the best

    Like

    Reply
  4. Winnie Avatar
    Winnie

    I really like it when folks get together and share views.
    Great website, continue the good work!

    Like

    Reply
  5. www2.dokidoki.ne.jp Avatar
    www2.dokidoki.ne.jp

    you’re actually a good webmaster. The site loading speed iis amazing.

    It kind off feels that you’re doing any distincftive trick.
    In addition, The contents are masterwork. you’ve performed a magnificent activity in this topic!

    Like

    Reply
  6. http://lesrosiers.com/?option=com_k2&view=itemlist&task=user&id=1169005 Avatar
    http://lesrosiers.com/?option=com_k2&view=itemlist&task=user&id=1169005

    Great article, totally what I needed.

    Like

    Reply
  7. Cameron Avatar
    Cameron

    I found it helpful that you shared your solution for overcoming the out of memory error.

    Like

    Reply

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.