Provisioning Oracle databases
Use the following procedures to provision an Oracle database:
The base URL for the API is:
https://<managerHostName>/bda/rest/api
Creating an Oracle grid infrastructure
Use the following procedure to create an Oracle grid infrastructure.
Syntax
/1.0/oracle/create_grid
Method
POST
Required Parameters
display_name
—Enter a display name for the new Oracle grid infrastructure.node
—Use the fully qualified nodeId.
Use the value of nodeId from the dstate file of Agent node.Note
The location of the dstate file is /app/clarity/dagent/var/dstate in Linux.
version
—Enter the Oracle version for which you want to create the grid infrastructure.
Select an appropriate value from the following table:Oracle version Value to be entered 11gR2 11.2.0.4 12cR1 12.1.0.2 12cR2 12.2.0.1 18c 12.2.0.2 19c 12.2.0.3 template_id
—Use the ID provided in the templates of BDA interface.
Optional Parameter
Use the parameter override_values
to override the custom field values in the supplied Provisioning template. You must provide values in this field when the following conditions exist:
- The custom fields are not defined in the supplied template.
- You have not provided the default values in the supplied template.
Example API response
{
"status": "success",
"status_code": 200,
"data": {
"job_id": "479",
"result": "Please check job '479' for info!!"
}
}
Example API command
curl -k -H "x-auth-token: ad7aaa89fbf0ef648ddd1607007e819f" –data "display_name=<grid_name>&node=<node_fqn>&version=<oracle_version>&template_id=<template_id>" https://my.bda.manager.com/bda/rest/api/1.0/oracle/create_grid
Example of passing ASM Disk Values through override_values
override_values=ASM_DISKSTRING_VALUE=/dev/oracle/post11gR2/*,ASM_DISK_VALUE1=/dev/oracle/post11gR2/GRID1,ASM_DISK_VALUE2=/dev/oracle/post11gR2/GRID2,ASM_DISK_VALUE3=/dev/oracle/post11gR2/GRID3,ASM_DISK_VALUE4=/dev/oracle/post11gR2/GRID4,ASM_DISK_VALUE5=/dev/oracle/post11gR2/GRID5
Creating an Oracle RAC database
Use the following procedure to create an Oracle Real Application Clusters (Oracle RAC) database.
Syntax
/1.0/oracle/create_rac_db
Method
POST
Required parameters
db_name
—Use the display name of the database.node
—Use the fully qualified node name.version
—Use the Oracle version that you are using currently.template_id
—Use the ID provided in the templates of BDA interface.
Optional parameters
None
Example API response
{
"status": "success",
"status_code": 200,
"data": {
"job_id": "482",
"result": "Please check job '482' for info!!"
}
}
Example API command
To create an Oracle RAC database:
curl -k -H "x-auth-token: ad7aaa89fbf0ef648ddd1607007e819f" --data "db_name=<db_name>&node=<node_fqn>&version=<oracle_version>&template_id=<template_id>" https://my.bda.manager.com/bda/rest/api/1.0/oracle/create_rac_db
Creating an Oracle database on a Linux Single Instance (SI)
Use the following procedure to create an Oracle database on a Linux SI.
Syntax
/1.0/oracle/create_db
Method
POST
Required parameters
db_name
—Use the display name of the database.node
—Use the fully qualified node name.version
—Use the Oracle version that you are using currently.template_id
—Use the ID provided in the templates of BDA interface.
Optional parameters
None
Example API response
{
"status": "success",
"status_code": 200,
"data": {
"job_id": "479",
"result": "Please check job '479' for info!!"
}
}
Example API command
To create a database on a Linux SI:
curl -k -H "x-auth-token: ad7aaa89fbf0ef648ddd1607007e819f" --data "db_name=<db_name>&node=<node_fqn>&version=<oracle_version>&template_id=<template_id>" https://my.bda.manager.com/bda/rest/api/1.0/oracle/create_db
Creating an Oracle database on Microsoft Windows
Use the following procedure to create an Oracle database on Windows node.
Syntax
/1.0/oracle/create_db_windows
Method
POST
Required Parameters
display_name
—Enter a display name for the new Oracle database.node
—Use the fully qualified nodeId.
Use the value of nodeId from the dstate.conf file of Agent node.Note
The location of the dstate.conf file is /<agent_install_dir>/dstate.conf in Windows.
version
—Enter the Oracle version for which you want to create the database.
Select an appropriate value from the following table:Oracle version Value to be entered 11gR2 11.2.0.4 12cR1 12.1.0.2 12cR2 12.2.0.1 18c 12.2.0.2 19c 12.2.0.3 template_id
—Use the ID provided in the templates of BDA interface.
Optional Parameter
Use the parameter override_values
to override the custom field values in the supplied database template. You must provide values in this field when the following conditions exist:
- The custom fields are not defined in the supplied template.
- You have not provided the default values in the supplied template.
Example API response
{
"status": "success",
"status_code": 200,
"data": {
"job_id": "479",
"result": "Please check job '479' for info!!"
}
}
Example API command
curl -k -H "x-auth-token: ad7aaa89fbf0ef648ddd1607007e819f" –data "display_name=<display_name>&node=<node_fqn>&version=<oracle_version>&template_id=<template_id>" https://my.bda.manager.com/bda/rest/api/1.0/oracle/create_db_windows
Creating an Oracle home
Use the following procedure to create an Oracle home.
Syntax
/1.0/oracle/add_home
Method
POST
Required Parameters
display_name
—Enter a display name for the new Oracle Home.node
—Use the fully qualified nodeId.
Use the value of nodeId from dstate.conf or dsate file of Agent node.Note
The location of the file is:
- /<agent_install_dir>/dstate.conf, in Windows
- /app/clarity/dagent/var/dstate, in Linux
version
—Enter the Oracle version for which you want to create the Oracle home.
Select an appropriate value from the following tableOracle version Value to be entered 11gR2 11.2.0.4 12cR1 12.1.0.2 12cR2 12.2.0.1 18c 12.2.0.2 19c 12.2.0.3 template_id
—Use the ID provided in the templates of BDA interface.
Optional Parameter
Use the parameter override_values
to override the custom field values in the supplied database template. You must provide values in this field when the following conditions exist:
- The custom fields are not defined in the supplied template.
- You have not provided the default values in the supplied template.
Example API response
{
"status": "success",
"status_code": 200,
"data": {
"job_id": "479",
"result": "Please check job '479' for info!!"
}
}
Example API command
curl -k -H "x-auth-token: ad7aaa89fbf0ef648ddd1607007e819f" –data "display_name=<home_name>&node=<node_fqn>&version=<oracle_version>&template_id=<template_id>" https://my.bda.manager.com/bda/rest/api/1.0/oracle/add_home
Creating a Pluggable database (for Windows and Linux)
Use the following procedure to create a Pluggable database.
Syntax
/1.0/oracle/add_pdb
Method
POST
Required Parameters
display_name
—Enter a display name for the new Pluggable database.node
—Use the fully qualified nodeId.
Use the value of nodeId from dstate.conf or dsate file of Agent node.Note
The location of the file is:
- /<agent_install_dir>/dstate.conf, in Windows
- /app/clarity/dagent/var/dstate, in Linux
cdb_name
—Use the Oracle container database name.template_id
—Use the ID provided in the templates of BDA interface.
Optional Parameter
Use the parameter override_values
to override the custom field values in the supplied database template. You must provide values in this field when the following conditions exist:
- The custom fields are not defined in the supplied template.
- You have not provided the default values in the supplied template.
Example API response
{
"status": "success",
"status_code": 200,
"data": {
"job_id": "479",
"result": "Please check job '479' for info!!"
}
}
Example API command
curl -k -H "x-auth-token: ad7aaa89fbf0ef648ddd1607007e819f" –data "display_name=<display_name>&node=<node_fqn>&cdb_name=<cdb_name>&template_id=<template_id>" https://my.bda.manager.com/bda/rest/api/1.0/oracle/add_pdb
Starting an Oracle database
Use the following procedure to start an Oracle database instance.
Syntax
/1.0/oracle/start
Method
POST
Required parameters
db_name
—Use the display name of the database.node
—Use the fully qualified node name.
Optional parameters
None
Example API response
{
"status": "success",
"status_code": 200,
"data": {
"job_id": "481",
"result": "Please check job '481' for info!!"
}
}
Example API command
To start an Oracle database:
curl -k -H "x-auth-token: ad7aaa89fbf0ef648ddd1607007e819f" --data "db_name=<db_name>&node=<node_fqn>" https://my.bda.manager.com/bda/rest/api/1.0/oracle/start
Stopping an Oracle database
Use the following procedure to stop an Oracle database instance.
Syntax
/1.0/oracle/stop
Method
POST
Required parameters
db_name
—Use the display name of the database.node
—Use the fully qualified node name.
Optional parameters
None
Example API response
{
"status": "success",
"status_code": 200,
"data": {
"job_id": "480",
"result": "Please check job '480' for info!!"
}
}
Example API command
To stop an Oracle database:
curl -k -H "x-auth-token: ad7aaa89fbf0ef648ddd1607007e819f" --data "db_name=<db_name>&node=<node_fqn>" https://my.bda.manager.com/bda/rest/api/1.0/oracle/stop
Removing an Oracle home
Use the following procedure to remove an Oracle home.
Syntax
/1.0/oracle/remove_home
Method
POST
Required Parameters
display_name
—Use the display name of the Oracle home.node
—Use the fully qualified nodeId.
Use the value of nodeId from dstate.conf or dsate file of Agent node.Note
The location of the file is:
- /<agent_install_dir>/dstate.conf, in Windows
- /app/clarity/dagent/var/dstate, in Linux
template_id
—Use the ID provided in the templates of BDA interface.
Optional Parameter
Use the parameter override_values
to override the custom field values in the supplied database template. You must provide values in this field when the following conditions exist:
- The custom fields are not defined in the supplied template.
- You have not provided the default values in the supplied template.
Example API response
{
"status": "success",
"status_code": 200,
"data": {
"job_id": "479",
"result": "Please check job '479' for info!!"
}
}
Example API command
curl -k -H "x-auth-token: ad7aaa89fbf0ef648ddd1607007e819f" –data "display_name=<display_name>&node=<node_fqn>&template_id=<template_id>" https://my.bda.manager.com/bda/rest/api/1.0/oracle/remove_home
Removing an Oracle database (Linux)
Use the following procedure to remove an Oracle database from Linux node.
Syntax
/1.0/oracle/remove_db
Method
POST
Required parameters
db_name
—Use the display name of the database.node
—Use the fully qualified node name.template_id
—Use the ID provided in the templates of BDA interface.
Optional parameters
None
Example API response
{
"status": "success",
"status_code": 200,
"data": {
"job_id": "483",
"result": "Please check job '483' for info!!"
}
}
Example API command
To remove an Oracle database:
curl -k -H "x-auth-token: ad7aaa89fbf0ef648ddd1607007e819f" --data "db_name=<db_name>&node=<node_fqn>" https://my.bda.manager.com/bda/rest/api/1.0/oracle/remove_db
Removing an Oracle Database (Windows)
Use the following procedure to remove an Oracle database from Windows node.
Syntax
/1.0/oracle/remove_db_windows
Method
POST
Required Parameters
display_name
—Use the display name of the database.node
—Use the fully qualified nodeId.
Use the value of nodeId from dstate.conf or dsate file of Agent node.Note
The location of the file is:
- /<agent_install_dir>/dstate.conf, in Windows
- /app/clarity/dagent/var/dstate, in Linux
template_id
—Use the ID provided in the templates of BDA interface.
Optional Parameter
Use the parameter override_values
to override the custom field values in the supplied database template. You must provide values in this field when the following conditions exist:
- The custom fields are not defined in the supplied template.
- You have not provided the default values in the supplied template.
Example API response
{
"status": "success",
"status_code": 200,
"data": {
"job_id": "479",
"result": "Please check job '479' for info!!"
}
}
Example API command
curl -k -H "x-auth-token: ad7aaa89fbf0ef648ddd1607007e819f" –data "display_name=<display_name>&node=<node_fqn>&template_id=<template_id>" https://my.bda.manager.com/bda/rest/api/1.0/oracle/remove_db_windows
Comments
Log in or register to comment.