Wednesday, February 15, 2017

Steps to Create RAC Service on Windows


Add the service using the below command

>srvctl add service -d UKTILDB -s TIL_UKTILDB_TIBCO_UK -r UKTILDB1 -a UKTILDB2

The added service will be listed as offline since we are adding the service as our own user.

>crs_stat -t
Name           Type           Target    State     Host
------------------------------------------------------------
ora....DB2.srv application    ONLINE    ONLINE    ukti...b01a
ora....LING.cs application    ONLINE    ONLINE    ukti...b01a
ora....DB1.srv application    ONLINE    ONLINE    ukti...b01a
ora....IBCO.cs application    ONLINE    ONLINE    ukti...b01a
ora....DB1.srv application    OFFLINE   OFFLINE
ora....O_UK.cs application    OFFLINE   OFFLINE
ora....B1.inst application    ONLINE    ONLINE    ukti...b01a
ora....B2.inst application    ONLINE    ONLINE    ukti...b01b
ora.UKTILDB.db application    ONLINE    ONLINE    ukti...b01a
ora....SM1.asm application    ONLINE    ONLINE    ukti...b01a
ora....1A.lsnr application    ONLINE    ONLINE    ukti...b01a
ora....01a.gsd application    ONLINE    ONLINE    ukti...b01a
ora....01a.ons application    ONLINE    ONLINE    ukti...b01a
ora....01a.vip application    ONLINE    ONLINE    ukti...b01a
ora....SM2.asm application    ONLINE    ONLINE    ukti...b01b
ora....1B.lsnr application    ONLINE    ONLINE    ukti...b01b
ora....01b.gsd application    ONLINE    ONLINE    ukti...b01b
ora....01b.ons application    ONLINE    ONLINE    ukti...b01b
ora....01b.vip application    ONLINE    ONLINE    ukti...b01b


NAME=ora.UKTILDB.TIL_UKTILDB_TIBCO_UK.UKTILDB1.srv
TYPE=application
TARGET=OFFLINE
STATE=OFFLINE

NAME=ora.UKTILDB.TIL_UKTILDB_TIBCO_UK.cs
TYPE=application
TARGET=OFFLINE
STATE=OFFLINE

Login as Service account user and add the service account user to remote desktop user Still it will show the service  status offline.

>crs_stat -t

Name           Type           Target    State     Host
------------------------------------------------------------
ora....DB2.srv application    ONLINE    ONLINE    ukti...b01a
ora....LING.cs application    ONLINE    ONLINE    ukti...b01a
ora....DB1.srv application    ONLINE    ONLINE    ukti...b01a
ora....IBCO.cs application    ONLINE    ONLINE    ukti...b01a
ora....DB1.srv application    OFFLINE   OFFLINE
ora....O_UK.cs application    OFFLINE   OFFLINE
ora....B1.inst application    ONLINE    ONLINE    ukti...b01a
ora....B2.inst application    ONLINE    ONLINE    ukti...b01b
ora.UKTILDB.db application    ONLINE    ONLINE    ukti...b01a
ora....SM1.asm application    ONLINE    ONLINE    ukti...b01a
ora....1A.lsnr application    ONLINE    ONLINE    ukti...b01a
ora....01a.gsd application    ONLINE    ONLINE    ukti...b01a
ora....01a.ons application    ONLINE    ONLINE    ukti...b01a
ora....01a.vip application    ONLINE    ONLINE    ukti...b01a
ora....SM2.asm application    ONLINE    ONLINE    ukti...b01b
ora....1B.lsnr application    ONLINE    ONLINE    ukti...b01b
ora....01b.gsd application    ONLINE    ONLINE    ukti...b01b
ora....01b.ons application    ONLINE    ONLINE    ukti...b01b
ora....01b.vip application    ONLINE    ONLINE    ukti...b01b


Check the permission of the user

>crs_getperm ora.UKTILDB.TIL_UKTILDB_TIBCO_UK.UKTILDB1.srv
Name: ora.UKTILDB.TIL_UKTILDB_TIBCO_UK.UKTILDB1.srv
owner:system:rwx,pgrp::---,other::r--,

>crs_getperm ora.UKTILDB.TIL_UKTILDB_TIBCO_UK.cs
Name: ora.UKTILDB.TIL_UKTILDB_TIBCO_UK.cs
owner:system:rwx,pgrp::---,other::r--,

Then change the permission  to the service account owner.

>crs_setperm ora.UKTILDB.TIL_UKTILDB_TIBCO_UK.UKTILDB1.srv -o TIL\uktil02ighsorldb01


>crs_setperm ora.UKTILDB.TIL_UKTILDB_TIBCO_UK.cs -o TIL\uktil02ighsorldb01

>crs_getperm ora.UKTILDB.TIL_UKTILDB_TIBCO_UK.UKTILDB1.srv
Name: ora.UKTILDB.TIL_UKTILDB_TIBCO_UK.UKTILDB1.srv

>crs_getperm ora.UKTILDB.TIL_UKTILDB_TIBCO_UK.UKTILDB1.srv
Name: ora.UKTILDB.TIL_UKTILDB_TIBCO_UK.UKTILDB1.srv
owner:TIL\uktil02ighsorldb01:rwx,pgrp::---,other::r--,

Then start the service which was created earlier.

>srvctl start service -d UKTILDB -s TIL_UKTILDB_TIBCO_UK

>crs_stat -t

Name           Type           Target    State     Host
------------------------------------------------------------
ora....DB2.srv application    ONLINE    ONLINE    ukti...b01a
ora....LING.cs application    ONLINE    ONLINE    ukti...b01a
ora....DB1.srv application    ONLINE    ONLINE    ukti...b01a
ora....IBCO.cs application    ONLINE    ONLINE    ukti...b01a
ora....DB1.srv application    ONLINE    ONLINE    ukti...b01a
ora....O_UK.cs application    ONLINE    ONLINE    ukti...b01a
ora....B1.inst application    ONLINE    ONLINE    ukti...b01a
ora....B2.inst application    ONLINE    ONLINE    ukti...b01b
ora.UKTILDB.db application    ONLINE    ONLINE    ukti...b01a
ora....SM1.asm application    ONLINE    ONLINE    ukti...b01a
ora....1A.lsnr application    ONLINE    ONLINE    ukti...b01a
ora....01a.gsd application    ONLINE    ONLINE    ukti...b01a
ora....01a.ons application    ONLINE    ONLINE    ukti...b01a
ora....01a.vip application    ONLINE    ONLINE    ukti...b01a
ora....SM2.asm application    ONLINE    ONLINE    ukti...b01b
ora....1B.lsnr application    ONLINE    ONLINE    ukti...b01b
ora....01b.gsd application    ONLINE    ONLINE    ukti...b01b
ora....01b.ons application    ONLINE    ONLINE    ukti...b01b
ora....01b.vip application    ONLINE    ONLINE    ukti...b01b

======================================================



No comments:

Post a Comment