Patch an Oracle Database Software home
patch
/workingcopies/{workingCopyId}/databases
Moves a database from a source working copy to a patched working copy.
Request
Supported Media Types
- application/json
Path Parameters
-
workingCopyId: string
Name of the working copy.
Header Parameters
-
Authorization: string
Base64 encoding of the user name and password of the user making the request. For more information, see Authentication for Fleet Patching and Provisioning.
Root Schema : MoveDatabaseBody
Type:
Show Source
object
-
abort(optional):
boolean
Default Value:
false
Abort the ongoing "move" operation. -
agpath(optional):
string
Read/write path for the persistent Oracle home path.
-
aupath(optional):
string
Read-only gold image path for the persistent Oracle home path.
-
auth(optional):
string
Use an authentication plugin to access the remote node.
-
authArgs(optional):
object authArgs
Additional Properties Allowed: additionalPropertiesAdditional properties for the selected authentication plugin.
-
cc(optional):
string
List of users to whom email notifications will be sent, in addition to owner of working copy.
-
client(optional):
string
Client cluster name
-
continueRestart(optional):
boolean
Default Value:
false
Continue restarting databases on the next batch of nodes. -
dbname(optional):
string
Name of database (DB_UNIQUE_NAME) to be provisioned.
-
disconnect(optional):
boolean
Default Value:
false
Disconnect all sessions before stopping or relocating services. -
drain_timeout(optional):
integer(int32)
Service drain timeout specified in seconds.
-
eval(optional):
boolean
Default Value:
false
Evaluate without executing the command. -
ignorewcpatches(optional):
boolean
Default Value:
false
Ignores if the patched working copy is missing some patches which are present in the source path or working copy. -
keepplacement(optional):
boolean
Default Value:
false
Ensure that services of administrator-managed Oracle RAC or Oracle RAC One databases are running on the same instances before and after the move operation. -
noDataPatch(optional):
boolean
Default Value:
false
Indicates that "datapatch" should not be executed for databases being moved. -
noreplay(optional):
boolean
Default Value:
false
Disable session replay during disconnection. -
notify(optional):
boolean
Default Value:
false
Send email notification. -
oraclebase(optional):
string
ORACLE_BASE path for provisioning Oracle database home or Oracle Grid Infrastructure home.
-
patchedwc(optional):
string
Name of the patchedwc to which the database needs to be moved
-
path(optional):
string
Absolute path location of the software home (This will be the ORACLE_HOME).
-
revert(optional):
boolean
Default Value:
false
Revert to source Oracle home or working copy in case of batch-move or smartmove. -
root(optional):
boolean
Default Value:
false
Use root credentials to access the remote node. -
saf(optional):
string
Service availability factor, the minimum percentage of instances on which a service must remain running during the move.
-
schedule(optional):
string
Preferred time to execute the operation, in ISO-8601 format. For example: 2016-12-21T19:13:17+05.
-
separate(optional):
boolean
Default Value:
false
Process batches separately. Move operation pauses for user intervention before continuing with the next batch. -
skip(optional):
boolean
Default Value:
false
Skip current batch of nodes and restart databases on the next batch of nodes. -
sourceHome(optional):
string
Source Oracle home path
-
stopoption(optional):
string
Allowed Values:
[ "ABORT", "IMMEDIATE", "NORMAL", "TRANSACTIONAL", "TRANSACTIONAL_LOCAL" ]
Stop option for database: ABORT, IMMEDIATE, NORMAL, TRANSACTIONAL, TRANSACTIONAL_LOCAL. -
sudoPath(optional):
string
location of sudo binary.
-
sudoUser(optional):
string
perform super user operations as sudo user name.
-
superUserPasswd(optional):
string
The password for the super user account.
-
targetNode(optional):
string
Node on which operation needs to be executed
-
userActionData(optional):
string
Value to be passed to useractiondata parameter of useraction script
Nested Schema : authArgs
Type:
object
Additional Properties Allowed
Show Source
Additional properties for the selected authentication plugin.
Security
-
basicAuthentication: basic
Type:
basic
Response
Supported Media Types
- application/json
202 Response
Accepted. A JSON object containing job resource details of the accepted operation to obtain status and output of the progress.
Headers
-
Location: string
URL to the job that will execute the operation
Nested Schema : singleResourceLinks
Type:
Show Source
object
-
href(optional):
string
The referenced hyperlink element provided in an absolute format.
-
rel(optional):
string
Allowed Values:
[ "self", "collection", "up", "describedBy" ]
Specify the type of relationship the link has with the described resource.
Nested Schema : collectionResourceLinks
Type:
Show Source
object
-
href(optional):
string
The referenced hyperlink element provided in an absolute format with the correct URL parameters.
-
rel(optional):
string
Allowed Values:
[ "next", "prev", "first", "last" ]
Specify the type of relationship the link has with the described resource.
400 Response
Bad Request. A JSON object containing error details of the issue found while parsing a parameter value or name.
Root Schema : errorResource
Type:
Show Source
object
-
errorCode(optional):
string
Application specific error code, related to the error message shown at title.
-
errorDetails(optional):
array errorDetails
If multiple errors are reported they can be organized in a hierarchical structure in this array.
-
errorPath(optional):
string
XPath or JSON path to indicate where the error occurs.
-
instance(optional):
string
URI to the link that provides more detail about the error.
-
status(optional):
integer
HTTP status code.
-
title(optional):
string
Summary error message.
-
type(optional):
string
Link to HTTP error code page.
Nested Schema : errorDetails
Type:
array
If multiple errors are reported they can be organized in a hierarchical structure in this array.
Show Source
Default Response
Unexpected error. A JSON object containing error details of the issue while executing the operation.
Root Schema : errorResource
Type:
Show Source
object
-
errorCode(optional):
string
Application specific error code, related to the error message shown at title.
-
errorDetails(optional):
array errorDetails
If multiple errors are reported they can be organized in a hierarchical structure in this array.
-
errorPath(optional):
string
XPath or JSON path to indicate where the error occurs.
-
instance(optional):
string
URI to the link that provides more detail about the error.
-
status(optional):
integer
HTTP status code.
-
title(optional):
string
Summary error message.
-
type(optional):
string
Link to HTTP error code page.
Nested Schema : errorDetails
Type:
array
If multiple errors are reported they can be organized in a hierarchical structure in this array.
Show Source
Examples
The following example shows how to patch an Oracle database named dbwc1
from a working copy named DB_WCopy1
to a patched working copy named DB_WCopy2
, by submitting a PATCH request on the REST resource using cURL.
curl -u restUser -X PATCH -H "Content-Type: application/json" -d "@body.json" "https://RHP_node_name:8894/rhp-restapi/rhp/workingcopies/DB_WCopy1/databases"
HTTP Status Code and Response Headers
The following shows an example of the response header.
HTTP/1.1 202
Location: https://RHP_node_name:8894/rhp-restapi/rhp/jobs/1
Access-Control-Allow-Origin: *
Access-Control-Allow-Credentials: true
Access-Control-Allow-Methods: GET,PUT,POST,DELETE,PATCH,OPTIONS
Access-Control-Allow-Headers: X-Requested-With, Content-Type, Content-Length, Authorization
Connection: keep-alive
Content-Type: application/json
Content-Length: 159
Date: Tue, 19 Jun 2018 14:03:23 GMT
Request Body (body.json)
{
"dbname" : "dbwc1",
"patchedwc" : "DB_Wcopy2"
}
Response Body
{
"links": [{
"uri": "https://RHP_node_name:8894/rhp-restapi/rhp/jobs/1",
"rel": "self"
}],
"jobId": "1",
"output": { }
}