RE: oracle handing memory allocation different between 11g and 12c?

From: Dimensional DBA <dimensional.dba_at_comcast.net>
Date: Fri, 12 Feb 2016 08:35:14 -0800
Message-ID: <062a01d165b3$5a3a5a20$0eaf0e60$_at_comcast.net>



There is a difference for Solaris

https://docs.oracle.com/database/121/UNXAR/appe_sol.htm#UNXAR013    

Matthew Parker

Chief Technologist

Dimensional DBA

425-891-7934 (cell)

D&B 047931344

CAGE 7J5S7 Dimensional.dba_at_comcast.net

 <http://www.linkedin.com/pub/matthew-parker/6/51b/944/> View Matthew Parker's profile on LinkedIn

www.dimensionaldba.com    

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Matt Adams
Sent: Friday, February 12, 2016 7:36 AM
To: oracle-l_at_freelists.org
Subject: oracle handing memory allocation different between 11g and 12c?  

OS: Solaris 10 running on a zone of a T-4  

I'm attempting to upgrade a database from 11.2.0.4 to 12.1.0.4  

After running all prerequisite checks and resolving issues, I'm ready to run the upgrade  

Starting the database using the 12c software, I'm getting the following  

SQL> startup upgrade

ORA-27125: unable to create shared memory segment

SVR4 Error: 22: Invalid argument

Additional information: 2634

Additional information: 4194304

Additional information: 4194304  

Sga_max_size is 1 G (same size used when database was 11g)

Sga_targeet is 1 G  

(lowering both of these to 500 Meg makes no difference)
 

Ipcs -a shows roughly 2.5 gig being used by other 11 g datbases on this server.  

/etc/project has

user.oracle:100::oracle::project.max-sem-ids=(priv,100,deny);project.max-shm -memory=(priv,5368709120,deny);rcap.max-rss=19327352832  

(which I understand to mean that the total of all shared memory segments is
limited to 5 Gig.)  

Is there something different between the 11g and 12c versions that might explain this?    

The alert log is showing:  

Fri Feb 12 10:29:30 2016

Starting ORACLE instance (normal) (OS id: 14926)

Fri Feb 12 10:29:30 2016

CLI notifier numLatches:3 maxDescs:1344

Fri Feb 12 10:29:30 2016

All SGA segments were allocated at startup

Fri Feb 12 10:29:30 2016

WARNING: The system does not seem to be configured

optimally. Creating a segment of size 0x0000000000400000

failed. Please change the shm parameters so that

a segment can be created for this size. While this is

not a fatal issue, creating one segment may improve

performance

Fri Feb 12 10:29:30 2016


Fri Feb 12 10:29:30 2016

Dump of system resources acquired for SHARED GLOBAL AREA (SGA)  

Fri Feb 12 10:29:30 2016

Available system pagesizes:

  8K, 64K, 4096K, 256M, 2048M

Fri Feb 12 10:29:30 2016

Supported system pagesize(s):

Fri Feb 12 10:29:30 2016

  PAGESIZE AVAILABLE_PAGES EXPECTED_PAGES ALLOCATED_PAGES ERROR(s)

Fri Feb 12 10:29:30 2016

     4096K Configured 63 0 ORA-27125

Fri Feb 12 10:29:30 2016

      256M Configured 1 0 NONE

Fri Feb 12 10:29:30 2016

     2048M Configured 0 0 NONE

Fri Feb 12 10:29:30 2016

Reason for not supporting certain system pagesizes:

Fri Feb 12 10:29:30 2016

  8K - Pagesize not supported by shared memory type

Fri Feb 12 10:29:30 2016

  64K - Pagesize not supported by shared memory type

Fri Feb 12 10:29:30 2016


  • This communication may contain privileged and/or confidential information. If you are not the intended recipient, you are hereby notified that disclosing, copying, or distributing of the contents is strictly prohibited. If you have received this message in error, please contact the sender immediately and destroy any copies of this document. ****
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Feb 12 2016 - 17:35:14 CET

Original text of this message