Skip to Main Content
  • Questions

  • configuration ORA-27146: post/wait initialization failed

Breadcrumb

Question and Answer

Tom Kyte

Thanks for the question, wallacel.

Asked: August 01, 2000 - 9:24 pm UTC

Last updated: February 02, 2005 - 4:55 am UTC

Version: 8.1.6

Viewed 1000+ times

You Asked

I shutdown my oracle server.
make some modification to init.ora file.
and then when i startup it, it give me error message:
ora-27146 post/wait initialization failed.

and then i check the file in udump and found following message:

ksedmp: internal or fatal error
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: sskgpcreates



I think the reason why it can't startup is because i increase the
value for db_block_buffer,db_files,shared_pool_size etc,
after i decrease a little bit, everything works fine.
my question is:
1.actually our server have 6G memory, and my SGA configuration only use something like 900M, why it can't increase anymore? well, it is ttue that this server also have
some other program runing, but i think it will not need much
memory.
2. how do i know how much memory are available for me in our
server after serveral other program runing?

Thanks,

and Tom said...

You need to increase your OS kernel settings for semaphores. You don't mention an OS so I cannot be very specific.

In Solaris, I would be editing my /etc/system file and setting parameters such as:

set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=10

set semsys:seminfo_semmni=500
set semsys:seminfo_semmsl=500
set semsys:seminfo_semmns=500
set semsys:seminfo_semopm=500
set semsys:seminfo_semvmx=32767
set semsys:seminfo_semmap=250
set semsys:seminfo_semmnu=500
set semsys:seminfo_semume=100


See the OS Install guide for your platform for specifics. See also
</code> http://asktom.oracle.com/pls/asktom/f?p=100:11:::::P11_QUESTION_ID:454420165038 <code>for guidelines



Rating

  (2 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Share memory and Semaphores on HP UX platform

Yu Dong, March 20, 2001 - 12:48 pm UTC

Very good answer. But what about HP UX platform? My server has 3 GB physical memory, for an application used by 300 concurrent users, with DB size about 30 GB, so SHMMMAX should be 3 GB, but what about SHMMIN, SHMMNI, SHMSEG and those about Semaphores (SEMMNI,SEMMNS)? An estimate on these would be a great guidance for my confirguation.




ORA-27302: failure occurred at:

ABC, February 01, 2005 - 6:34 pm UTC

ORA-1089 signalled during: alter database mount...
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
ORA-01089: immediate shutdown in progress - no operations are permitted
ORA-1092 signalled during: alter database open ...
ORA-27302: failure occurred at: skgpwreset1
ORA-27303: additional information: invalid shared ctx
ORA-01092: ORACLE instance terminated.
PLEASE SUGGEST

Tom Kyte
February 02, 2005 - 4:55 am UTC

no idea, no information as to what you were doing, what that means.

for it appears to be a cut and paste of a bunch of error stacks from various commands executed in some order.

no suggestions. other than "provide a clue as to what you were doing"

more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.