Checking the variable settings for a study—Different database instances

Purpose—Checks the variable settings in an environment where the study and reporting databases are in different database instances.
Script—configandcheckdiffdb
Where to run—Folder in which the reporting software is located, for example, <Installation_Directory>\Inform\bin\DBOra\Reporting.

Use the configandcheckdiffdb.sql script to check the variable settings. The installation calls this script to check the environment and variables before the installation. No logon is required to run this script, because the script uses information provided in the configdiffdb.sql file to log on.

Note: Before running the configandcheckdiffdb.sql script, make sure that archive log mode is set for the instance. For more information, see the Installation Guide.

Open a Command Prompt window.
Change to the directory where the reporting software is located.
Run the script using the command:
configandcheckdiffdb

You are prompted for the following parameters:
- trial_schema_owner_password—Password for the study schema owner.
- dbauser_trial_password—Password for the study DBA user.
- dbauser_rep_password—Password for the reporting DBA user.
- streams_admin_user_rep_passwd—Password for the reporting streams admin user.
- streams_admin_user_trial_pwd—Password for the study streams admin user.
If the script passes with no errors, the variables are correct. If there is an error, make corrections and then rerun the script. Do not proceed with the installation until errors have been resolved.

For more information, see configandcheckdiffdb.