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