deinstall_reporting_diffdb

Purpose

Removes a single reporting schema when the study and reporting schemas are located in different database instances. This script:

Removes all components associated with the Reporting and Analysis module for a single study and reporting schema combination.
Uninstalls only one reporting schema at a time. To uninstall multiple reporting schemas, you can run the script as many times as necessary.
Does not remove the underlying reporting infrastructure, including reporting tablespaces.

Location

Folder where the reporting software is located, for example, <Installation_Directory>\InForm\bin\DBOra\Reporting.

Usage

deinstall_reporting_diffdb

Command line prompts

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.

For legacy purposes, you can also pass the parameters by using the /accountparams: "path_to_parameter_file" command option.

When specified, this option includes the path to a text file that contains the values required to run the command. The format of the parameter file is parameter=value. There is a new line for each parameter, and there are no spaces on a line.

Notes

Before running the deinstall_reporting_diffdb.sql script:

Review the parameters in the configdiffdb.sql file to make sure that they contain the same values that you used to install the reporting schema.
Stop the study.

Note: The InForm database installation and administration scripts are designed to be run using the InForm Application Server. The scripts can also be run from the Oracle database home on an InForm Reporting Server. Running them from a different Windows Oracle client or from a non-Windows Oracle client or database home may work, but is not supported.