RE: Oracle Error

Didn't this have to be in /etc/inittab or am I thinking of something totally different ???

Regards

Lee
-----Original Message-----
Sent: 11 November 2003 15:04
To: Multiple recipients of list ORACLE-L

I believe that post/wait driver has to be loaded from /etc/system or some other config file. Oracle tries to use post/wait driver for inter process communication because, generally speaking, it's faster then semaphores. There used to be a parameter called "use_pw" or "post_wait" or something like that. It is likely an undocumented parameter which is platform specific. It's the very same device driver that has to be loaded

into jAIX as a kernel extension when installing oracle on jAIX. Obviously, oracle on Slowaris doesn't perform that install automatically, as the one on jAIX so system admin has the pleasure all for himself.

On 11/11/2003 09:34:26 AM, Jared Still wrote:
> You need to dig into the sun reference manuals and find
> out what an error 36 is in reference to semaphores.
>
> They are online I believe, somewhere at sun.com.
> ..
>
> How about that? Your exact error is duplicated in a
> post on MetaLink. Did you check there?
>
> Sounds like someone was playing around with ipcrm whilst
> Oracle was up and running.
>
> Jared
>
>
> On Tue, 2003-11-11 at 06:09, Greg Faktor wrote:
> > Hi All!
> >
> > Oracle 920 on SunOS (Cluster)
> > A have a process that refresh data in the database . I shutdown
> > database and then start it up, before running refresh. This is errors
> > from my log file. After this happened all databases on this server were
> > shutdown and they never failover to the second node on the cluster.
> > I never seen this errors before, and in Metalink not much info about
> > it.
> > Any ideas?
> >
> > Connected.
> > Database closed.
> > Database dismounted.
> > ORACLE instance shut down.
> > ORA-27157: OS post/wait facility removed
> > ORA-27300: OS system dependent operation:semop failed with status: 36
> > ORA-27301: OS failure message: Identifier removed
> > ORA-27302: failure occurred at: sskgpwwait1
> > Connected to an idle instance.
> > truncate table xxxxxxxxxxxxxx
> > *
> > ERROR at line 1:
> > ORA-01034: ORACLE not available
> >
> > Thanks.
> >
> > Greg
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Greg Faktor
> > INET: FAKTORG_at_wyeth.com
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting services
> > ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Jared Still
> INET: jkstill_at_cybcon.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

Mladen Gogala
Oracle DBA

Note:
This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mladen Gogala
  INET: mladen_at_wangtrading.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).







**********************************************************************
The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged.
If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination, 
distribution, or copying of this communication is strictly
prohibited.
If you have received this communication in error,
please re-send this communication to the sender and
delete the original message or any copy of it from your
computer system. Thank You.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Robertson Lee - lerobe
  INET: lerobe_at_acxiom.co.uk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).