Changes database parameter values.
POST {{baseUrl}}/managedDatabases/:managedDatabaseId/actions/changeDatabaseParameters
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.
Request Body
{"scope"=>"MEMORY", "parameters"=>[{"name"=>"<string>", "value"=>"<string>", "updateComment"=>"<string>"}, {"name"=>"<string>", "value"=>"<string>", "updateComment"=>"<string>"}], "credentials"=>{"password"=>"<string>", "role"=>"NORMAL", "secretId"=>"<string>", "userName"=>"<string>"}, "databaseCredential"=>{"credentialType"=>"SECRET"}}
HEADERS
Key | Datatype | Required | Description |
---|---|---|---|
opc-request-id | string | The client request ID for tracing. | |
opc-retry-token | string | A token that uniquely identifies a request so it can be retried in case of a timeout or | |
server error without risk of executing that same action again. Retry tokens expire after 24 | |||
hours, but can be invalidated before then due to conflicting operations. For example, if a resource | |||
has been deleted and purged from the system, then a retry of the original creation request | |||
might be rejected. | |||
Content-Type | string | ||
Accept | string |
RESPONSES
status: OK
{"status":{"nostrud532":{"errorCode":"\u003cstring\u003e","errorMessage":"\u003cstring\u003e","status":"FAILED"}}}