Wednesday, April 1, 2015

Adding Oracle RAC Service using srvctl command

[oracle@vmxrac01 ~]$ srvctl add service -db orcl -service orcl_hr -preferred orcl1,orcl2
[oracle@vmxrac01 ~]$
srvctl start service -d orcl -service orcl_hr
[oracle@vmxrac01 ~]$ srvctl config service  -db orcl -service orcl_hr
Service name: orcl_hr
Server pool:
Cardinality: 2
Disconnect: false
Service role: PRIMARY
Management policy: AUTOMATIC
DTP transaction: false
AQ HA notifications: false
Global: false
Commit Outcome: false
Failover type:
Failover method:
TAF failover retries:
TAF failover delay:
Connection Load Balancing Goal: LONG
Runtime Load Balancing Goal: NONE
TAF policy specification: NONE
Edition:
Pluggable database name:
Maximum lag time: ANY
SQL Translation Profile:
Retention: 86400 seconds
Replay Initiation Time: 300 seconds
Session State Consistency:
GSM Flags: 0
Service is enabled
Preferred instances: orcl1,orcl2
Available instances:
[oracle@vmxrac01 ~]$

[oracle@vmxrac01 ~]$ crsctl status res ora.orcl.orcl_hr.svc
NAME=ora.orcl.orcl_hr.svc
TYPE=ora.service.type
TARGET=ONLINE            , ONLINE
STATE=ONLINE on vmxrac01, ONLINE on vmxrac02

[oracle@vmxrac01 ~]$ crsctl status res ora.orcl.orcl_hr.svc -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.orcl.orcl_hr.svc
      1        ONLINE  ONLINE       vmxrac01                 STABLE
      2        ONLINE  ONLINE       vmxrac02                 STABLE
--------------------------------------------------------------------------------

[oracle@vmxrac01 ~]$ crsctl status res ora.orcl.orcl_hr.svc -p
NAME=ora.orcl.orcl_hr.svc
TYPE=ora.service.type
ACL=owner:oracle:rwx,pgrp:oinstall:r--,other::r--,group:dba:r-x,user:oracle:r-x
ACTIONS=
ACTION_SCRIPT=
ACTION_TIMEOUT=60
ACTIVE_PLACEMENT=0
AGENT_FILENAME=%CRS_HOME%/bin/oraagent%CRS_EXE_SUFFIX%
AGENT_PARAMETERS=
AQ_HA_NOTIFICATION=0
AUTO_START=restore
CARDINALITY=2
CHECK_INTERVAL=600
CHECK_TIMEOUT=30
CLB_GOAL=LONG
CLEAN_TIMEOUT=60
COMMIT_OUTCOME=0
DEGREE=1
DELETE_TIMEOUT=60
DESCRIPTION=Oracle Service resource
DTP=0
EDITION=
ENABLED=1
FAILOVER_DELAY=0
FAILOVER_METHOD=
FAILOVER_RETRIES=
FAILOVER_TYPE=
FAILURE_INTERVAL=0
FAILURE_THRESHOLD=0
GEN_SERVICE_NAME=orcl_hr
GLOBAL=false
GSM_FLAGS=0
HOSTING_MEMBERS=
INSTANCE_FAILOVER=1
INTERMEDIATE_TIMEOUT=0
LOAD=1
LOGGING_LEVEL=1
MANAGEMENT_POLICY=AUTOMATIC
MAX_LAG_TIME=ANY
MODIFY_TIMEOUT=60
NLS_LANG=
OFFLINE_CHECK_INTERVAL=0
PLACEMENT=restricted
PLUGGABLE_DATABASE=
RELOCATE_BY_DEPENDENCY=1
REPLAY_INITIATION_TIME=300
RESTART_ATTEMPTS=0
RETENTION=86400
RLB_GOAL=NONE
ROLE=PRIMARY
SCRIPT_TIMEOUT=60
SERVER_CATEGORY=
SERVER_POOLS=ora.orcl_orcl_hr
SERVICE_NAME=orcl_hr
SERVICE_NAME_PQ=
SERVICE_TYPE=MAIN
SESSION_NOREPLAY=false
SESSION_STATE_CONSISTENCY=
SQL_TRANSLATION_PROFILE=
START_CONCURRENCY=0
START_DEPENDENCIES=hard(ora.orcl.db,type:ora.cluster_vip_net1.type) weak(type:ora.listener.type) pullup(type:ora.cluster_vip_net1.type) pullup:always(ora.orcl.db)
START_TIMEOUT=600
STOP_CONCURRENCY=0
STOP_DEPENDENCIES=hard(intermediate:ora.orcl.db,type:ora.cluster_vip_net1.type)
STOP_TIMEOUT=600
TAF_FAILOVER_DELAY=
TAF_POLICY=NONE
TYPE_VERSION=3.2
UPTIME_THRESHOLD=1h
USER_WORKLOAD=yes
USE_STICKINESS=0
USR_ORA_DISCONNECT=false
USR_ORA_ENV=
USR_ORA_FLAGS=
USR_ORA_OPEN_MODE=
USR_ORA_OPI=false
USR_ORA_STOP_MODE=