Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Oracle Error
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
>
-- 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