Sriram Sanka – My Experiences with Databases & More

Oracle-MySQL-SQL SERVER-Python-Azure-AWS-Oracle Cloud-GCP etc

  • Enter your email address to follow this blog and receive notifications of new posts by email.

  • Total Views

    • 587,933 hits

  • $riram $anka


    The experiences, Test cases, views, and opinions etc expressed in this website are my own and does 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 in this website may be the trademarks of their respective owners.

«
»

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

Posted by Sriram Sanka on September 24, 2012


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 😉

 

 

This entry was posted on September 24, 2012 at 1:16 pm and is filed under Oracle Server Administration. Tagged: . You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

6 Responses to “ORA-27102: out of memory” While Creating a Database”

  1. Heike said

    May 8, 2016 at 9:50 pm

    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 said

    June 2, 2016 at 8:27 am

    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 said

    June 7, 2016 at 10:16 pm

    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 said

    July 24, 2016 at 2:57 am

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

    Like

    Reply

  5. www2.dokidoki.ne.jp said

    December 7, 2016 at 4:47 pm

    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 said

    February 24, 2017 at 8:08 am

    Great article, totally what I needed.

    Like

    Reply

Leave a comment

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

«
»