- Installation and Upgrade Instructions
- Prepare the application server
- Set up the application database account (installation only)
Set up the application database account (installation only)
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 Oracle 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/empcdb/signalpdb'
- If Transparent Data Encryption is desired, uncomment the line (remove
'--' from the beginning)
DEFINE encryption = ENCRYPTION DEFAULT STORAGE(ENCRYPT)
- Save and close the file.
- Using a text editor, open the
- Create the Oracle Empirica 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
- Create the Oracle 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 Oracle Empirica Signal database account.
- Reenter the password.
- At the SQL*PLUS prompt, execute the
- Populate the application schema:
- At the SQL*PLUS prompt, execute the
3_create_all.sql
script as the Oracle Empirica Signal database user, for example:$ sqlplus webvdme@<TNS_NAME> @3_create_all.sql
A password prompt appears.
- Enter the Oracle Empirica Signal database account password that you created in a previous step.
- At the SQL*PLUS prompt, execute the
Parent topic: Prepare the application server