oci_database_management_managed_databases_change_database_parameter
This resource provides the Managed Databases Change Database Parameter resource in Oracle Cloud Infrastructure Database Management service.
Changes database parameter values. There are two kinds of database parameters:
- Dynamic parameters: They can be changed for the current Oracle Database instance. The changes take effect immediately.
- Static parameters: They cannot be changed for the current instance. You must change these parameters and then restart the database before changes take effect.
Note: If the instance is started using a text initialization parameter file, the parameter changes are applicable only for the current instance. You must update them manually to be passed to a future instance.
Example Usage
resource "oci_database_management_managed_databases_change_database_parameter" "test_managed_databases_change_database_parameter" {
#Required
managed_database_id = oci_database_management_managed_database.test_managed_database.id
parameters {
#Required
name = var.managed_databases_change_database_parameter_parameters_name
value = var.managed_databases_change_database_parameter_parameters_value
#Optional
update_comment = var.managed_databases_change_database_parameter_parameters_update_comment
}
scope = var.managed_databases_change_database_parameter_scope
#Optional
credentials {
#Optional
password = var.managed_databases_change_database_parameter_credentials_password
role = var.managed_databases_change_database_parameter_credentials_role
secret_id = oci_vault_secret.test_secret.id
user_name = oci_identity_user.test_user.name
}
database_credential {
#Required
credential_type = var.managed_databases_change_database_parameter_database_credential_credential_type
#Optional
named_credential_id = oci_database_management_named_credential.test_named_credential.id
password = var.managed_databases_change_database_parameter_database_credential_password
password_secret_id = oci_vault_secret.test_secret.id
role = var.managed_databases_change_database_parameter_database_credential_role
username = var.managed_databases_change_database_parameter_database_credential_username
}
}
Argument Reference
The following arguments are supported:
credentials
- (Optional) The database credentials used to perform management activity. Provide one of the following attribute set. (userName, password, role) OR (userName, secretId, role) OR (namedCredentialId)password
- (Optional) The password for the database user name.role
- (Optional) The role of the database user. Indicates whether the database user is a normal user or sysdba.secret_id
- (Optional) The OCID of the secret containing the user password.user_name
- (Optional) The database user name used to perform management activity.
database_credential
- (Optional) The credential to connect to the database to perform tablespace administration tasks.credential_type
- (Required) The type of the credential for tablespace administration tasks.named_credential_id
- (Required when credential_type=NAMED_CREDENTIAL) The OCID of the named credential where the database password metadata is stored.password
- (Required when credential_type=PASSWORD) The database user’s password encoded using BASE64 scheme.password_secret_id
- (Required when credential_type=SECRET) The OCID of the Secret where the database password is stored.role
- (Applicable when credential_type=PASSWORD | SECRET) The role of the database user.username
- (Applicable when credential_type=PASSWORD | SECRET) The user to connect to the database.
managed_database_id
- (Required) The OCID of the Managed Database.parameters
- (Required) A list of database parameters and their values.name
- (Required) The parameter name.update_comment
- (Optional) A comment string to associate with the change in parameter value. It cannot contain control characters or a line break.value
- (Required) The parameter value.
scope
- (Required) The clause used to specify when the parameter change takes effect.Use
MEMORY
to make the change in memory and affect it immediately. UseSPFILE
to make the change in the server parameter file. The change takes effect when the database is next shut down and started up again. UseBOTH
to make the change in memory and in the server parameter file. The change takes effect immediately and persists after the database is shut down and started up again.
** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values
Attributes Reference
The following attributes are exported:
status
- A map with the parameter name as key and its update status as value.error_code
- An error code that defines the failure ornull
if the parameter was updated successfully.error_message
- The error message indicating the reason for failure ornull
if the parameter was updated successfully.status
- The status of the parameter update.
Timeouts
The timeouts
block allows you to specify timeouts for certain operations:
* create
- (Defaults to 20 minutes), when creating the Managed Databases Change Database Parameter
* update
- (Defaults to 20 minutes), when updating the Managed Databases Change Database Parameter
* delete
- (Defaults to 20 minutes), when destroying the Managed Databases Change Database Parameter
Import
Import is not supported for this resource.