Patch an unmanaged Oracle Database Software home
patch
/databases
Moves a database from the unamanged Oracle Database Software home to a patched working copy.
Request
Supported Media Types
- application/json
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 unmanaged Oracle database software home, where all the arguments are provided in the request body body.json
, 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/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",
"sourceHome" : "/oracle/home",
"patchedwc" : "DB_Wcopy2"
}
Response Body
{
"links": [{
"uri": "https://RHP_node_name:8894/rhp-restapi/rhp/jobs/1",
"rel": "self"
}],
"jobId": "1",
"output": { }
}