Install report data
You install a small data stub on the Oracle database to enable the standard reports in the Empirica Signal application. The data stub includes the AERS (1q03:S) data configuration.
Do not perform this procedure if the AERS68_TO_1Q03 data set is already installed on the application server.
Before you begin, locate the Data_Stub.zip file. The zip file contains:
- An Oracle DMP file.
- SQL scripts.
- A shell (.sh) script.
- An IMP file.
Perform these steps using the non-privileged user account on the application server.
- Unpack the Data_Stub.zip file:
- Create a /u01/stage/data_stub directory, for example:
$ mkdir /u01/stage/data_stub
- Unzip the Data_Stub.zip file into the data_stub directory, for example:
$ unzip Data_Stub.zip -d /u01/stage/data_stub
- Verify that the /data_stub directory contains the same files as the Data_Stub.zip file.
- Create a /u01/stage/data_stub directory, for example:
- Create the tablespaces and accounts used to store the production data:
- Using a text editor, open the /u01/stage/data_stub/create_prod.sql file.
- To create the data file in a location other than the default location of your database, specify the alternate location in the DATAFILE_PATH variable.
- In a command shell, use the following command to navigate to the /u01/stage/data_stub directory:
$ cd /u01/stage/data_stub
- Enter the following command on one line to execute the script:
$ sqlplus system@<TNS_NAME> @create_prod
A password prompt appears.
- Enter the Oracle system account password.
A second password prompt appears.
- Enter a password for the AERS68_TO_1Q03 account.
- Confirm the password.
Note: Remember this password for later in this procedure.
The create_prod.sql script creates a tablespace for the data consisting of one 40 MB data file.
- To load the data into the Oracle database:
- Edit the load_prod.imp file, supplying your Oracle instance at the end of the userid line, for example:
userid=AERS68_TO_1Q03@orcl
- Execute the following command to give execute permissions to load_prod.sh:
$ chmod u+x load_prod.sh
- Execute the load_prod.sh file using the following command:
$ ./load_prod.sh
- Enter the password for the AERS68_TO_1Q03 account that you created in step 2 f.
- Edit the load_prod.imp file, supplying your Oracle instance at the end of the userid line, for example:
- To import the supplied standard AERS (1Q03: S) configuration into the Empirica Signal application:
- Log in to the Empirica Signal application using the admin user name.
- Click Settings and then Manage Configurations.
- Click Import Configurations.
- Enter AERS68_TO_1Q03 as the account name.
- Click OK.
- Verify that the AERS (1q03: S) standard configuration is listed on the Manage Configurations page.
- On the Manage Configurations page, click the row menu, and select Edit.
- On the Modify Configuration page, click Validate Now.
- Click Continue.
Note: For more information on working with configurations, see the User Guide and Online Help.
- Optionally, delete the /data_stub directory and its contents. These files are no longer needed.