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

KeyDatatypeRequiredDescription
opc-request-idstringThe client request ID for tracing.
opc-retry-tokenstringA 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-Typestring
Acceptstring

RESPONSES

status: OK

{&quot;status&quot;:{&quot;nostrud532&quot;:{&quot;errorCode&quot;:&quot;\u003cstring\u003e&quot;,&quot;errorMessage&quot;:&quot;\u003cstring\u003e&quot;,&quot;status&quot;:&quot;FAILED&quot;}}}