GDSCTL>modify service -h
Syntax
(1)
- MODIFY service [-gdspool gdspool_name] -service service_name {[-preferred db_name_list] | [-available db_name_list]}
(2)
- MODIFY SERVICE [-gdspool gdspool_name] -service service_name
[-locality {ANYWHERE|LOCAL_ONLY}] [-region_failover]
[-role [PRIMARY | PHYSICAL_STANDBY [-failover_primary] | LOGICAL_STANDBY | SNAPSHOT_STANDBY]] [-lag {lag_value | ANY}] [-notification {TRUE|FALSE}]
[-rlbgoal {SERVICE_TME|THROUGHPUT}] [-clbgoal {SHORT | LONG}] [-tafpolicy {BASIC|NONE|PRECONNECT}] [-policy policy] [-failovertype {NONE|SESSION|SELECT|TRANSACTION}] [-failovermethod {NONE|BASIC}]
[-dtp {TRUE|FALSE}] [-sql_translation_profile ] [-failoverretry failover_retries] [-failoverdelay failover_delay]
[-edition edition] [-commit_outcome {TRUE|FALSE}] [-retention retention_seconds] [-session_state {DYNAMIC|STATIC}] [-replay_init_time replay_initiation_time]
(3)
- MODIFY SERVICE [-gdspool gdspool_name] -service service_name -old_db db_name -new_db db_name [-force]
(4)
- MODIFY SERVICE [-gdspool gdspool_name] -service service_name -available db_name_list -preferred
(5)
- MODIFY SERVICE [-gdspool gdspool_name] -service service_name {-preferred_all | {-modifyconfig -preferred db_name_list [-available db_name_list]}}
(6)
- MODIFY service [-gdspool gdspool_name] -service service_name -database db_name [-server_pool serv_pool_name|(-add_instances| -modify_instances) -preferred inst_list -available inst_list| -drop_instances inst_list] -cardinality {UNIFORM | SINGLETON}
Purpose
(1)
Add additional preferred and/or available databases to a global service.
Error if global service is of -preferred_all type.
(2)
Modify a global service.
(3)
Moves a global service from one database to another database.
Error if global service is of -preferred_all type.
(4)
Make specified available databases be preferred.Error if global service has -preferred_all set (as this would be redundant).
(5)
Change databases between preferred and available status.
(6)
Modify additional properties for a global service specific to a database.
Usage Notes
(1)
At least one preferred database or available database have to be specified.
(3)
If -force is specified, all sessions will be disconnected requiring the session using the global service to reconnect.
If -force is not specified, then sessions already connected to this global service stay connected, but new sessions cannot be established to the global service.
(5)
One of -preferred_all or -preferred must be specified. If preferred_all is specified, then all databases in the pool are preferred for this global service (new databases added to the pool will also have this global service added).
Databases that are not specified in either the preferred list or available list, but were previously assigned, will be removed.
If -force is specified, all sessions will be disconnected requiring the session using the global service to reconnect (potentially to another instance).
If -force is not specified, then sessions already connected to this global service stay connected, but new sessions cannot be established to the global service.
Keywords and Parameters
(1)
-gdspool the GDS pool.
-service the global service name.
-preferred a comma-delimited list of preferred databases.
-available a comma-delimited list of available databases.
(2)
-gdspool the GDS pool.
-service the global service name.
-locality the global service locality: ( ANYWHERE | LOCAL_ONLY).
-region_failover enable region failover (LOCAL_ONLY option).
-role specify the database role that the database must be for this global service to start. Applies only to GDS pools that contains a Data Guard Broker configuration.
-failover_primary enable global service for failover to primary. Applies only to global services with role PHYSICAL_STANDBY.
-lag specify the lag for the global service: ( number of seconds | "ANY" - for any lag).
-rlbgoal the runtime load balancing goal: ( SERVICE_TIME | THROUGHPUT).
-clbgoal the connection time load balancing goal: ( SHORT | LONG).
-notification AQ HA notifications: ( TRUE | FALSE).
-tafpolicy TAF policy specification.
-policy management policy for the global service: ( AUTOMATIC | MANUAL).
-failovertype failover type: ( NONE|SESSION|SELECT|TRANSACTION).
-failovermethod failover method: ( NONE | BASIC).
-failoverretry failover retries.
-failoverdelay failover delay.
-edition edition (or "" for empty edition value).
-commit_outcome commit outcome: ( TRUE | FALSE).
-retention retention time in seconds.
-session_state session state consistency: ( STATIC | DYNAMIC).
-replay_init_time replay initiation time in seconds.
-sql_translation_profile SQL translation profile.
-dtp Distributed Transaction Policy: ( TRUE | FALSE).
(3)
-gdspool the GDS pool.
-service the global service name.
-old_db the old database.
-new_db the new database.
-force force by disconnecting all sessions.
(4)
-gdspool the GDS pool.
-service the global service name.
-available a comma-delimited list of available databases to upgrade.
-preferred upgrade database to preferred.
(5)
-gdspool the GDS pool.
-service the global service name.
-preferred_all specify all databases in the GDS pool are preferred.
-modifyconfig use named databases only.
-preferred a comma-delimited list of preferred databases.
-available a comma-delimited list of available databases.
-force force.
(6)
-gdspool the GDS pool.
-service the global service name.
-database the database name.
-server_pool the server pool.
-cardinality: (UNIFORM - global service runs on every active node in the hosting server pool | SINGLETON- just on one node).
-add_instances add instances to configuration.
-modify_instances replace instance configuration.
-drop_instances remove instances from configuration.
-preferred a comma-delimited list of preferred instances.
-available a comma-delimited list of available instances.
Examples
(1)
GDSCTL> modify service -gdspool myreaderfarm -service sales_report -preferred db3
(2)
GDSCTL> modify service -gdspool myreaderfarm -service sales_report -rlbgoal THROUGHPUT
(3)
GDSCTL> modify service -gdspool myreaderfarm -service sales_report -old_db db1 -new_db db2
(4)
GDSCTL> modify service -gdspool myreaderfarm -service sales_report -available db2 -preferred
(5)
GDSCTL> modify service -gdspool myreaderfarm -service sales_report -preferred_all
(6)
GDSCTL> modify service -gdspool myreaderfarm -service sales_report -database db1 -server_pool serverpool1
