- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: unable to allocate shared memory
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-16-2003 07:08 AM
тАО01-16-2003 07:08 AM
My Oracle database keeps getting shared memory errors.
Ora-00604: error occurred at recursive SQL level 2.
Ora-04031: unable to allocate 4048 bytes of shared mem ("sharedpool") , "TRIGGERS$", "sga heap", "state objects")
Is this a Kernel Parameter thats needs tweaking or oracle
setting causing this ? Thanks
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-16-2003 07:15 AM
тАО01-16-2003 07:15 AM
Solutionoerr ORA 4031 gives the following:-
// *Cause: More shared memory is needed than was allocated in the shared
// pool.
// *Action: If the shared pool is out of memory, either use the
// dbms_shared_pool package to pin large packages,
// reduce your use of shared memory, or increase the amount of
// available shared memory by increasing the value of the
// INIT.ORA parameters "shared_pool_reserved_size" and
// "shared_pool_size".
// If the large pool is out of memory, increase the INIT.ORA
// parameter "large_pool_size".
As a first suggestion I'd increase shared_pool_reserved_size and shared_pool_size.
Regards,
John
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-16-2003 07:17 AM
тАО01-16-2003 07:17 AM
Re: unable to allocate shared memory
Rather than list the steps, your best bet (and specific to your platform and Oracle versions) is to run oerr.
oerr ora 00604
oerr ora 04031
Even if you are not a dba, this is a good command to know.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-16-2003 07:52 AM
тАО01-16-2003 07:52 AM
Re: unable to allocate shared memory
you need to increase the
shared_pool_size in the init
restart the database to take effect
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-16-2003 08:41 AM
тАО01-16-2003 08:41 AM
Re: unable to allocate shared memory
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-16-2003 09:43 AM
тАО01-16-2003 09:43 AM
Re: unable to allocate shared memory
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-17-2003 10:05 AM
тАО01-17-2003 10:05 AM
Re: unable to allocate shared memory
We are running on oracle patched to 8.1.7.4. HPUX 11i. and all is now stable.
Make sure you have the latest patches and then consider changing your Shared_pool_size settings. Remember to not increase oracle memory pools so large that they cause paging. If you can help it you need to buy memory.
I don't recommend regularly shutting down oracle to fix this problem. Becuase you affect production uptime. It also takes awhile for oracle to build cache, which will help performance.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-17-2003 06:48 PM
тАО01-17-2003 06:48 PM
Re: unable to allocate shared memory
Set shmmax to 1000 megs (1750 megs if you have Oracle executables linked to handle a large shared area). If you still have problems, you can implement memory windows (read the docs carefully) or switch to 64bit Oracle and all your shared memory limits disappear.
Bill Hassell, sysadmin