Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2011
    Posts
    7

    Unanswered: ORA-27102: out of memory on Linux, unable to startup instance

    Hello ,

    I am trying to startup my DB but its showing me error..

    SQL> startup open;
    ORA-27102: out of memory
    Linux-x86_64 Error: 12: Cannot allocate memory
    Additional information: 1
    Additional information: 140017670
    Additional information: 8

    I am using RHEL 5.3 with 64 bit.

    uname -a :- Linux test 2.6.18-128.el5 #1 SMP Wed Dec 17 11:41:38 EST 2008 x86_64 x86_64 x86_64 GNU/Linux

    kernel.shmall = 4294967296
    kernel.shmmax = 68719476736

    [oracle@test ~]$ getconf PAGE_SIZE
    4096.

    Can anyone resolve this issue.

    Regards
    Anas.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >I am trying to startup my DB but its showing me error..
    When was last time DB started without error?
    What changed since then?

    post results from following OS command

    free

    post content of /etc/sysctl.conf
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Sep 2011
    Posts
    7

    out of memory on linux

    Hi,

    Database was running fine , but i ran one Hot backup script .

    After finishing backup i tried to open sqlplus / as sysdba, then it shows me above error.

    [root@test ~]# free
    total used free shared buffers cached
    Mem: 4044652 4017156 27496 0 7172 3533996
    -/+ buffers/cache: 475988 3568664
    Swap: 524280 329356 194924

    [root@test ~]# cat /etc/sysctl.conf
    # Kernel sysctl configuration file for Red Hat Linux
    #
    # For binary values, 0 is disabled, 1 is enabled. See sysctl(8) and
    # sysctl.conf(5) for more details.

    # Controls IP packet forwarding
    net.ipv4.ip_forward = 0

    # Controls source route verification
    net.ipv4.conf.default.rp_filter = 1

    # Do not accept source routing
    net.ipv4.conf.default.accept_source_route = 0

    # Controls the System Request debugging functionality of the kernel
    kernel.sysrq = 0

    # Controls whether core dumps will append the PID to the core filename
    # Useful for debugging multi-threaded applications
    kernel.core_uses_pid = 1

    # Controls the use of TCP syncookies
    net.ipv4.tcp_syncookies = 1

    # Controls the maximum size of a message, in bytes
    kernel.msgmnb = 65536

    # Controls the default maxmimum size of a mesage queue
    kernel.msgmax = 65536

    # Controls the maximum shared segment size, in bytes
    kernel.shmmax = 68719476736


    # Controls the maximum number of shared memory segments, in pages
    kernel.shmall = 4294967296
    kernel.shmmni = 4096
    kernel.sem = 250 32000 100 128
    fs.file-max = 6815744
    fs.aio-max-nr = 1048576
    net.ipv4.ip_local_port_range = 9000 65500
    net.core.rmem_default=1048576
    net.core.wmem_default=1048576
    net.core.rmem_max=4194304
    net.core.wmem_max=1048576

    Thanks...

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Database was running fine , but i ran one Hot backup script .
    >After finishing backup i tried to open sqlplus / as sysdba, then it shows me above error.

    Does not compute.
    Hotbackup is done with the DB being OPEN so no restart is required.

    post 2 excerpts from alert_SID.log file.
    1) last time DB opened without error
    2) last failed open from above
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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