Set up the application database account
Perform these steps using the non-privileged user account on the application server.
- Navigate to the /u01/stage/Database directory, for example:
$ cd /u01/stage/Database
- Review the 1_create_webvdme_tablespaces_linux.sql file:
- Using a text editor, open the 1_create_webvdme_tablespaces_linux.sql file, for example:
$ vi 1_create_webvdme_tablespaces_linux.sql
- Locate the datafile_path variable.
- To create Empirica Signal data files in a location other than the default location of your database, specify the location as the value of the datafile_path variable, for example:
DEFINE datafile_path = '/u01/app/oracle/oradata/<sid>'
Note: The path must end in a forward slash (/).
- Save and close the file.
- Using a text editor, open the 1_create_webvdme_tablespaces_linux.sql file, for example:
- Create the Signal tablespace:
- Execute the 1_create_webvdme_tablespaces_linux.sql script as the Oracle system user, for example:
$ sqlplus system@<TNS_NAME> @1_create_webvdme_tablespaces_linux.sql
A password prompt appears.
- Enter the Oracle system account password.
- Execute the 1_create_webvdme_tablespaces_linux.sql script as the Oracle system user, for example:
- Create the Empirica Signal database user account and schema:
- At the SQL*PLUS prompt, execute the 2_create_webvdme_oracle_user.sql script as the Oracle sysdba user:
$ sqlplus sys@<TNS_NAME> as sysdba @2_create_webvdme_oracle_user.sql
A password prompt appears.
- Enter the Oracle sys account password.
A second password prompt appears.
- Enter a password for the Empirica Signal database account.
- Reenter the password.
Note: You use the password in a later step.
A third password prompt appears.
- Enter a password for the empirica_admin account.
- Reenter the password.
- At the SQL*PLUS prompt, execute the 2_create_webvdme_oracle_user.sql script as the Oracle sysdba user:
- Populate the application schema:
- At the SQL*PLUS prompt, execute the 3_create_all.sql script as the Empirica Signal database user, for example:
$ sqlplus webvdme@<TNS_NAME> @3_create_all.sql
A password prompt appears.
- Enter the Empirica Signal database account password that you created in a previous step.
- At the SQL*PLUS prompt, execute the 3_create_all.sql script as the Empirica Signal database user, for example: