Install report data (installation only)

Previous Topic

Next Topic

Book Contents

Install report data (installation only)

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:

Perform these steps using the non-privileged user account on the application server.

  1. Unpack the Data_Stub.zip file:
    1. Create a /u01/stage/data_stub directory, for example:

      $ mkdir /u01/stage/data_stub

    2. Unzip the Data_Stub.zip file into the data_stub directory, for example:

      $ unzip Data_Stub.zip -d /u01/stage/data_stub

    3. Verify that the /data_stub directory contains the same files as the Data_Stub.zip file.
  2. Create the tablespaces and accounts used to store the production data:
    1. Using a text editor, open the /u01/stage/data_stub/create_prod.sql file.
    2. 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.
    3. In a command shell, use the following command to navigate to the /u01/stage/data_stub directory:

      $ cd /u01/stage/data_stub

    4. Enter the following command on one line to execute the script:

      $ sqlplus system@<TNS_NAME> @create_prod

      A password prompt appears.

    5. Enter the Oracle system account password.

      A second password prompt appears.

    6. Enter a password for the AERS68_TO_1Q03 account.
    7. 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.

  3. To load the data into the Oracle database:
    1. Edit the load_prod.imp file, supplying your Oracle instance at the end of the userid line, for example:

      userid=AERS68_TO_1Q03@orcl

    2. Execute the following command to give execute permissions to load_prod.sh:

      $ chmod u+x load_prod.sh

    3. Execute the load_prod.sh file using the following command:

      $ ./load_prod.sh

    4. Enter the password for the AERS68_TO_1Q03 account. You created the password in step 2f.
  4. To import the supplied standard AERS (1Q03: S) configuration into the Empirica Signal application:
    1. Log in to the Empirica Signal application using the admin user name.
    2. Click Settings, and click Manage Configurations.
    3. Click Import Configurations.
    4. Enter the following account name:

      AERS68_TO_1Q03

    5. Click OK.
    6. Verify that the AERS (1q03: S) standard configuration is listed on the Manage Configurations page.
    7. On the Manage Configurations page, click the row menu, and click Edit.
    8. On the Modify Configuration page, click Validate Now.
    9. Click Continue.

      Note: For more information on working with configurations, see the User Guide and Online Help.

    10. Optionally, delete the /data_stub directory and its contents. These files are no longer needed.
Send Feedback