oci_database_management_managed_databases_reset_database_parameter
This resource provides the Managed Databases Reset Database Parameter resource in Oracle Cloud Infrastructure Database Management service.
Resets database parameter values to their default or startup values.
Example Usage
resource "oci_database_management_managed_databases_reset_database_parameter" "test_managed_databases_reset_database_parameter" {
#Required
managed_database_id = oci_database_management_managed_database.test_managed_database.id
parameters = var.managed_databases_reset_database_parameter_parameters
scope = var.managed_databases_reset_database_parameter_scope
#Optional
credentials {
#Optional
password = var.managed_databases_reset_database_parameter_credentials_password
role = var.managed_databases_reset_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_reset_database_parameter_database_credential_credential_type
#Optional
named_credential_id = oci_database_management_named_credential.test_named_credential.id
password = var.managed_databases_reset_database_parameter_database_credential_password
password_secret_id = oci_vault_secret.test_secret.id
role = var.managed_databases_reset_database_parameter_database_credential_role
username = var.managed_databases_reset_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 parameter names.scope
- (Required) The clause used to specify when the parameter change takes effect.Use
MEMORY
to make the change in memory and ensure that it takes effect 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 Reset Database Parameter
* update
- (Defaults to 20 minutes), when updating the Managed Databases Reset Database Parameter
* delete
- (Defaults to 20 minutes), when destroying the Managed Databases Reset Database Parameter
Import
Import is not supported for this resource.