Support Support Downloads Knowledge Base Case Manager My Juniper Community

Knowledge Base

Search our Knowledge Base sites to find answers to your questions.

Ask All Knowledge Base Sites All Knowledge Base Sites JunosE Defect (KA)Knowledge BaseSecurity AdvisoriesTechnical BulletinsTechnotes Sign in to display secure content and recently viewed articles

[Archive] Error: ORA-04031: unable to allocate 4200 bytes of shared memory



Article ID: KB6480 KB Last Updated: 26 Mar 2019Version: 5.0
Error: ORA-04031: unable to allocate 4200 bytes of shared memory
Short term fix is to reboot
Error: ORA-04031: unable to allocate 4200 bytes of shared memory
Try to login to Report Manager
The following solution applies to Report Manager:

The error message above is a message from the Oracle database process.  The error message indicates Oracle process's inability to allocate shared memory for its SGA (System Global Area).  On Solaris systems, this could be fixed by appending the following to the Solaris kernel config file, /etc/system:

set shmsys:shminfo_shmmax=4294967296
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=10
set semsys:seminfo_semmni=100
set semsys:seminfo_semmsl=100
set semsys:seminfo_semmns=200
set semsys:seminfo_semopm=100
set semsys:seminfo_semvmx=32767

shmmax is the maximum size of a single shared memory segment.  4294967296 is the recommended value by Oracle, regardless of the actual memory installed

shmseg is the maximum number of segments that can be attached by a process when the Oracle SGA exceeds the maximum size of a shared memory segment. 

SGA can also be fine-tuned in the initsid.ora files (DB_BLOCK_BUFFERS, DB_BLOCK_SIZE, etc) but be careful, because poor performance may result if too much memory is allocated for the shared memory from these files. 

Comment on this article > Affected Products Browse the Knowledge Base for more articles related to these product categories. Select a category to begin.

Getting Up and Running with Junos

Getting Up and Running with Junos Security Alerts and Vulnerabilities Product Alerts and Software Release Notices Problem Report (PR) Search Tool EOL Notices and Bulletins JTAC User Guide Customer Care User Guide Pathfinder SRX High Availability Configurator SRX VPN Configurator Training Courses and Videos End User Licence Agreement Global Search