OraFAQ Forum: Server Administration » ORA-01034: ORACLE not available ORA-27102

Home » RDBMS Server » Server Administration » ORA-01034: ORACLE not available ORA-27102 (oracle 11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01034: ORACLE not available ORA-27102 [message #597651]

Mon, 07 October 2013 06:32

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

Report message to a moderator

Re: ORA-01034: ORACLE not available ORA-27102 [message #597654 is a reply to message #597651]

Mon, 07 October 2013 06:47

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

Re: ORA-01034: ORACLE not available ORA-27102 [message #597746 is a reply to message #597654]

Tue, 08 October 2013 04:17

8939513598$
Messages: 103
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.

Report message to a moderator

Re: ORA-01034: ORACLE not available ORA-27102 [message #597748 is a reply to message #597746]

Tue, 08 October 2013 04:35

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.

Report message to a moderator

Re: ORA-01034: ORACLE not available ORA-27102 [message #597910 is a reply to message #597748]

Wed, 09 October 2013 04:48

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

Report message to a moderator

Re: ORA-01034: ORACLE not available ORA-27102 [message #598072 is a reply to message #597910]

Thu, 10 October 2013 05:23

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.

Report message to a moderator

Previous Topic:	Getting Thousands of DB_STRUCTURE_INTEGRITY_CHECK
Next Topic:	Collect Table Stats

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 02 00:05:55 CST 2025