Set up the test data database account (installation only)

Previous Topic

Next Topic

Book Contents

Set up the test data database account (installation only)

This procedure is optional.

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

  1. Navigate to the /u01/stage/Database directory, for example:

    $ cd /u01/stage/Database

  2. If the TEST_IQOQ database account exists, drop the account:
    1. Start SQL*PLUS.
    2. Execute the drop user command as the system user, for example:

      $ sqlplus system@<TNS_NAME>

      A password prompt appears.

    3. Enter the Oracle system account password.

      SQL> drop user TEST_IQOQ cascade;

    4. Exit SQL*PLUS.
  3. Create the test_iqoq database user account and tables:
    1. Execute the 4_create_test_iqoq_oracle_user.sql script as the Oracle system user, for example:

      $ sqlplus system@<TNS_NAME> @4_create_test_iqoq_oracle_user.sql

      A password prompt appears.

    2. Enter the Oracle system account password.

      A second password prompt appears.

    3. Enter a password for the TEST_IQOQ database account.
    4. Reenter the password.

      Note: You use the password in a later step.

  4. Populate the TEST_IQOQ tables:
    1. Execute the 5_populate_test_iqoq.sql script as the TEST_IQOQ database user, for example:

      $ sqlplus TEST_IQOQ@<TNS_NAME> @5_populate_test_iqoq.sql

      A password prompt appears.

    2. Enter the TEST_IQOQ database account password.
Send Feedback