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.

>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

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...

>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