Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-27102: out of memory SVR4 Error: 12: Not enough space

790043Aug 6 2010 — edited Aug 9 2010
We got image copy of one of production server that runs on Solaris 9 and our SA guys restored and handed over to us (DBAs). There is only one database running on source server. I have to up the database on the new server. while startup the database I'm getting following error.

====================================================================
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Aug 6 16:36:14 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup
ORA-27102: out of memory
SVR4 Error: 12: Not enough space
SQL>
====================================================================
ABOUT THE SERVER AND DATABASE
Server:
uname -a
SunOS ush** 5.9 Generic_Virtual sun4u sparc SUNW,T5240*
Database: Oracle 10.2.0.1.0
-------------------------------------------------------------------------------------------------------
I'm giving the "top" command output below:

Before attempt to start the database:
--------------------------------------------------------------------------------------------------------
load averages: 2.85, 9.39, 5.50 16:35:46
31 processes: 30 sleeping, 1 on cpu
CPU states: 98.9% idle, 0.7% user, 0.4% kernel, 0.0% iowait, 0.0% swap
Memory: 52G real, 239G free, 49M swap in use, 16G swap free
--------------------------------------------------------------------------------------------------------
the moment I run the "startup" command
----------------------------------------------------------------------------------------------------------
load averages: 1.54, 7.88, 5.20 16:36:44
33 processes: 31 sleeping, 2 on cpu
CPU states: 98.8% idle, 0.0% user, 1.2% kernel, 0.0% iowait, 0.0% swap
Memory: 52G real, 224G free, 15G swap in use, 771M swap free
----------------------------------------------------------------------------------------------------------

and I compared the Semaphores and Kernel Parameters in /etc/system . Both are Identical.

and ulimit -a gives as below..

root@ush**> ulimit -a*
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) unlimited
stack(kbytes) 8192
coredump(blocks) unlimited
nofiles(descriptors) 256
memory(kbytes) unlimited
root@ush**>*

and ipcs shows nothing as below:


root@ush**> ipcs*
IPC status from <running system> as of Fri Aug 6 19:45:06 PDT 2010
T ID KEY MODE OWNER GROUP
Message Queues:
Shared Memory:
Semaphores:

Finally Alert Log gives nothing, but "instance starting"...

Please let us know where else I should check for route cause ... Thank You.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 6 2010
Added on Aug 6 2010
5 comments
4,235 views