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.
- Navigate to the /u01/stage/Database directory, for example:
$ cd /u01/stage/Database
- If the TEST_IQOQ database account exists, drop the account:
- Start SQL*PLUS.
- Execute the drop user command as the system user, for example:
$ sqlplus system@<TNS_NAME>
A password prompt appears.
- Enter the Oracle system account password.
SQL> drop user TEST_IQOQ cascade;
- Exit SQL*PLUS.
- Create the test_iqoq database user account and tables:
- 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.
- Enter the Oracle system account password.
A second password prompt appears.
- Enter a password for the TEST_IQOQ database account.
- Reenter the password.
Note: You use the password in a later step.
- Execute the 4_create_test_iqoq_oracle_user.sql script as the Oracle system user, for example:
- Populate the TEST_IQOQ tables:
- 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.
- Enter the TEST_IQOQ database account password.
- Execute the 5_populate_test_iqoq.sql script as the TEST_IQOQ database user, for example: