Creating an Oracle Database for Jeopardy Service User
Create an Oracle database for the Jeopardy by running the provided scripts.
- Procedure
- Open the
$OM_HOME/db/dbscripts/oracle/jeopardy/oracle_jeopardy_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_JEOPARDY_USER
New Jeopardy user ORCL_JEOPARDY_PASSWORD
Password for the Jeopardy user ORCL_JEOPARDY_TABLESPACE
Jeopardy 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. Set it to true if creating a database on a cloud platform. DEFAULT_TENANT
TIBCO EXECUTE_DDL_DML_ONLY
The default value is false. Set it to true if executing only DDL/DML. BASE_INSTALLATION_SCRIPTS
jeopardy_database_ddl.sql,OMS_Seed_JeopardyLock.sql:true
,jeopardy_database_dml.sql:true
- Save and close the file.
- Run the
$OM_HOME/db/dbscripts/oracle/jeopardy/db-setup.sh
script.