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)

2. Save and close the file.

3. Run the db-setup.sh script.

Top