7.3.2 Validate Oracle Database
REST API:
- Endpoint: https://repstance_url/configure/database
- Method: POST
- Header:
- Content-Type: application/json
- X-Token: token
- Body:
{
"command":"validate",
"parameters":[
["database","source|target"],
["dbtype","oracle"],
["connectiontype","tns|ezconnect"],
["tnsname","tns_alias"],
["server","host_name"],
["port","port_number"],
["servicename","service_or_SID"],
["dbname","database_name"],
["user","db_user_name"],
["password","db_user_password"]
]
}
Server response:
- HTTP Status – status of the command, possible codes are:
- 200 – if no error occurs
- 422 – if error occurs
- Body:
{
"Status":"{Valid|Invalid}",
"Message":"The command execution details"
}
CLI Syntax:
repcli validate database=source|target dbtype=oracle \
connectiontype=tns|ezconnect tnsname=tns_alias \
server=databaseHost port=databasePort \
servicename=service_or_SID dbname=databaseName \
user=username password=password \
The input parameters are:
- database – Database role, the possible values are:
- source – to validate Capture Process Objects
- target – to validate Apply Process Objects
- dbtype – Type of RDBMS, the possible value is oracle
- connectiontype – Specifies connection method to Oracle, possible values are:
- tns – Local Naming Method to be used
- ezconnect – EZCONNECT to be used
- tnsname – Name of the TNS alias, valid only if connectiontype=tns
- server – Host name or IP address of the database server, valid only if connectiontype=ezconnect
- port – Database port number, valid only if connectiontype=ezconnect
- servicename – Database service name or SID, valid only if connectiontype=ezconnect
- dbname – Name of either container or pluggable database. Valid only if database=source and for any Oracle versions 12c-19c but excluding RDS instances
- user – Database User name
- password – Database User password