Jump to

• Request
• Response
• Examples

Update DB Credentials

post

/paas/api/v1.1/instancemgmt/{domainName}/services/SOA/instances/{serviceName}/updatedbcredentials

Updates the Database Administrator username and password. This is the Database Administrator username provided when the service was created. Also, supply the new password that will be set for all infrastructure database schemas.

This option is available for newly-created SOA Cloud Service instances. The instance must be in running state to reset the DB password.

Request

Path Parameters

• domainName: string
  Name of the identity domain for the Oracle Cloud Service account.
• serviceName: string
  Name of the Oracle SOA Cloud Service instance.

Body ()

The request body defines the database credentials.

Root Schema : updatedbcredentials

Type: object

The request body defines the database credentials.

Show Source

• components: object components

{
    "type":"object",
    "required":[
        "components"
    ],
    "description":"The request body defines the database credentials.",
    "properties":{
        "components":{
            "type":"object",
            "properties":{
                "WLS":{
                    "type":"object",
                    "properties":{
                        "dbaName":{
                            "type":"string",
                            "description":"Enter a username for the database administrator with DBA privilege."
                        },
                        "dbaPassword":{
                            "type":"string",
                            "description":"Enter a password for the database administrator with DBA privilege."
                        },
                        "schemaPassword":{
                            "type":"string",
                            "description":"Enter the new schema password which will be used to reset the password for existing infrastructure database schemas."
                        }
                    }
                }
            }
        }
    }
}

Nested Schema : components

Type: object

Show Source

• WLS(optional): object WLS

{
    "type":"object",
    "properties":{
        "WLS":{
            "type":"object",
            "properties":{
                "dbaName":{
                    "type":"string",
                    "description":"Enter a username for the database administrator with DBA privilege."
                },
                "dbaPassword":{
                    "type":"string",
                    "description":"Enter a password for the database administrator with DBA privilege."
                },
                "schemaPassword":{
                    "type":"string",
                    "description":"Enter the new schema password which will be used to reset the password for existing infrastructure database schemas."
                }
            }
        }
    }
}

Nested Schema : WLS

Type: object

Show Source

• dbaName(optional): string
  Enter a username for the database administrator with DBA privilege.
• dbaPassword(optional): string
  Enter a password for the database administrator with DBA privilege.
• schemaPassword(optional): string
  Enter the new schema password which will be used to reset the password for existing infrastructure database schemas.

{
    "type":"object",
    "properties":{
        "dbaName":{
            "type":"string",
            "description":"Enter a username for the database administrator with DBA privilege."
        },
        "dbaPassword":{
            "type":"string",
            "description":"Enter a password for the database administrator with DBA privilege."
        },
        "schemaPassword":{
            "type":"string",
            "description":"Enter the new schema password which will be used to reset the password for existing infrastructure database schemas."
        }
    }
}

Back to Top

Response

Supported Media Types

• application/json
• text/plain

202 Response

Accepted.

Back to Top

Examples

The following example shows how to change the password for the infrastructure repository schemas associated with an Oracle SOA Cloud Service instance by submitting a POST request on the REST resource using cURL.

Note: The command in this example uses the URL structure https://rest_server_url/resource-path, where rest_server_url is the REST server to contact for your identity domain (or Cloud account). See Send Requests.

cURL Command

curl -i -X POST -u username:password! -d @updatedbcredentials.json -H "Content-Type:application/json" -H "X-ID-TENANT-NAME:ExampleIdentityDomain" https://rest_server_url/paas/api/v1.1/instancemgmt/{domainName}/services/SOA/instances/ExampleInstance/updatedbcredentials

Example of Request Body

The following example shows the request body for changing the schema password.

{
    "components": {
        "WLS": {
            "dbaName": "name",
            "dbaPassword": "password",
            "schemaPassword": "newpassword"
        }
    }
}

Example of Response Header

The following example shows the response header. The Location header returns the URI that can be used to view the job status. See View the Status of an Operation by Job Id.

HTTP/1.1 202 Accepted
Date: Sat, 24 Jun 2021 18:32:30 GMT
Transfer-Encoding: chunked
Location: https://rest_server_url/paas/api/v1.1/activitylog/ExampleIdentityDomain/job/171232
Content-Type: application/vnd.com.oracle.oracloud.provisioning.Service+json
Service-URI: https://rest_server_url/paas/api/v1.1/instancemgmt/{domainName}/services/SOA/instances/ExampleInstance
Retry-After: 60

Example of Response Body

The following example shows the response document returned in JSON format.

{
   "details":
   {
      "message":"Submitted job to update [ExampleInstance] in domain [ExampleIdentityDomain].",
      "jobId":"171232"
   }
}

Back to Top