Visit Counter

Monday, March 13, 2017

ORA-27102 Out of memory / Not enough space



I try to startup database getting below error. 

Solaris 11 64 Sparc Database 12c 


SQL> conn / as sysdba 
Connected to an idle instance. 
SQL> startup nomount pfile='/ora/app/oracle/product/12.2.0/dbhome_1/dbs/initinforln.ora'; 
ORA-27102: out of memory 
SVR4 Error: 12: Not enough space 
Additional information: 1671 
Additional information: 16106127360 
Additional information: 4513071104 
SQL> exit 
Disconnected 






Alert.log file
----------------

Mon Mar 13 12:30:57 2017 
Dump of system resources acquired for SHARED GLOBAL AREA (SGA) 

Mon Mar 13 12:30:57 2017 
Available system pagesizes: 
8K, 64K, 512K, 4096K, 32M, 256M 
Mon Mar 13 12:30:57 2017 
Supported system pagesize(s): 
Mon Mar 13 12:30:57 2017 
PAGESIZE AVAILABLE_PAGES EXPECTED_PAGES ALLOCATED_PAGES ERROR(s) 
Mon Mar 13 12:30:57 2017 
4096K Configured 10 1 ORA-27102 
Mon Mar 13 12:30:57 2017 
32M Configured 6 0 ORA-27102 
Mon Mar 13 12:30:57 2017 
256M Configured 16 0 ORA-27102 
Mon Mar 13 12:30:57 2017 
Reason for not supporting certain system pagesizes: 
Mon Mar 13 12:30:57 2017 
8K - Pagesize not supported by shared memory type 
Mon Mar 13 12:30:57 2017 
64K - Pagesize not supported by shared memory type 
Mon Mar 13 12:30:57 2017 
512K - Pagesize not supported by shared memory type 
Mon Mar 13 12:30:57 2017 
********************************************************************** 
-bash-4.1$ 




Solution:

I  added below parameter in parameter file and reboot the system.

Please check the following note: 
12C Database Instance Startup Fails With ORA-27102: OUT OF MEMORY Error On Solaris ( Doc ID 1987090.1 ) 

A workaround that has proven successful is to set the following parameter in the init/spfile and restart the database 



*._use_osm=FALSE





SQL>  startup nomount pfile='/ora/app/oracle/product/12.2.0/dbhome_1/dbs/initinforln.ora';
ORACLE instance started.

Total System Global Area 4529848320 bytes
Fixed Size                  2922936 bytes
Variable Size             973080136 bytes
Database Buffers         3539992576 bytes
Redo Buffers               13852672 bytes

SQL>







Refer:


https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=192956862419777&parent=SrDetailText&sourceId=3-14469331361&id=1987090.1&_afrWindowMode=0&_adf.ctrl-state=17xaia30lx_368





No comments:

Post a Comment