Greg:
This is what I got from our SA.
You have to be root to be able to do this.
Good luck!
Barb,
A little firsthand knowledge is required... Namely,
you have to know the cluster resource group name of
the resource for the instance of oracle:
scstat -g
will list the resource groups at the top, the
resources below like:
pettyr_at_gremlin # scstat -g
- Resource Groups and Resources --
Group Name Resources
---------- ---------
Resources: class17db-rg class17db
class17db-hasp-rs class17db-lsnr-rs class17db-srvr-rs
Group Name Node Name
State
- ---------
Group: class17db-rg pacer
Offline
Group: class17db-rg gremlin
Online
Resource Name Node Name
State Status Message
------------- ---------
----- --------------
Resource: class17db pacer
Offline Offline
Resource: class17db gremlin
Online Online - LogicalHostname online.
Resource: class17db-hasp-rs pacer
Offline Offline
Resource: class17db-hasp-rs gremlin
Online Online
Resource: class17db-lsnr-rs pacer
Offline Offline
Resource: class17db-lsnr-rs gremlin
Online but not monitored Online
Resource: class17db-srvr-rs pacer
Offline Offline
Resource: class17db-srvr-rs gremlin
Online but not monitored Online
If you simply want to disable and enable the fault
monitor so you can stop and restart oracle, use the
following:
scswitch -n -M -j class17db-srvr-rs
scswitch -n -M -j class17db-lsnr-rs
Now, to enable the fault monitor:
scswitch -e -M -j class17db-srvr-rs
scswitch -e -M -j class17db-lsnr-rs
- Greg Faktor <FAKTORG_at_wyeth.com> 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).
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Barbara Baker
INET: barbarabbaker_at_yahoo.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 - 12:09:25 CST