Creating an Oracle Database for the Admin User

Create an Oracle database for the admin user by running the $PSI_HOME/database-scripts/admin/oracle/bin/db-setup.sh script that is provided.

Procedure

  1. Open the $PSI_HOME/database-scripts/admin/oracle/bin/oracle_admin_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_ADMIN_USER

New admin user

ORCL_ADMIN_PASSWORD

Password for the admin user

ORCL_ADMIN_TABLESPACE

admin tablespace

ORCL_TABLESPACE_SIZE admin tablespace size
ORCL_MINSIZE admin table minimum size
ORCL_MAXSIZE admin table maximum size
ORCL_DATAFILE_PATH Oracle datafile path
IS_CLOUD_PLATFORM false
EXECUTE_DDL_DML_ONLY false
BASE_INSTALLATION_SCRIPTS database_ddl.sql (Not to be modified by end user)
  1. Save and close the file.

  2. Run the db-setup.sh script.