modify database

Modifies the configuration parameters of the databases in a GDS pool, such as region, connect identifier, global service manager password, SCAN address, and ONS port.

Syntax

modify database -database db_name_list
               [-gdspool gdspool_name]
               [-shard shard_name]
               [-deploy_as PRIMARY|STANDBY]
               [-region region_name]
               [-pwd password]
               [-connect connect_identifier]
               [-scan scan_address]
               [-ons port]]
               [-savename]
               [-cpu_threshold cpu] 
               [-disk_threshold disk]
               [-rack rack_id]
               [-NETPARAM net_parameter_file | -NETPARAMFILE net_parameter_file]
               [-DBPARAM db_parameter | -DBPARAMFILE db_parameter_file]
               [-DBTEMPLATE db_template | -DBTEMPLATEFILE db_template_file]   

Options

Table 2-57 GDSCTL modify database Options

Option	Description
-connect connect_identifier	Specify an Oracle Net connect descriptor or a net service name that maps to a connect descriptor for the database that is being modified.
-cpu_threshold cpu	Specifies CPU Utilization percentage threshold.
-database dbname_list	Specify a comma-delimited list of database names.
-disk_threshold disk	Specifies the average latency in milliseconds of a synchronous single-block read.
-gdspool gdspool_name	Specify the database pool to which the databases belong.
-ons port	Specify the ONS port.
-pwd password	Specify the password for the GSMUSER.
-region region_name	Specify the region to which the databases belong.
-savename	Specify this option to store a net service name specified with the -connect option in the Global Data Services catalog, rather than the connect descriptor mapped to that net service name.
-scan scan_address	Specify the SCAN address for a cluster.

Usage Notes

You can multiple databases if the region property is specified.

For all parameters except for the GDS region, first the appropriate changes must be done by the database administrator and then the modify database command must be run to update the modified parameters in the GDS catalog. Alternatively, you can use the sync database (synchronize database)command for this purpose.

You must connect to the catalog database as a user with the pool administrator privileges, using the connect command before running this command

Example

Change the region of databases DB1 and DB3 to EAST.

GDSCTL> modify database -database db1,db3 -region east