Skip Headers
Oracle® Clinical Development Analytics Installation Guide
Release 2.0.0.2

Part Number E18163-04
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

2 Oracle Clinical Development Analytics Installation

This chapter presents an overview of the Oracle Universal Installer and OCDA installation process. It also describes the OCDA Installation tasks that you must complete for different environments. This chapter includes the following topics:

Note:

You can install OCDA using any OBIEE configuration supported by Oracle LSH.

About Oracle Clinical Development Analytics Installation Options

OCDA can be installed in a single server or multi-server architecture. The following are the installation options:

Configuring Oracle Clinical Development Analytics on Oracle WebLogic Server 10.3.3

By default, OCDA is installed on an OC4J Application Server. Alternatively, OCDA supports Oracle WebLogic Server 10.3.3 as your Application Server. Based on your business needs, you can include Oracle WebLogic Server instances called Administration Server and cluster of Managed Servers. This section includes the following topics:

Configuring Oracle Clinical Development Analytics on Oracle WebLogic Administration Server

The OCDA installer automatically configures OCDA on Oracle WebLogic Administration Server. When you run the installer, based on the installation architecture you choose, perform the steps listed in either of the following sections:

Note:

In Select the Application Server to Use screen, select WEBLOGIC as your Application Server.

Configuring Oracle Clinical Development Analytics on Oracle WebLogic Managed Server

To configure OCDA on Oracle WebLogic Managed Server, perform the following tasks:

  1. Run the OCDA Installer. Based on the installation architecture you choose, perform the steps listed in either of the following sections:

    Note:

    In Select the Application Server to Use screen, select WEBLOGIC as your Application Server.
  2. Manually deploy OCDA's help and images files on Oracle WebLogic Managed Server. Perform post installation steps listed in Deploying Oracle Clinical Development Analytics on Oracle WebLogic Managed Server, Deploying Oracle Clinical Development Analytics on Oracle WebLogic Managed Server (Chapter 3, Post Installation Tasks).

About the Oracle Universal Installer

OCDA uses the Oracle Universal Installer to guide you through each step of the installation process.

The Oracle Universal Installer provides the following features:

Figure 2-1 Welcome Screen

Description of Figure 2-1 follows
Description of "Figure 2-1 Welcome Screen"

Requirements for Tablespace

Before you run the installer, ensure that the autoextend feature is enabled for the following tablespaces in the Oracle LSH database:

  • APPS_TS_MEDIA

  • APPS_TS_TX_DATA

  • APPS_TS_TX_IDX

  • APPS_UNDOTS1

  • CTXSYS

Oracle recommends the following tablespace free space (minimum):

  • APPS_TS_MEDIA – 1 GB of free space

  • APPS_TS_TX_DATA – 2 GB of free space

If you want to create a tablespace for the RXI user, you must create a new tablespace by performing the following:

  1. Connect to the LSH/CDA database as sysdba.

  2. @create tablespace <RXI tablespace name> datafile '<datafiles location>/<RXI datafile name>.dbf';

If you want to use an already existing tablespace, ensure that you enter the correct tablespace name.

WARNING:

You must not use the SYSTEM tablespace.

Gathering Table Statistics

Before you install OCDA, run the Gather Schema Statistics concurrent program to gather table statistics. The concurrent program can be run from the System Administrator Responsibility to generate statistics. Perform the following steps:

WARNING:

Ensure there are no other concurrent jobs are running when you gather table statistics; else those concurrent jobs might complete with errors.

  1. Log in to Oracle LSH with the System Administrator responsibility.

    For example, you can use the sysadmin account and password.

  2. Navigate to System Administrator > Run.

    The Submit a New Request window opens in Oracle Applications Profile Forms.

  3. Click OK.

    The Submit Request window opens.

  4. In Name, select Gather Schema Statistics.

  5. Click in the Parameters field.

  6. In the Parameters window, enter CDR as the Schema Name.

    This can be run for specific schemas by specifying the schema name or entering CDR to gather statistics for every schema in the database.

  7. Click OK.

  8. Click Submit.

To check if the Gather Schema Statistics concurrent program you submitted has executed successfully, perform the following steps:

  1. Log in to Oracle LSH with the System Administrator responsibility.

    For example, you can use the sysadmin account and password.

  2. Navigate to System Administrator > View.

    The Find Requests window opens in Oracle Applications Profile Forms.

  3. Select All My Requests.

  4. Click Find.

Installing Oracle Clinical Development Analytics on the Oracle Life Sciences Data Hub Server

To install the OCDA application on the Oracle LSH Server on Unix:

Important:

This section assumes that the Oracle database is located on the same server as the middle-tier.

The Operating System User that you are using for installing OCDA should have read/write privileges on ORACLE_HOME and ORACLE_INVENTORY directories.

  1. Log in as owner of Oracle Applications middle-tier.

  2. Source the APPSORA.env file in $APPL_TOP of your Oracle LSH installation to set the environment variables.

  3. Verify that the Oracle Applications variable $APPLPTMP is defined and that the permissions on the directory are correct and set to 777.

    Ensure that both the applmgr user and the database user oracle have read/write permissions on $APPLPTMP. OCDA installation uses this standard location to stage a file that needs to be loaded into the Oracle LSH database.

  4. Insert the CD labeled Oracle Clinical Development Analytics 2.0.0.1 into the CD-ROM drive. Transfer the platform specific zip file on the disc to the Oracle LSH server. Extract the contents of the platform specific zip file.

    If you downloaded the OCDA media pack from the Oracle E-Delivery Web site, navigate to the directory where you downloaded and extracted the media pack. Locate the platform specific zip file. Transfer the platform specific zip file to the Oracle LSH server. Extract the contents of the platform specific zip file.

  5. Assign 755 permissions to the contents of the install folder where the installer is unzipped

    chmod -R 755 <Path to directory where the installer is unzipped>

  6. Navigate to the following directory:

    install

  7. Set the X Window display output to your local computer's IP address. For example:

    C shell: setenv DISPLAY 123.45.67.89:0l

  8. Invoke the runInstaller executable to launch the installer.

    ./runInstaller

    The installer opens the Welcome screen, which provides information about the Oracle Universal Installer and its options.

  9. Click Next

  10. If you are running the installer for the first time, the Specify Inventory Directory and Credentials screen appears.

    Click Browse to navigate through the available directory to select a location. Select Operating System Group Name from the drop-down list.

  11. Click Next to continue. In the Specify Home Details screen:

    1. Enter a name for this installation.

    2. Enter the full path to Oracle home directory. You can click Browse to navigate through the available directories to select a location for the Oracle home directory.

  12. Click Next to continue. Enter your email address to receive security updates. If you want to receive security updates using My Oracle Support, select I wish to receive security updates via My Oracle Support, and then enter your My Oracle Support password.

  13. Click Next to continue. In the Select Products Already Installed screen, select Oracle Life Sciences Hub (Oracle LSH) Only.

  14. Click Next to continue. In the Oracle CDA Home Directory screen, enter the full path to Oracle CDA home.

    Oracle CDA home is the directory where the installer puts required installation and log files. It is a permanent directory, retained after installation. Oracle recommends that you create CDA home directory under APPL_TOP (sourced by the APPSORA.env file). For example,

    In Unix, <Path to APPL_TOP>/cda

  15. Click Next to continue. In Enter Temporary Staging Area for the Domain File screen, do not modify the default location (the value of APPLPTMP). This is the temporary staging area from where OCDA_domain.zip will be loaded into the database.

  16. Click Next to continue. In the Enter Database TNS Name screen, enter a Transparent Network Substrate (TNS) name.

  17. Click Next to continue. In the Enter User Name for the Oracle Applications screen, enter a user name that you created as part of the Oracle Applications installation.

  18. Click Next to continue. In the Enter Password for the Oracle Applications User Name screen, enter the password for the Oracle Applications user name you specified, and then confirm the password.

  19. Click Next to continue. In the Enter User Name for Oracle LSH Application screen, enter an existing user name.

    You created this user as a prerequisite to installing OCDA.

  20. Click Next to continue. In the Enter Password for the Oracle LSH Application User Name screen, enter the password for the Oracle LSH user name you specified, and then confirm the password.

  21. Click Next to continue. In the Enter Password for the System User screen, enter the password for the System database user, and then confirm the password.

  22. Click Next to continue. In the Enter Password for the RXI User screen, enter the password for the RXI user that is created as part of the installation.

  23. Click Next to continue. In the Enter Data Tablespace Name screen, enter the name for an existing data tablespace that is used for the default tablespace of the RXI schema.

  24. Click Next to continue. In the Enter Temporary Tablespace Name screen, enter the name for the temporary tablespace that is used for the RXI user.

  25. Click Next to continue. Information screen reminds you to inspect log files. The following log files are generated in Unix environment:

  26. Click Next to continue. On the Summary screen, review the information about your OCDA installation.

    • setup.txt, ocda_schema_creation.log, and error.txt in OCDA home directory

    • OCDA_domain_import.log in APPLPTMP directory.

  27. Click Install to begin the installation.

  28. Verify the log files.

After you have finished all the installation tasks, you must perform the post installation tasks listed in Chapter 3, Post Installation Tasks.

Installing Stand-alone Oracle Clinical Development Analytics on the Oracle Business Intelligence Enterprise Edition Server

To install stand-alone OCDA application on the OBIEE server on either Windows or UNIX, first follow platform specific instructions either in the section 2.5.1 or 2.5.2, and then follow common steps in the section 2.5.3.

Running Oracle Clinical Development Analytics Installer on Windows

  1. Insert the CD labeled Oracle Clinical Development Analytics 2.0.0.1 into the CD-ROM drive.

    If you downloaded the OCDA media pack from the Oracle E-Delivery Web site, navigate to the directory where you downloaded and extracted the media.

  2. Navigate to the following directory:

    software\Windows\install

  3. Double-click setup.exe to launch the installer.

    The system opens the Welcome screen, which provides information about the Oracle Universal Installer and its options.

Running Oracle Clinical Development Analytics Installer on Unix

  1. Insert the CD labeled Oracle Clinical Development Analytics 2.0.0.1 into the CD-ROM drive. Transfer the platform specific zip file on the disc to the Oracle LSH server. Extract the contents of the platform specific zip file.

    If you downloaded the OCDA media pack from the Oracle E-Delivery Web site, navigate to the directory where you downloaded and extracted the media pack. Locate the platform specific zip file. Transfer the platform specific zip file to the Oracle LSH server. Extract the contents of the platform specific zip file.

  2. Assign 755 permissions to the contents of the install folder where the installer is unzipped

    chmod -R 755 <Path to directory where the installer is unzipped>

  3. Navigate to the following directory:

    install

  4. Set the X Window display output to your local computer's IP address. For example:

    C shell: setenv DISPLAY 123.45.67.89:0l

  5. Invoke the runInstaller executable to launch the installer.

    ./runInstaller

    The installer opens the Welcome screen, which provides information about the Oracle Universal Installer and its options.

Performing Common Steps for Windows and Unix

  1. Click Next to continue. In the Specify Home Details screen:

    1. Enter a name for this installation.

    2. Enter the full path to Oracle home directory. You can click Browse to navigate through the available directories to select a location for the Oracle home directory.

  2. Click Next to continue. Enter your email address to receive security updates. If you want to receive security updates using My Oracle Support, select I wish to receive security updates via My Oracle Support, and then enter your My Oracle Support password.

  3. Click Next to continue. In the Select Products Already Installed screen, select Oracle Business Intelligence Enterprise Edition (OBIEE) Only.

  4. Click Next to continue. In the Oracle CDA Home Directory screen, enter the full path to Oracle CDA home.

    Oracle CDA home is the directory where the installer puts required installation and log files. It is a permanent directory, retained after installation. Oracle recommends that you create CDA home directory under APPL_TOP (sourced by the APPSORA.env file). For example,

    In Unix, <Path to APPL_TOP>/cda

  5. Click Next to continue. In the Enter Oracle BI Directory screen, enter the full path to where the Oracle Business Intelligence Enterprise Edition (OBIEE) is installed.

  6. Click Next to continue. In the Enter OBIEE Data Directory screen, enter the full path to where the Web Catalog files are stored.

  7. Click Next to continue. In Select the Application Server to Use screen, select the application server you want.

  8. Click Next to continue.

    • If you have selected OC4J as your application server, follow steps 9 to 12.

    • If you have selected WEBLOGIC as your application server, perform the following steps:

      1. In the Enter WebLogic Home Directory screen, enter the full path of the WebLogic home.

        Important:

        WebLogic Home refers to the top-level directory where user_projects directory is created when you create a domain. For example, if user_projects directory is created as this location C:\Oracle\Middleware\user_projects, the WebLogic Home that you must enter is C:\Oracle\Middleware
      2. Click Next to continue. In the Enter the Domain Name for WebLogic screen, enter the domain name where you want to deploy OCDA.

        Important:

        Before you specify the domain name to deploy OCDA, ensure that you have already created the specified domain.
      3. Follow steps 9 to 12.

  9. Click Next to continue. Information screen reminds you to inspect log files. The following log files are generated in Windows environment:

    • In Windows environment, error.txt and setup.txt in OCDA home directory.

    • In Unix environment, setup.txt, ocda_schema_creation.log, and error.txt in OCDA home directory and OCDA_domain_import.log in APPLPTMP directory.

  10. Click Next to continue. On the Summary screen, review the information about your OCDA installation.

    If you need to change any of the information, click Back to return to the appropriate screen and make the necessary changes.

  11. Click Install to begin the installation.

  12. Verify the log file.

After you have finished all the installation tasks, you must perform the post installation tasks listed in Chapter 3, Post Installation Tasks.

Note:

In order to complete the installation on Oracle WebLogic Managed Server, perform steps listed in the Deploying Oracle Clinical Development Analytics on Oracle WebLogic Managed Server section (Chapter 3, Post Installation Tasks).

Installing Oracle Clinical Development Analytics on Combined Oracle Life Sciences Data Hub and Oracle Business Intelligence Enterprise Edition Server

To install the OCDA application on a combined Oracle LSH and OBIEE Server on UNIX:

  1. Follow steps 1 through 10 in Installing Oracle Clinical Development Analytics on the Oracle Life Sciences Data Hub Server, Installing Oracle Clinical Development Analytics on the Oracle Life Sciences Data Hub Server.

  2. Click Next to continue. In the Select Products Already Installed screen, select the Oracle LSH and OBIEE Both option.

  3. Click Next to continue. In the Enter Oracle CDA Home Directory screen, enter the full path to Oracle CDA home.

    Oracle CDA home is the directory where the installer puts required installation and log files. It is a permanent directory, retained after installation. Oracle recommends that you create CDA home directory under APPL_TOP (sourced by the APPSORA.env file). For example,

    In Unix, <Path to APPL_TOP>/cda

  4. Click Next to continue. In Enter Temporary Staging Area for the Domain File screen, do not modify the default location (the value of APPLPTMP). This is the temporary staging area from where OCDA_domain.zip will be loaded into the database.

  5. Click Next to continue. In Select the Application Server to Use screen, select OC4J or WEBLOGIC as your application server.

  6. Click Next to continue. In the Enter Oracle BI Directory screen, enter the full path to where the Oracle Business Intelligence Enterprise Edition (OBIEE) is installed.

  7. Click Next to continue. In the Enter OBIEE Data Directory screen, enter the full path to where the Web Catalog files are stored.

  8. Click Next to continue. In the Enter Database TNS Name screen, enter a Transparent Network Substrate (TNS) name.

  9. Click Next to continue. In the Enter User Name for the Oracle Applications screen, enter a user name that you created as part of the Oracle Applications installation.

  10. Click Next to continue. In the Enter Password for the Applications User Name screen, enter the password for the Oracle Applications user name you specified, and then confirm the password.

  11. Click Next to continue. In the Enter User Name for Oracle LSH Application screen, enter an existing user name.

    You created this user as a prerequisite to installing OCDA.

  12. Click Next to continue. In the Enter Password for the Oracle LSH Application screen, enter the password for the Oracle LSH user name you specified, and then confirm the password.

  13. Click Next to continue. In the Enter Password for the System User screen, enter the password for the System database user, and then confirm the password.

  14. Click Next to continue. In the Enter Password for the RXI User screen, enter the password for the RXI user that is created as part of the installation.

  15. Click Next to continue. In the Enter Data Tablespace Name screen, enter the name for an existing data tablespace that is used for the default tablespace of the RXI schema.

  16. Click Next to continue. In the Enter Temporary Tablespace Name screen, enter the name for the temporary tablespace that is used for the RXI user.

  17. Click Next to continue.

    • If you have selected OC4J as your application server (in step 5), perform steps 18 to 21.

    • If you have selected WEBLOGIC as your application server (in step 5), perform the following steps:

      1. In the Enter WebLogic Home Directory screen, enter the path of the WebLogic home.

        Important:

        WebLogic Home refers to the top-level directory where user_projects directory is created when you create a domain. For example, if user_projects directory is created as this location C:\Oracle\Middleware\user_projects, the WebLogic Home that you must enter is C:\Oracle\Middleware
      2. Click Next to continue. In the Enter the Domain Name for WebLogic screen, enter the domain name where you want to deploy OCDA.

        Important:

        Before you specify the domain name to deploy OCDA, ensure that you have already created the specified domain.
      3. Perform steps 18 to 21.

  18. Click Next to continue. Information screen reminds you to inspect log files. The following log files are generated in Unix environment:

  19. Click Next to continue. On the Summary screen, review the information about your OCDA installation.

    • setup.txt, ocda_schema_creation.log, and error.txt in OCDA home directory

    • OCDA_domain_import.log in APPLPTMP directory.

  20. Click Install to begin the installation.

  21. Verify the log files.

After you have finished all the installation tasks, you must perform the post installation tasks listed in Chapter 3, Post Installation Tasks.

Note:

In order to complete the installation on Oracle WebLogic Managed Server, perform steps listed in the Deploying Oracle Clinical Development Analytics on Oracle WebLogic Managed Server section (Chapter 3, Post Installation Tasks).

Installing Oracle Clinical Development Analytics on a Stand-alone Database Server

To install the OCDA application when the database is located on a separate server than Oracle LSH (split configuration):

  1. Log in as owner of the Oracle Relational Database Management System (RDBMS) software.

  2. Insert the CD labeled Oracle Clinical Development Analytics 2.0.0.1 into the CD-ROM drive. Transfer the platform specific zip file on the disc to the Oracle LSH server. Extract the contents of the platform specific zip file.

    If you downloaded the OCDA media pack from the Oracle E-Delivery Web site, navigate to the directory where you downloaded and extracted the media pack. Locate the platform specific zip file. Transfer the platform specific zip file to the Oracle LSH server. Extract the contents of the platform specific zip file.

  3. Assign 755 permissions to the contents of the install folder where the installer is unzipped

    chmod -R 755 <Path to directory where the installer is unzipped>

  4. Navigate to the following directory:

    install

  5. Set the X Window display output to your local computer's IP address. For example:

    C shell: setenv DISPLAY 123.45.67.89:0l

  6. Set the APPLPTMP environment variable to the value defined in init.ora.

    For example,

    1. Connect to the LSH/CDA database as sysdba.

    2. @show parameter utl Utl_file_dir /usr/tmp

    3. @export APPLPTMP=/usr/tmp

  7. Invoke the runInstaller executable to launch the installer.

    ./runInstaller

    The installer opens the Welcome screen, which provides information about the Oracle Universal Installer and its options.

  8. Click Next to continue. In the Specify Home Details screen:

    1. Enter a name for this installation.

    2. Enter the full path to Oracle home directory. You can click Browse to navigate through the available directories to select a location for the Oracle home directory.

  9. Click Next to continue. Enter your email address to receive security updates. If you want to receive security updates using My Oracle Support, select I wish to receive security updates via My Oracle Support, and then enter your My Oracle Support password.

  10. Click Next to continue. In the Select Products Already Installed screen, select Oracle Life Sciences Hub (Oracle LSH) Only.

  11. Click Next to continue. In the Oracle CDA Home Directory screen, enter the full path to Oracle CDA home.

    Oracle CDA home is the directory where the installer puts required installation and log files. It is a permanent directory, retained after installation. Oracle recommends that you create CDA home directory under the ORACLE_HOME. For example,

    In Unix, <Path to ORACLE_HOME>/cda

  12. Click Next to continue. In Enter Temporary Staging Area for the Domain File screen, enter the full path of the temporary staging area from where OCDA_domain.zip will be loaded into the database.

    This is a temporary directory where the installer will copy a file that needs to be loaded into the Oracle Database. Enter a valid location. Ensure that this directory has full permission for processes to read/write to this directory. The Oracle database must also have access to this directory so that it can read/write. It is necessary that you set up this directory in the database init.ora settings. Also, create $APPLPTMP variable, defined at Operating System level, pointing to the just created temporary directory.

  13. Click Next to continue. In the Enter Database TNS Name screen, enter a Transparent Network Substrate (TNS) name.

  14. Click Next to continue. In the Enter User Name for the Oracle Applications screen, enter a user name that you created as part of the Oracle Applications installation.

  15. Click Next to continue. In the Enter Password for the Oracle Applications User Name screen, enter the password for the Oracle Applications user name you specified, and then confirm the password.

  16. Click Next to continue. In the Enter User Name for Oracle LSH Application screen, enter an existing user name.

    You created this user as a prerequisite to installing OCDA.

  17. Click Next to continue. In the Enter Password for the Oracle LSH Application User Name screen, enter the password for the Oracle LSH user name you specified, and then confirm the password.

  18. Click Next to continue. In the Enter Password for the System User screen, enter the password for the System database user, and then confirm the password.

  19. Click Next to continue. In the Enter Password for the RXI User screen, enter the password for the RXI user that is created as part of the installation.

  20. Click Next to continue. In the Enter Data Tablespace Name screen, enter the name for an existing data tablespace that is used for the default tablespace of the RXI schema.

  21. Click Next to continue. In the Enter Temporary Tablespace Name screen, enter the name for the temporary tablespace that is used for the RXI user.

  22. Click Next to continue. Information screen reminds you to inspect log files. The following log files are generated in Unix environment:

  23. Click Next to continue. On the Summary screen, review the information about your OCDA installation.

    • setup.txt, ocda_schema_creation.log, and error.txt in OCDA home directory

    • OCDA_domain_import.log in the directory selected in step 12.

  24. Click Install to begin the installation.

  25. Verify the log files.

After you have finished all the installation tasks, you must perform the post installation tasks listed in Chapter 3, Post Installation Tasks.