Monday, March 6, 2017

unable to start Db after SGA upgrade.

we are trying to upgrade SGA on 12.1 DB on Linux but unfortunately after the SGA upgrade ,we  could not bring up the database and got the below error.


ORA-27137: unable to allocate Large Pages to create a shared memory segment

ERROR:
  Failed to allocate shared global region with large pages, unix errno = 1.
  Aborting Instance startup.
  ORA-27137: unable to allocate Large Pages to create a shared memory segment

ACTION:
1. Check the permission to access system large pages.
2. Large pages are automatically locked into physical memory.

Increase the per process memlock (soft) limit to at least 14 GB to lock

cause:
we noticed that huge-pages enabled on the server and we need to adjust huge pages related parameter to accommodate new SGA memory.

Solution:
1)check and update limits.conf hard/soft  values based on new SGA values
2)VM.NR-huge-pages values derive from oracle provided script.

pitfalls,
we cant use AMM


No comments:

Post a Comment