1. REST API for Oracle Java Cloud Service
  2. Tasks
  3. Service Instances

Change the Database Schema Password

post

/paas/api/v1.1/instancemgmt/{identityDomainId}/services/jaas/instances/{serviceId}/updatedbcredentials

Updates the password for the infrastructure repository schemas associated with the specified Oracle Java Cloud Service instance.

When the Oracle Java Cloud Service instance was created, it was associated with a database deployment that hosts the required infrastructure schema. By default the schema password was set to the WebLogic Server administrator password specified during the provisioning of your service instance. The initial schema password is set to expire in a certain number of days (for example, 180 days) after the service instance is created. If you do not update the schema password before it expires, you will get password expiry error messages for operations that require access to the infrastructure repository schemas.

Note: On Oracle Cloud Infrastructure Classic, this endpoint is not supported for service instances and backups that were created before the October 2017 release of Oracle Java Cloud Service (17.4.1).

Request

Supported Media Types
Path Parameters
Header Parameters
Body ()
The request body defines the details of the request.
Root Schema : schemapw-postrequestm
Type: object
Show Source
Nested Schema : components
Type: object
Groups properties for the Oracle WebLogic Server component (WLS).
Show Source
Nested Schema : WLS
Type: object
Properties for the Oracle WebLogic Server (WLS) component.
Show Source
  • User name for the database administrator that will be used to change the password for all the infrastructure repository schemas.

    This value must not be SYSTEM. Specify a database user that has been granted the SYSDBA privilege. For service instances based on Oracle WebLogic Server 12c, you can use the database user SYS.

    On Oracle Cloud Infrastructure: This value must be ADMIN if the associated infrastructure database is deployed on Oracle Autonomous Transaction Processing.

  • Password for the database administrator that was specified when the associated database deployment was created.
  • The new schema password to be set.

    The password must start with a letter. In addition:

    • For Oracle Autonomous Transaction Processing and Oracle Cloud Infrastructure Database (DB system): Must be between 12 and 30 characters long, and contain at least 2 lowercase letters, 2 uppercase letters, and 2 special characters.
    • For other database deployments: Must be between 8 and 30 characters long, and contain at least one number, and, optionally, any number of these special characters only: underscore (_), pound sign (#), dollar sign ($)

Back to Top

Response

Supported Media Types

202 Response

Accepted. The Location header returns a URI that can be used to view the job status. See View the Status of an Operation by Job Id.
Body ()
Root Schema : accepted-responsem
Type: object
The response body contains information about the operation. It can include an issues array for warning messages.
Show Source
Nested Schema : details
Type: object
Groups details of the operation.
Show Source
Nested Schema : issues
Type: array
Groups strings of warning messages, if any.
Show Source

400 Response

Bad Request. Returned if the request payload contains bad or missing details.

See Status Codes for information about other possible HTTP status codes.

Body ()
Root Schema : badrequest-responsem
Type: object
The response body contains information about the request. It can include an issues array for validation error messages.
Show Source
Nested Schema : details
Type: object
Groups details of the request.
Show Source
Nested Schema : issues
Type: array
Groups strings of validation error messages, if any.
Show Source
Back to Top

Examples

The following example shows how to change the password for the infrastructure repository schemas associated with an Oracle Java 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/ExampleIdentityDomain/services/jaas/instances/ExampleInstance/updatedbcredentials

Example of Request Body

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

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

Example of Response Header

The following shows an example of 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: Mon, 14 May 2017 18:32:30 GMT
Transfer-Encoding: chunked
Location: https://rest_server_url/paas/api/v1.1/activitylog/ExampleIdentityDomain/job/27617
Content-Type: application/json
Service-URI: https://rest_server_url/paas/api/v1.1/instancemgmt/ExampleIdentityDomain/services/jaas/instances/ExampleInstance
Retry-After: 60

Example of Response Body

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

{
   "details":{
      "message":"Submitted job to update DB credentials.",
      "jobId":"27617"
   }
}
Back to Top