Rechercher dans ce blog

jeudi 28 juin 2012

modifications d un service

[pocracm1.noam.transat.local:oracle:POCRAD1:/home/oracle]# srvctl   modify  service -help
Modifies the configuration for the service.
Usage: srvctl modify service -d <db_unique_name> -s <service_name> -i <old_inst_name> -t <new_inst_name> [-f]
    -d <db_unique_name>      Unique name for the database
    -s <service>             Service name
    -i <old_inst>            Old instance name
    -t <new_inst>            New instance name
    -f                       Disconnect all sessions during stop or relocate service operations
Usage: srvctl modify service -d <db_unique_name> -s <service_name> -i <avail_inst_name> -r [-f]
    -d <db_unique_name>      Unique name for the database
    -s <service>             Service name
    -i <avail_inst_name>     Name of available instance
    -r                       Upgrade instance to preferred
    -f                       Disconnect all sessions during stop or relocate service operations
Usage: srvctl modify service -d <db_unique_name> -s <service_name> -n -i "<preferred_list>" [-a "<available_list>"] [-f]
    -d <db_unique_name>      Unique name for the database
    -s <service>             Service name
    -n                       Modify service configuration
    -i "<preferred_list>"    Comma separated list of preferred instances
    -a "<available_list>"    Comma separated list of available instances
    -f                       Disconnect all sessions during stop or relocate service operations
Usage: srvctl modify service -d <db_unique_name> -s <service_name> [-g <pool_name>] [-c {UNIFORM | SINGLETON}] [-P {BASIC|NONE}] [-l [PRIMARY][,PHYSICAL_STANDBY][,LOGICAL_STANDBY][,SNAPSHOT_STANDBY]] [-y {AUTOMATIC | MANUAL}][-q {true|false}] [-x {true|false}] [-j {SHORT|LONG}] [-B {NONE|SERVICE_TIME|THROUGHPUT}] [-e {NONE|SESSION|SELECT}] [-m {NONE|BASIC}] [-z <integer>] [-w <integer>] [-t <edition>]
    -d <db_unique_name>      Unique name for the database
    -s <service>             Service name
    -g <pool_name>           Server pool name
    -c {UNIFORM | SINGLETON} Service runs on every active server in the server pool hosting this service (UNIFORM) or just one server (SINGLETON)
    -P {NONE | BASIC}        TAF policy specification
    -l <role>                Role of the service (primary, physical_standby, logical_standby, snapshot_standby)
    -y <policy>              Management policy for the service (AUTOMATIC or MANUAL)
    -e <Failover type>       Failover type (NONE, SESSION, or SELECT)
    -m <Failover method>     Failover method (NONE or BASIC)
    -w <integer>             Failover delay
    -z <integer>             Failover retries
    -t <edition>             Edition (or "" for empty edition value)
    -j <clb_goal>  Connection Load Balancing Goal (SHORT or LONG). Default is LONG.
    -B <Runtime Load Balancing Goal>     Runtime Load Balancing Goal (SERVICE_TIME, THROUGHPUT, or NONE)
    -x <Distributed Transaction Processing>  Distributed Transaction Processing (TRUE or FALSE)
    -q <AQ HA notifications> AQ HA notifications (TRUE or FALSE)
    -h                       Print usage

[mtlunt001:oracle:RADPERF2:/home/oracle/mg/cache]# srvctl  config service  -d RADPERF -s cskperf
Service name: cskperf
Service is enabled
Server pool: RADPERF_cskperf
Cardinality: 2
Disconnect: false
Service role: PRIMARY
Management policy: AUTOMATIC
DTP transaction: false
AQ HA notifications: false
Failover type: NONE
Failover method: NONE
TAF failover retries: 0
TAF failover delay: 0
Connection Load Balancing Goal: LONG
Runtime Load Balancing Goal: NONE
TAF policy specification: NONE
Edition:
Preferred instances: RADPERF1,RADPERF2
Available instances:


[[mtlunt001:oracle:RADPERF2:/home/oracle/mg/cache]#  srvctl  modify  service  -d  RADPERF -s cskperf -n -i RADPERF2 -a RADPERF1
[mtlunt001:oracle:RADPERF2:/home/oracle/mg/cache]#  srvctl  config service  -d RADPERF -s cskperf
Service name: cskperf
Service is enabled
Server pool: RADPERF_cskperf
Cardinality: 1
Disconnect: false
Service role: PRIMARY
Management policy: AUTOMATIC
DTP transaction: false
AQ HA notifications: false
Failover type: NONE
Failover method: NONE
TAF failover retries: 0
TAF failover delay: 0
Connection Load Balancing Goal: LONG
Runtime Load Balancing Goal: NONE
TAF policy specification: NONE
Edition:
Preferred instances: RADPERF2
Available instances: RADPERF1