Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id hABIHqB28008 for ; Tue, 11 Nov 2003 12:17:52 -0600 X-ClientAddr: 66.27.56.212 Received: from www3.fatcity.com (rrcs-west-66-27-56-212.biz.rr.com [66.27.56.212]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id hABIHqc28003 for ; Tue, 11 Nov 2003 12:17:52 -0600 Received: (from root@localhost) by www3.fatcity.com (8.11.6/8.11.6) id hABF0SD28509 for oracle-l@orafaq.net; Tue, 11 Nov 2003 07:00:28 -0800 Received: by fatcity.com (05-Jun-2003/v1.0g-b73/bab) via fatcity.com id 005D654F; Tue, 11 Nov 2003 07:04:40 -0800 Message-ID: Date: Tue, 11 Nov 2003 07:04:40 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Greg Faktor" Sender: ml-errors@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Greg Faktor" Subject: Re: Oracle Error Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 73; ListGuru (c) 1996-2003 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit 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@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@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@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@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@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@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@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).