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