Home » Server Options » RAC & Failsafe » Stopping Oracle 11g R2 Cluster Services in Windows 2008 (Oracle 11g R2, 11.2.0.2.0, Windows 2008 Release 2)
icon5.gif  Stopping Oracle 11g R2 Cluster Services in Windows 2008 [message #575295] Tue, 22 January 2013 01:04 Go to next message
janetwilson
Messages: 48
Registered: June 2006
Location: St.Louis
Member
Hi,

I am doing the following steps for stopping the Oracle RAC Services on a 2 node.(OS is Windows 2008 Release 2).

srvctl stop database -d <database_name>

Node 1:
crsctl stop has

Node 2:
crsctl stop has

But i am getting error like Oracle HAS Service not stopped successfully.

Finally what i did was stopped the OHAS Service from Windows Services.

Please let me know which is the right procedure to have a clean stopping of RAC Services in 11g R2.

Thanks for your help.

Janet Wilson

[Updated on: Tue, 22 January 2013 01:05]

Report message to a moderator

Re: Stopping Oracle 11g R2 Cluster Services in Windows 2008 [message #575298 is a reply to message #575295] Tue, 22 January 2013 01:28 Go to previous messageGo to next message
janetwilson
Messages: 48
Registered: June 2006
Location: St.Louis
Member
Hi,

Following are the logs showing the error.

serverDB01>crsctl status resource -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DBDATA.dg
ONLINE ONLINE serverdb01
ONLINE ONLINE serverdb02
ora.DBFLASH.dg
ONLINE ONLINE serverdb01
ONLINE ONLINE serverdb02
ora.LISTENER.lsnr
ONLINE ONLINE serverdb01
ONLINE ONLINE serverdb02
ora.asm
ONLINE ONLINE serverdb01 Started
ONLINE ONLINE serverdb02
ora.gsd
ONLINE OFFLINE serverdb01
ONLINE OFFLINE serverdb02
ora.net1.network
ONLINE ONLINE serverdb01
ONLINE ONLINE serverdb02
ora.ons
ONLINE ONLINE serverdb01
ONLINE ONLINE serverdb02
ora.registry.acfs
ONLINE ONLINE serverdb01
ONLINE ONLINE serverdb02
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE serverdb02
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE serverdb01
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE serverdb01
ora.cvu
1 ONLINE ONLINE serverdb01
ora.db01.db
1 OFFLINE OFFLINE Instance Shutdown
2 OFFLINE OFFLINE Instance Shutdown
ora.db02.db
1 OFFLINE OFFLINE Instance Shutdown
2 OFFLINE OFFLINE Instance Shutdown
ora.db03.db
1 OFFLINE OFFLINE Instance Shutdown
2 OFFLINE OFFLINE Instance Shutdown
ora.db04.db
1 OFFLINE OFFLINE Instance Shutdown
2 OFFLINE OFFLINE Instance Shutdown
ora.db05.db
1 OFFLINE OFFLINE Instance Shutdown
2 OFFLINE OFFLINE Instance Shutdown
ora.oc4j
1 ONLINE UNKNOWN serverdb01
ora.scan1.vip
1 ONLINE ONLINE serverdb02
ora.scan2.vip
1 ONLINE ONLINE serverdb01
ora.scan3.vip
1 ONLINE ONLINE serverdb01
ora.serverdb01.vip
1 ONLINE ONLINE serverdb01
ora.serverdb02.vip
1 ONLINE ONLINE serverdb02





SERVERDB01>crsctl stop has
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'serverdb01'
CRS-2673: Attempting to stop 'ora.crsd' on 'serverdb01'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'serverdb01'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN2.lsnr' on 'serverdb01'
CRS-2679: Attempting to clean 'ora.oc4j' on 'serverdb01'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN3.lsnr' on 'serverdb01'
CRS-2673: Attempting to stop 'ora.cvu' on 'serverdb01'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'serverdb01'
CRS-2673: Attempting to stop 'ora.registry.acfs' on 'serverdb01'
CRS-2673: Attempting to stop 'ora.DBDATA.dg' on 'serverdb01'
CRS-2673: Attempting to stop 'ora.DBFLASH.dg' on 'serverdb01'
CRS-2677: Stop of 'ora.cvu' on 'serverdb01' succeeded
CRS-2672: Attempting to start 'ora.cvu' on 'serverdb02'
CRS-2680: Clean of 'ora.oc4j' on 'serverdb01' failed
CRS-2677: Stop of 'ora.LISTENER_SCAN3.lsnr' on 'serverdb01' succeeded
CRS-2673: Attempting to stop 'ora.scan3.vip' on 'serverdb01'
CRS-2677: Stop of 'ora.scan3.vip' on 'serverdb01' succeeded
CRS-2672: Attempting to start 'ora.scan3.vip' on 'serverdb02'
CRS-2677: Stop of 'ora.LISTENER_SCAN2.lsnr' on 'serverdb01' succeeded
CRS-2673: Attempting to stop 'ora.scan2.vip' on 'serverdb01'
CRS-2676: Start of 'ora.cvu' on 'serverdb02' succeeded
CRS-2677: Stop of 'ora.scan2.vip' on 'serverdb01' succeeded
CRS-2672: Attempting to start 'ora.scan2.vip' on 'serverdb02'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'serverdb01' succeeded
CRS-2673: Attempting to stop 'ora.serverdb01.vip' on 'serverdb01'
CRS-2677: Stop of 'ora.serverdb01.vip' on 'serverdb01' succeeded
CRS-2672: Attempting to start 'ora.serverdb01.vip' on 'serverdb02'
CRS-2676: Start of 'ora.serverdb01.vip' on 'serverdb02' succeeded
CRS-2677: Stop of 'ora.registry.acfs' on 'serverdb01' succeeded
CRS-2676: Start of 'ora.scan3.vip' on 'serverdb02' succeeded
CRS-2672: Attempting to start 'ora.LISTENER_SCAN3.lsnr' on 'serverdb02'
CRS-2676: Start of 'ora.scan2.vip' on 'serverdb02' succeeded
CRS-2672: Attempting to start 'ora.LISTENER_SCAN2.lsnr' on 'serverdb02'
CRS-2677: Stop of 'ora.DBFLASH.dg' on 'serverdb01' succeeded
CRS-2676: Start of 'ora.LISTENER_SCAN3.lsnr' on 'serverdb02' succeeded
CRS-2676: Start of 'ora.LISTENER_SCAN2.lsnr' on 'serverdb02' succeeded
CRS-2677: Stop of 'ora.DBDATA.dg' on 'serverdb01' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'serverdb01'
CRS-2677: Stop of 'ora.asm' on 'serverdb01' succeeded
CRS-2799: Failed to shut down resource 'ora.oc4j' on 'serverdb01'
CRS-2794: Shutdown of Cluster Ready Services-managed resources on 'serverdb01' has failed
CRS-2675: Stop of 'ora.crsd' on 'serverdb01' failed
CRS-2799: Failed to shut down resource 'ora.crsd' on 'serverdb01'
CRS-2795: Shutdown of Oracle High Availability Services-managed resources on 'serverdb01' has failed
CRS-4687: Shutdown command has completed with errors.
CRS-4000: Command Stop failed, or completed with errors.


Thanks
Janet

[Updated on: Tue, 22 January 2013 09:53]

Report message to a moderator

Re: Stopping Oracle 11g R2 Cluster Services in Windows 2008 [message #576991 is a reply to message #575298] Mon, 11 February 2013 11:22 Go to previous messageGo to next message
janetwilson
Messages: 48
Registered: June 2006
Location: St.Louis
Member
Hi,

Could anyone can have a look at this issue.

Thanks,
Janet
Re: Stopping Oracle 11g R2 Cluster Services in Windows 2008 [message #576996 is a reply to message #576991] Mon, 11 February 2013 12:05 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Hello - I would usually run

crsctl stop cluster -all -f
crsctl stop crs -f

I don't think there really is a "clean" shutdown concept. The clusterware isn't like a database: you don't have to worry about flushing any information to disc.

Hope this helps.
--
John Watson
http://skillbuilders.com

Re: Stopping Oracle 11g R2 Cluster Services in Windows 2008 [message #577128 is a reply to message #576996] Tue, 12 February 2013 11:21 Go to previous message
janetwilson
Messages: 48
Registered: June 2006
Location: St.Louis
Member
Thanks John for your reply.

In order to stop all the cluster resources, need to do the following

From Any Node execute

crsctl stop cluster -all -f

Node 1:
crsctl stop crs -f

Node 2:
crsctl stop crs -f

Please let me know if i am wrong.

As i dont have a test RAC environment, i have to wait for the next maintenance time to test it.

Thanks a lot.

Janet Wilson
Previous Topic: Doubt in using srvctl command
Next Topic: Master node in oracle 9i rac
Goto Forum:
  


Current Time: Thu Mar 28 06:52:51 CDT 2024