Creating an Oracle Database for the TIBCO PSI User

Create an Oracle database for the TIBCO PSI user by running the provided script $PSI_HOME/database-scripts/psi/oracle/bin/db-setup.sh.

Procedure

  1. Open the $PSI_HOME/database-scripts/psi/oracle/bin/oracle_psi_db.properties file in a suitable editor and update the following values in the script:

Property

Value

ORCL_HOST

Oracle database host

ORCL_PORT

Oracle port

ORCL_USERNAME

Oracle user name

ORCL_PASSWORD

Oracle user password

ORCL_SERVICENAME Oracle service name

ORCL_PSI_USER

New TIBCO PSI user

ORCL_PSI_PASSWORD

Password for the TIBCO PSI user

ORCL_PSI_TABLESPACE

TIBCO PSI tablespace

ORCL_TABLESPACE_SIZE TIBCO PSI tablespace size
ORCL_MINSIZE TIBCO PSI table minimum size
ORCL_MAXSIZE TIBCO PSI table maximum size
ORCL_DATAFILE_PATH Oracle datafile path
IS_CLOUD_PLATFORM false
EXECUTE_DDL_DML_ONLY false
BASE_INSTALLATION_SCRIPTS fos_psi_ddl.sql
  1. Save and close the file.

  2. Run the db-setup.sh script.