- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle error
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
тАО03-03-2005 09:54 PM
тАО03-03-2005 09:54 PM
Oracle error
I am new to oracle .
I am getting the following error while strating up oracle.
% sqlplus "/as sysdba"
SQL*Plus: Release 9.2.0.4.0 - Production on Fri Mar 4 15:56:50 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to an idle instance.
SQL> startup
ORA-04031: unable to allocate 95400 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","qmps connections")
Please help,
Thanks
Sreejith M
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-03-2005 10:03 PM
тАО03-03-2005 10:03 PM
Re: Oracle error
In most cases this is either shared pool is too smal or is fragmented.
As this is happening when you start the database, I would look at 1st case.
Is this the 1st time you start this database ?
What are the shared_pool parameters in the init.ora file ?
Available memory on the server ?
Regards
Jean-Luc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-03-2005 10:34 PM
тАО03-03-2005 10:34 PM
Re: Oracle error
I have made the changes in init.ora file , saved it , then run the comand "startup" from sql> prompt.. But same error.
Do i have to do anything else after modifying these parameters
Thanks
Sreejith M
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-03-2005 11:03 PM
тАО03-03-2005 11:03 PM
Re: Oracle error
Has this database started before ? (or is this "never") If yes do you still have the init.ora file to compare with current for differences ?
Regards
Jean-Luc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-04-2005 01:52 AM
тАО03-04-2005 01:52 AM
Re: Oracle error
kmtune | grep shmmax
This should return a number larger than what you're trying to allocate. If not, it's time to make it larger. This may or may not actually stop you from allocating the memory - but it could cut it up into a lot of chunks.
What's more likely to stop you from getting there at all is maxdsiz - if you're running the 64 bit version of the database you need to review maxdsiz_64bit. You may also need to review the size of maxtsiz and maxtsiz_64bit - but that's less likely - but good to look at anyway.
You can look at all of your "max" type kernel parameters with:
kmtune | grep -i max
HTH