- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Not able to start up the Oracle DB.
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
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
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
08-09-2017 10:35 AM
08-09-2017 10:35 AM
Not able to start up the Oracle DB.
Dear Tech Leads,
I am not able to start up my oracle DB. Its showing the error
ORA-27102 - out of memory
HPUX-ia64 Error: 12: Not enough space.
RAM size is 20GB.
Please guide me to resolve this issue.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-09-2017 03:57 PM
08-09-2017 03:57 PM
Re: Not able to start up the Oracle DB.
The error is likely errno12 or ENOMEM. Oracle is unable to get the amount of RAM that it needs. However, it is likely due to a kernel parameter that is limiting the amount of RAM that a program can request rather than a system-wide shortage. This is likely a shared memory allocation failure, a detail that Oracle fails to disclose. If the database was working OK but the size of the SGA was recently increased by your DBA, this would cause the error.
The good news is that it is easy to fix. The kernel parameter is SHMMAX and you can see the value with:
kctune shmmax
(note: you did not specify the HP-UX version. If you are running 11.11, the command is kmtune)
Change the SHMMAX parameter to double the current value. If this allows Oracle to run, ask your DBA to let you know if further increases to SGA are planned. There is no problem in making SHMMAX much larger (10 GB for example) as it is just a limit and has no effect unless a program asks for a larger amount.
Bill Hassell, sysadmin