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. >>> [EMAIL PROTECTED] 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).