Ask the Community
Groups
Oracle Database on Solaris: Backup Fails with Out of Memory - Connect IT Community | Kaseya
<main> <article class="userContent"> <h2 data-id="issue"><strong>ISSUE</strong></h2> <p>RMAN operations consume additional process memory when opening a session to an Oracle Database instance. The system user's project must have a high enough shared memory allowance or the operation will fail with:<br> </p> <div><span style="font-family: courier;">ORA-27102: out of memory</span></div> <div><span style="font-family: courier;">Solaris-AMD64 Error: 22: Invalid argument</span></div> <h3 data-id="n-a"> </h3> <h2 data-id="resolution"><strong>RESOLUTION</strong></h2> <p></p> <h3 data-id="to-verify-and-increase-the-user-s-share-memory-run-the-following-as-the-system-user-running-the-backup-restore-operations">To verify and increase the user's share memory run the following:<br><br> As the system user running the backup/restore operations:<span style="font-family: courier;"> </span> </h3> <pre class="code codeBlock" spellcheck="false" tabindex="0"> id -p # Note the users numerical project id prctl -n project.max-shm-memory -i project # This will display the current shared memory allowance for the project. The PRIVILEGE VALUE that is set is 'privileged'</pre> <h3 data-id="as-root"> As root:<span style="font-family: courier;"> </span> </h3> <pre class="code codeBlock" spellcheck="false" tabindex="0"> prctl -n project.max-shm-memory -r -v -i project # This will set the shared memory allowance for the running environment. G,M suffixes may be used (4.5G). projmod -p -K 'project.max-shm-memory=(priveleged,,deny)' # This will set the share memory allowance to survive a restart. G,M suffixes may be used (4.5G).</pre> <h3 data-id="referencesoracle-database-11g-release-2-on-oracle-solaris-release-notes-section-4-1-1http-docs-oracle-com-cd-e11882-01-relnotes-112-e23559-toc-htm"> <span style="font-family: courier;"><b><span style="font-size: small; font-family: arial,helvetica,sans-serif;">References</span></b><br><br>Oracle Database 11g Release 2 on Oracle Solaris Release Notes - Section 4.1.1</span><br><a rel="nofollow" href="/home/leaving?allowTrusted=1&target=http%3A%2F%2Fdocs.oracle.com%2Fcd%2FE11882_01%2Frelnotes.112%2Fe23559%2Ftoc.htm" title="Oracle">http://docs.oracle.com/cd/E11882_01/relnotes.112/e23559/toc.htm</a> </h3> <div id="_mcePaste">ORA-27102: out of memory</div> <div>Solaris-AMD64 Error: 22: Invalid argumentA-27102: out of memory</div> <h2 data-id="notes"><strong>NOTES</strong></h2> <p>For more detailed information on backup failures and performance issues see <a rel="nofollow" href="/home/leaving?allowTrusted=1&target=https%3A%2F%2Funitrends-support.zendesk.com%2Fhc%2Fen-us%2Farticles%2F360013174757">Unitrends KB 5062 - Backup Failures and Performance Issues</a></p> </article> </main>