Oracle on linux 32 bits with 16 GIG Ram ORA-27102: out of memory
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Oracle on linux 32 bits with 16 GIG Ram ORA-27102: out of memory

  1. #1
    Join Date
    Nov 2000
    Posts
    440

    Oracle on linux 32 bits with 16 GIG Ram ORA-27102: out of memory

    I need an sga size of 10g.
    And a pga_aggregate_target of 3gig.
    I have the following error: ORA-27102: out of memory When i start my database,

    I cannot use Oracle 64 bits because oracle does not support "hsodbc" on 64 bits.

    ### Oracle version ###
    10.2.0.3 32 bits

    ### /etc/sysctl.conf ###
    kernel.shmall = 4103791
    kernel.shmmax = 16106127360
    kernel.shmmni = 4096
    kernel.sem = 250 32000 100 128
    fs.file-max = 65536
    net.ipv4.ip_local_port_range = 1024 65000
    net.core.rmem_default = 1048576
    net.core.rmem_max = 1048576
    net.core.wmem_default = 262144
    net.core.wmem_max = 262144

    ### uname -a ###
    Linux Mycomp.com 2.6.9-42.0.10.0.1.ELsmp #1 SMP Tue Feb 27 12:25:04 PST 2007 i686 i686 i386

    ### Red Hat Linux Release Information ###
    cat /etc/redhat-release
    Enterprise Linux Enterprise Linux AS release 4 (October Update 4)

    ### Umask Setting ###

    0022
    ### Ulimit Settings ###

    [oracle@2950 ~]$ ulimit -a
    core file size (blocks, -c) 0
    data seg size (kbytes, -d) unlimited
    file size (blocks, -f) unlimited
    pending signals (-i) 1024
    max locked memory (kbytes, -l) 32
    max memory size (kbytes, -m) unlimited
    open files (-n) 1024
    pipe size (512 bytes, -p) 8
    POSIX message queues (bytes, -q) 819200
    stack size (kbytes, -s) 10240
    cpu time (seconds, -t) unlimited
    max user processes (-u) 274432

    I found those metalink notes:
    Note 260152.1 Summary About the Large SGA & Address Space on RH Linux
    Note 264236.1 - Considerations on using "hugemem" Kernel vs SMP kernel
    Note 317141.1 - How to Configure RHEL 4 32-bit for Very Large Memory with ramfs and HugePages


    But im no sysadmin.

    Anyone has specific info on how to enable oracle to use more than 1.7gig of ram on a 16 gig ram machine?

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    did you follow the instructions in the last note?

  3. #3
    Join Date
    Oct 2006
    Location
    Mumbai
    Posts
    184
    Follow This:

    Procedure how to increase the SGA in LINUX AS/ES 3.


    1. Shutdown the Database.

    2. Add following kernel parameter in /boot/grub/grub.conf

    Kernel /vmlinuz-2.6.9-34.ELsmp ro root=LABEL=/ rhgb quiet bigpages=6100 MB

    Edit and Add following parameter in /etc/sysctl.conf

    Kernel.shmmax = 4294967295 (not more then it)

    3. Add following parameter in init.ora file:


    Sample calculation for 2GB of db_block_buffers

    (1024*1024*1024)*2/db_block_size (8192) = 262144


    Instead of db_cache_size used following parameter

    db_block_buffers=262144
    use_indirect_data_buffers=true

    4. Restart the Linux server.

    5. Up the database and see SGA

    SQL> show sga


    Total System Global Area 3407418688 bytes
    Fixed Size 451904 bytes
    Variable Size 1258291200 bytes
    Database Buffers 2147483648 bytes
    Redo Buffers 1191936 bytes

  4. #4
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    That's with Linux ES 3, is it still applicable with ES4 and better than ramfs?
    ---------------

  5. #5
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    I think setting SHMMAX is wrong in your case.

    Check this note may help you.
    "What is past is PROLOGUE"

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