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

From: Matt Adams <MAdams_at_TroverSolutions.com>
Date: Fri, 12 Feb 2016 15:36:04 +0000
Message-ID: <2770ff66d0e543dd99b5e865c25480f1_at_wpvl1dag02.hcrec.com>

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 - 16:36:04 CET