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
-
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 |
-
Save and close the file.
-
Run the
db-setup.sh
script.