Re: Oracle Error

I'm going to assume this is Veritas Cluster Server.

If so, why aren't you just doing this from the GUI?

It's a little simpler that way. You can see the commands being executed via the log viewer tearoff on the menu.

Jared

On Tue, 2003-11-11 at 07:04, Greg Faktor wrote:
> 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).

-- 
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).