Memory Restriction
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 18

Thread: Memory Restriction

  1. #1

    Thumbs down

    I have a brand new Dell server with 4GB of RAM running Windows 2000 Server. When I go to install Oracle 8.1.6 Enterprise Server it crashes on DB creation saying that there is insufficient memory to create a table. I was sceptical so I checked my swap file- plenty of room there (8 gigs). I then checked my Physical RAM usage and it said I had 3.4 gigs available. Why does the setup engine crash? There is plenty of memory available.
    Chester Ney
    CODY Computer Services
    System DBA

  2. #2
    Join Date
    Apr 2001
    Location
    Louisville KY
    Posts
    295
    THere are known problems with the Oracle Installer on Intel P4s in 8i. If this is what you have, you need to get the patches for the installer from Metalink or OTN.

    by the by, I did a 9i install on a system and also saw that the installer used 600+MB of memory. Nice to see confirmation. Who was it that said we would never need as much as 640K? I think they had something to do with WIndows.
    Joseph R.P. Maloney, CSP,CDP,CCP
    'The answer is 42'

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    What was the error? It almost sounds like you didn't have enough space in one of your tablespaces.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  4. #4
    Well that was the thing. The installer crapped out when creating the default database- on the first table. It wasn't like I was adding a table after the database was already created. I didn't even get that far. I've installed 8.1.6 enterprise server in excess of 200 times on hardware ranging from a 266 Mhz with 64 mb of ram to a P4 with a gig of Ram and this is the first machine that I've installed on to have more than 1 gig of ram. Is it possible that I have too much RAM? Or that the OS isn't set up properly to address 4 gigs of RAM. I know that win 2k server supports of to 4 gigs but do I need to configure anything?
    Chester Ney
    CODY Computer Services
    System DBA

  5. #5
    The error message was:

    ORA-27102 out of memory error

    I couldn't find much documentation on this.
    Chester Ney
    CODY Computer Services
    System DBA

  6. #6
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Code:
    Error:	ORA-27102
    Text:	out of memory 
    ---------------------------------------------------------------------------
    Cause:	Out of memory.
    Action:	Consult the trace file for details.
    Was there a trace file?
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  7. #7
    Where would I locate the trace file?
    Chester Ney
    CODY Computer Services
    System DBA

  8. #8
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    $ORACLE_BASE/admin/$ORACLE_SID/bdump or udump
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  9. #9
    Join Date
    Jul 2000
    Posts
    521
    This error means, the installer is unable to start the instance because it could not get enough memory for the SGA.
    svk

  10. #10
    It couldn't get enough memory? I have 3.4 gigs available. I really don't think having ENOUGH memory is the problem.
    Chester Ney
    CODY Computer Services
    System DBA

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width