Creating an Oracle database for Orchestrator in case of Redis
Create an Oracle database for the Orchestrator by running the provided scripts.
- Procedure
- Open the
$OM_HOME/db/dbscripts/oracle/orch/oracle_orch_db.properties
file in a suitable editor and update the following values:Property Update the Value for ORCL_HOST
Oracle database host ORCL_PORT
Oracle port ORCL_USERNAME
Oracle superuser name ORCL_PASSWORD
Oracle superuser password ORCL_SERVICENAME
Service name of the database ORCL_ORCH_USER
New Orchestrator user ORCL_ORCH_PASSWORD
Password for the Orchestrator user ORCL_ORCH_TABLESPACE
Orchestrator tablespace ORCL_TABLESPACE_SIZE
Size of the tablespace ORCL_MINSIZE
Minimum tablespace size ORCL_MAXSIZE
Maximum tablespace size ORCL_DATAFILE_PATH
Data file path of Oracle IS_CLOUD_PLATFORM
The default value is false. You need to set it to true if the database is on a cloud platform. EXECUTE_DDL_DML_ONLY
The default value is false. You need to set it to true if you want to run only DDL/DML. - Save and close the file.
- Run the
$OM_HOME/db/dbscripts/oracle/orch/db-setup.sh
script.