Home » RDBMS Server » Server Administration » ORA-01034: ORACLE not available ORA-27102 (oracle 11g)
ORA-01034: ORACLE not available ORA-27102 [message #597651] Mon, 07 October 2013 06:32 Go to next message
oracle_doubt
Messages: 96
Registered: December 2012
Location: CHENNAI
Member
Hi all,
I am facing ORA-01034: ORACLE not available ORA-27102 error.Please do needful
icon13.gif  Re: ORA-01034: ORACLE not available ORA-27102 [message #597654 is a reply to message #597651] Mon, 07 October 2013 06:47 Go to previous messageGo to next message
Michel Cadot
Messages: 57603
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

ORA-27102: out of memory
 *Cause: Out of memory
 *Action: Consult the trace file for details

Ask your DBA to investigate.

Re: ORA-01034: ORACLE not available ORA-27102 [message #597746 is a reply to message #597654] Tue, 08 October 2013 04:17 Go to previous messageGo to next message
8939513598$
Messages: 101
Registered: July 2013
Location: chennai
Senior Member
Hi Siraj, what is your environment,actually? is it a real work environment like you are working on a server (or) a normal CPU, i think if you are among a group of people,others would have shut the database.
Re: ORA-01034: ORACLE not available ORA-27102 [message #597748 is a reply to message #597746] Tue, 08 October 2013 04:35 Go to previous messageGo to next message
oracle_doubt
Messages: 96
Registered: December 2012
Location: CHENNAI
Member
Hi,
We are working on server only.That issue may arise by memory.I will send our server config.
Re: ORA-01034: ORACLE not available ORA-27102 [message #597910 is a reply to message #597748] Wed, 09 October 2013 04:48 Go to previous messageGo to next message
oracle_doubt
Messages: 96
Registered: December 2012
Location: CHENNAI
Member
Hi all,
Please find below.

Oracle DB Server(192.168.0.63) Verstion details below:

Oracle Database 11g Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production

oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536

RAM - 4GB

3core Processor type :Intel(R) Xeon(R) CPU E5405 @ 2.00GHz
Re: ORA-01034: ORACLE not available ORA-27102 [message #598072 is a reply to message #597910] Thu, 10 October 2013 05:23 Go to previous message
oracle_doubt
Messages: 96
Registered: December 2012
Location: CHENNAI
Member
Hi,

Kernel value:

fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default=262144
net.core.rmem_max=4194304
net.core.wmem_default=262144
net.core.wmem_max=1048586

Ulimit value:

core file size (blocks, -c) 0
data seg size (kbytes, -d) unlimited
scheduling priority (-e) 0
file size (blocks, -f) unlimited
pending signals (-i) 30514
max locked memory (kbytes, -l) 64
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
real-time priority (-r) 0
stack size (kbytes, -s) 10240
cpu time (seconds, -t) unlimited
max user processes (-u) 30514
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited

the above kernel value set before installing Oracle database.
Previous Topic: Getting Thousands of DB_STRUCTURE_INTEGRITY_CHECK
Next Topic: Collect Table Stats
Goto Forum:
  


Current Time: Wed Apr 16 20:42:37 CDT 2014

Total time taken to generate the page: 0.15672 seconds