Thursday, January 24, 2013

How to start/stop Clusterware service in Oracle 10gr2 RAC

Oracle Clusterware services in a Windows RAC environment should be allowed to start automatically, ideally, with the help of the Oracle Process Manager Service (OPMD). If it is not installed already then you can do the following on the concerned node's command prompt - opmd.exe -install .

Oracle Process Manager Daemon (OPMD)—OPMD is registered with the Windows Service Control Manager (WSCM) and the startup of all Oracle Clusterware services is dependent on OPMD. On system startup, and after the default time period of 60 seconds has elapsed, OPMD automatically starts all of the registered Oracle Clusterware services. This startup delay enables other services to start that are outside of the scope of Oracle control, such as storage access, anti-virus, or firewall services. You can set OPMD to start manually. However, this will delay the startup of the rest of the affected Oracle Clusterware components.The opmd.exe allows the creation of a new service called the ‘Oracle Process Manager’. The Oracle Process Manager will control the startup of the clustering services to prevent the 'OracleCSService' from starting up before the rest of the OS services have started.

You can check the oracle background process in windows by,
set line 100
col program format a20
col description format a32
select A.SID, A.STATUS, A.PROGRAM, B.NAME, B.Description
from v$session A, v$bgprocess B
where A.PADDR=B.PADDR
and A.type='BACKGROUND';


Following is an outline of how to start Oracle Clusterware services manually if it should become necessary to do so.


1- Try starting crs with "crsctl start crs" command from $CRS_HOME\bin directory 
OR
2.  Start the following services from Windows 'Services' or by using the Windows command 'net start at the command prompt:
            a.  If OPMD is present, then start the service:  OracleProcessManagerService.  In addititon to OPMD, start the  OracleClusterVolumeService
if you are using Oracle Cluster File System (OCFS) in your environment.

             b. If OPMD is not present then start the following services in the order provided:
                    OracleObjectService
                    OracleClusterVolumeService (if using OCFS)
                    OracleCSService
                    OracleEVMService
                    OracleCRService


To stop these services, the same instructions can be followed in reverse.

The reverse command for 'crsctl start crs' is 'crsctl stop crs.'  

However, it is advised that when stopping CRS the resources managed by the OCR are safely brought down before stopping the underlying clusterware services.  


Note that issuing 'crsctl stop crs' without first issuing 'srvctl stop nodeapps -n ' command will cause the ons.exe to continue running and so the ons.exe must be stopped from task manager before clusterware services are considered completely down. 

No comments:

Post a Comment