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