Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Oracle Error

Re: Oracle Error

From: Greg Faktor <FAKTORG_at_wyeth.com>
Date: Tue, 11 Nov 2003 07:04:40 -0800
Message-ID: <F001.005D654F.20031111070440@fatcity.com>


This is was my fault, I should not take db down (restart) in cluster environment. Some cluster command needs to be executed first before restart database. This cluster command (take db temporary from cluster or pause cluster) needs to be run as root user. Maybe some one has an example of this command?

Thanks.

>>> jkstill_at_cybcon.com 11/11/2003 9:34:26 AM >>>
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).
-- 
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).
Received on Tue Nov 11 2003 - 09:04:40 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US