Contents

PART 1: PREPARING THE DATABASE SERVERS

Preparing to install

InForm 6.1.1.2 product image

InForm software components

Overview of the InForm system architecture

About the Cognos Private Gateway

Application server options

Minimal servers

Multiple server deployment

Distributed server deployment

Database configuration options

SameDB�Single database instance for InForm and Cognos reporting software

DiffDB�Separate database instances for InForm and Cognos reporting software

Distributed deployment options

Externally hosted studies

Determining resources for multiple studies

Guidelines for determining resources

Sizing the server

Configuring client computers

Browser settings for Internet Explorer

Browser settings for Apple Safari

Browser settings for Mozilla Firefox

Browser settings for Google Chrome

Windows Explorer settings

Performance Options setting in System Properties

Installing the Oracle database software

About installing the Oracle database software

Install the Oracle database software�SameDB

Install the Oracle database software�DiffDB

Configuring the Oracle database software

About configuring the Oracle database software

Create database instances

Steps to create database instances�SameDB

Steps to create database instances�DiffDB

Create Oracle Database instances

Create the InForm database instance

Create the reporting database instance

Create a database instance for the Cognos 10 BI content store

Set the initialization parameters for the database instances

Study database parameters�Different database instances

Archive log mode in a multiple database environment

Create database users

Steps to create database users�SameDB and DiffDB

Required InForm database accounts

Create a user for the Cognos 10 BI content store database

Create the rptinstall user on the InForm database server and the Reporting database server for DiffDB

Create the PFCapAdmin user on the Content Store database server

Multiple study tablespaces

Distributed InForm study tablespaces

Creating the INFORM_LOB tablespace

Set up Oracle XA Transaction Support

Installing and configuring the Oracle database client

Steps to install and configure the Oracle database client

Update the National Language Support registry settings on the Oracle database client

Configure the database connection

Validate the database connection

PART 2: PREPARING THE APPLICATION SERVERS

Preparing the InForm Application Server

Steps to prepare the InForm Application Server

Step 1: Verify the Oracle database client on the InForm Application Server

Step 2: Install the InForm core software on the InForm Application Server

Step 3: Set up a skeletal study

Step 4: Install the Central Designer certificate

Step 5: Update the DomainSuffix entry for the AuthenticationFilter registry key on the InForm Application Server�Optional

Step 6: Enable SSL on the InForm Application Server�Optional

Step 7: Create a sending address for auto-deployment confirmation messages

Step 8: Enable network access rights for automated study deployments

Install the sample study

About the sample study

Deploying the sample study

Install sample users and sites

Qualify the installation

Qualification prerequisites

Change the passwords of the sample study users

Admin�Users test

Admin�Rights test

Admin�Sites test

Admin�Groups test

Admin�Users and Groups test

CRC / CRA tests

As dobrien (CRC)

As dobrien (CRC) and lhill (CRA)

Preparing the Reporting application servers

About preparing the Reporting application servers

Prepare the Oracle Directory Server

Steps to prepare the Oracle Directory Server

Step 1: Install the Oracle Directory Server

Step 2: Create the ORACLEHS organizational unit (OU) and crnsysadmin user on the Oracle Directory Server

Prepare the Cognos Content Manager Server

Steps to prepare the Cognos Content Manager Server

Step 1: Verify the Oracle database client on the Cognos Content Manager Server

Step 2: Install the Cognos software and updates on the Cognos Content Manager Server

Step 3: Set up JRE on the Cognos Content Manager Server

Step 4: Set up the Oracle JDBC driver

Step 5: Run the Cognos Customization for InForm wizard (CRNConfig\setup.exe) on the Cognos Content Manager Server

Step 6: Create the ORACLEHS LDAP namespace on the Cognos Content Manager Server

Step 7: Update the domain settings for Cognos-generated cookies on the Cognos Content Manager

Step 8: Change or create a new MotioCAP_informcap.properties file�Optional

Step 9: Customize the Cognos 10 BI email settings on the Cognos Content Manager Server

Step 10: Enable SSL on the Cognos Content Manager Server�Optional

Prepare the Cognos Report Server

Steps to prepare the Cognos Report Server

Step 1: Verify the Oracle database client on the Cognos Report Server

Step 2: Install the Cognos software and updates on the Cognos Report Server

Step 3: Set up JRE on the Cognos Report Server

Step 4: Set up the Oracle JDBC driver

Step 5: Run the Cognos Customization for InForm wizard (CRNConfig\setup.exe) on the Cognos Report Server

Step 6: Enable SSL on the Cognos Report Server�Optional

Step 7: Update the domain settings for Cognos-generated cookies on the Cognos Report Server

Prepare the Cognos Gateway Server

Steps to prepare the Cognos Gateway Server

Step 1: Install the Cognos software and updates on the Cognos Gateway Server

Step 2: Set up JRE on the Cognos Gateway Server

Step 3: Run the Cognos Gateway Customization for InForm wizard (CRNGatewayConfig\setup.exe) on the Cognos Gateway Server

Step 4: Update the DomainSuffix entry for the AuthenticationFilter registry key on the Cognos Gateway Server�Public Gateway only

Step 5: Enable SSL on the Cognos Gateway Server�Optional�Public Gateway only

Common steps for Reporting application servers

Install the Cognos software and updates�Cognos Content Manager / Cognos Report Server / Cognos Gateway Server

Install the Cognos 10.2.2 software

Install the 10.2.2 hotsite updates

Upgrade Cognos 10.2.1 software to Fix Pack 2

Install the 10.2.2 Interim Fix

Install hotsite 10.2.6104.1072

Add JRE to the JAVA_HOME environment variable

Run the Cognos Customization for InForm wizard (CRNConfig\setup.exe)�Cognos Content Manager / Cognos Report Server

Create the ORACLEHS LDAP namespace

Update the domain settings for Cognos-generated cookies

Enable Secure Sockets Layer (SSL)

About enabling Secure Sockets Layer (SSL)

Set up your environment to support SSL

Steps to perform on all servers

Create and set up a key certificate for SSL in IIS

Install a key certificate on the server machine in IIS

Import the new key certificate to the local computer and the current user

Verify the key certificate installation

Additional steps to perform if you are using Reporting with a SameDB configuration

Configure Cognos 10 BI to use SSL�Reporting only

Configure the Cognos Gateway Server to use SSL�Reporting only

Enable SSL for each study

Enable SSL through the InForm Admin user interface

Enable SSL with the MedML Installer utility

Configure the InForm study web services to use SSL

Set up your environment to use Transport Layer Security (TLS)

PART 3: POST-INSTALLATION TASKS

Post-installation tasks

Enable communication among distributed Cognos 10 BI software components

Enabling clinical model generation in a multi-server environment

Start the Cognos 10 BI servers

Disable the indexed search option on the Reporting server

Enabling Authors group permissions

Allowing support for restricted report elements

Configure settings for Comma Separated Values (CSV) report output

Configure the CSV settings for reports

Deploying SQL profiles

Deploy your study

Deploy your study

Uninstalling software components

About uninstalling software components

Uninstalling the Cognos Customization for InForm and the Cognos Gateway Customization for InForm wizards

Uninstalling the Cognos 10 BI software

Uninstalling the Oracle Directory Server

Uninstalling the InForm software

Command and script reference

configandcheckdiffdb

create_cap_table.sql

deinstall_reporting_diffdb

DeployBackup.cmd

DeployRestore.cmd

ExportMigrationFiles

grant_dba_privs.sql

grant_user_privs.sql

ImportMigrationFiles

install_reporting_diffdb

oramtsadmin.sql

PostDeployWorkaround.cmd

PreDeployWorkaround.cmd

remove_streams_setup_info_diffdb

RequestTime.cmd

Troubleshooting

Oracle MTS configuration is invalid

XA Views: INVALID

Database connectivity

Password error on InForm service start up

Uninstall issues

Errors when removing a reporting schema

Running the Cognos Customization wizards in silent mode

Steps for running the Cognos Customization wizards in silent mode

Run the Cognos Customization for InForm wizard (CRNConfig\setup.exe) in record mode

Run the Cognos Customization for InForm wizard (CRNConfig\setup.exe) in silent mode

Run the Cognos Gateway Customization for InForm wizard (CRNGatewayConfig\setup.exe) in record mode

Run the Cognos Gateway Customization for InForm wizard (CRNGatewayConfig\setup.exe) in silent mode

Where to find the product documentation

Documentation accessibility

Access to Oracle Support