- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Startup Oracle Instance 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
тАО04-14-2005 04:49 AM
тАО04-14-2005 04:49 AM
I have a HP_UX 11.11 system whith 4 GB RAM memory
***********************************************
Kernel :
max_thread_proc 64
nproc 2068
sema 1
semaem 16384
semmap 402
semmni 400
semmns 600
semmnu 30
semmsl 2048
semume 10
semvmx 32767
max_thread_proc 64
maxdsiz 1073741824
maxdsiz_64bit 2147483648
maxssiz 134217728
maxssiz_64bit 1073741824
maxtsiz 0x4000000
maxtsiz_64bit 0x40000000
maxuprc 1280
*****************************************
And I try to create the 8┬к instance:
oracle> startup
Report that errors:
ORA-27146: post/wait initialization failed
ORA-27300: OS system dependent operation:semget failed with status: 28
ORA-27301: OS failure message: No space left on device
ORA-27302: failure occurred at: sskgpsemsper
*** 2005-04-14 16:25:48.528
Can you help me? What kernel parameters i need to increase
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-14-2005 04:54 AM
тАО04-14-2005 04:54 AM
Re: Startup Oracle Instance error
Anil
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-14-2005 04:55 AM
тАО04-14-2005 04:55 AM
Re: Startup Oracle Instance error
This could also be the result of improper termination of Oracle process so that you have many, many IPCS resources in use. Do an ipcs -a and compare that to your running Oracle instances.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-14-2005 07:03 AM
тАО04-14-2005 07:03 AM
Re: Startup Oracle Instance error
Can be found on http://www.oracle.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-14-2005 12:04 PM
тАО04-14-2005 12:04 PM
Re: Startup Oracle Instance error
This error is related to insufficient semaphores.
Please set the value of "semmsl" to a high value say 3000 and rebuilt the kernel.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-14-2005 12:52 PM
тАО04-14-2005 12:52 PM
Re: Startup Oracle Instance error
The ORA-27146 means that the system is running out of semaphores. The problem is that there are not enough semaphores to start the instance. The cause for the error is that OS is short of semaphores. You can either decrease the "processes" parameter in the init.ora file, or increase number of semaphores on operating system. The semamphore parameter is called "semmns and semmni.
The first and most simple fix is to modify the init
With Oracle7:- The number of semaphores required by an instance is equal to the setting the 'processes' parameter in the init
With Oracle8, 8i and 9i:- The number of semaphores required by an instance is equal to 2 times the setting of the 'processes' parameter in the init
Indira A
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-14-2005 04:44 PM
тАО04-14-2005 04:44 PM
Solutionyou need to increase the kernel parameter SEMMNS.
Normally, the Kernel parameter is formula based (SEMMNI * 2). On our system it is currently set to 8192.
Metalink note 115235.1 says:
Set the kernel parameter SEMMNS to double the sum of all of the initSID.ora PROCESSES parameters on the system.
For example, if you have 5 instances with the initSID.ora PROCESSES parameter set to 25, 50, 100, 200, and 250, then set the kernel parameter SEMMNS equal to 1250.
((25 + 50 + 100 + 200 + 250) * 2) = 1250
hope this helps!
regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-14-2005 05:15 PM
тАО04-14-2005 05:15 PM
Re: Startup Oracle Instance error
you can check the semaphore usage using
$ipcs -sb |grep
Increase the semaphore kernel parameters and rebuild the kernel to use things up.