Mani's Blog

August 16, 2012

Oracle Startup fails with ORA-27102: out of memory Solaris-AMD64 Error: 22: Invalid argument

Filed under: Database,Oracle — mani @ 9:51 pm

Issue: Oracle startup on Solaris 10G failed with following errors.

oracle@xnodb916:~$ dba

SQL*Plus: Release 10.2.0.3.0 – Production on Thu Aug 16 21:33:24 2012

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.

Connected to an idle instance.

SQL> startup nomount pfile=/local/opt/oracle/product/10.2.0.3/db5/dbs/initDSP0001.ora
ORA-27102: out of memory
Solaris-AMD64 Error: 22: Invalid argument

Solution:

*Solution:*   This error represents that max-shm-memory is not sized correctly.  Either reduce Oracle memory usage on appropriate parameters.  (OR) Increase max-shm-memory
In increase max-shm-memory, run following command as root:  Change the memory value based on your memory availability.
root@xnodb916:~# prctl -n project.max-shm-memory -v 25gb -r -i project user.oracle
root@xnodb916:~# prctl -n project.max-shm-memory -v 35gb -r -i project user.oracle

Reducing memory allocation on init***.ora fixed the issue.

Reduced shared_pool_size, pga_aggregate_target and db_cache_size.  Then started the DB successfully.

SQL> startup nomount pfile=/local/opt/oracle/product/10.2.0.3/db5/dbs/initDSP0001.ora
ORACLE instance started.

Total System Global Area 1.2046E+10 bytes
Fixed Size                  2191376 bytes
Variable Size             731680752 bytes
Database Buffers         1.1308E+10 bytes
Redo Buffers                4325376 bytes
SQL>

If AMM is enabled then SGA_TARGET and SGA_MAX_SIZE need to be reduced.

Advertisements

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: