Skip Headers
Oracle® Enterprise Data Quality for Product Data Oracle DataLens Server Installation Guide
Release 11g R1 (

Part Number E29137-05
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Feedback page
Contact Us

Go to previous page
Go to next page
PDF · Mobi · ePub

2 Preparing for Installation

This chapter describes how to prepare to install your Oracle DataLens Servers, as well as raises topics that the you should consider and be familiar with before installation begins, including the following:

2.1 Installer Type

The following types of Oracle DataLens Server installers are available:

For information on how to obtain the appropriate installer for your platform, see Section 2.2, "Product Distribution."

2.2 Product Distribution

The Oracle DataLens Server installers are distributed in the following ways:

2.2.1 Downloading the Software From the Oracle Software Delivery Cloud

To download the installer from the Oracle Software Delivery Cloud web site:

  1. Enter the Oracle Software Delivery Cloud URL into a web browser:

  2. Sign into the site.

  3. If prompted, choose your language and click Continue.

  4. Complete the Export License Agreement as instructed on the site, and then click Continue.

  5. On the Media Pack Search page, select E-Business Suite from the Select a Product Pack drop-down list.

  6. From the Platform list, select your operating system.

  7. Click Go.

  8. Select the Oracle Enterprise Data Quality for Product Data 11 Media Pack option and click Continue.

  9. Click the Download button.

  10. Browse to the directory where you want to save the file. Click Save to start the file download. A compressed ZIP file is downloaded.

  11. Extract the ZIP file to the following directory:

    On Linux and UNIX: /opt/edqp_install

    On Windows: C:\edqp_install

    The installation directory now contains the edqp directory. The installers are in the edqp/Disk1 directory. You have all of the files necessary to install Enterprise DQ for Product though additional software is may be required as described in the following section.

2.3 Installation Prerequisites

The following sections describe the installation prerequisites:

2.3.1 Hardware and Software Requirements

You must ensure that the following Oracle DataLens Server hardware and software requirements are observed. These requirements represent the certified and supported server configurations.

Verify that you have met the minimum server requirements using the Oracle Enterprise Data Quality for Product Data Hardware and Software Specification found at the Oracle Enterprise Data Quality for Product Data Documentation web site:

That document contains all necessary specifications including example server configurations. Oracle DataLens Servers have been certified with these hardware and software requirements. For list of certified platforms and versions for Enterprise DQ for Product prior to installation, see Oracle Enterprise Data Quality for Product Data Certification Matrix at

Locate Oracle Enterprise Data Quality in the Product Area column and then click the System Requirements and Supported Platforms for Oracle Enterprise Data Quality for Product Data 11gR1 (11.1.1.x) Certification Matrix (xls) link.

2.3.2 Establishing the Required User Accounts

Three different types of user accounts are required to install and maintain EDQP. You must establish the user accounts described in the following sections.


All administration user accounts created must be unique to ensure a secure environment. EDQP User

A unique administrator user account (dlsadmin for example) is used for all of the servers in the EDQP Server Topology. You then use this administrative user throughout your Oracle DataLens Server Topology to install or maintain these servers.

Contact your system administrator for assistance in creating a new or identifying an existing administrator user account (dlsadmin or other) on the servers that you want to use in the EDQP Server Topology. The administrator user must also adhere to the WebLogic Server security requirements. See Oracle Fusion Middleware Getting Started With Installation for Oracle WebLogic Server 11g Release 1 (10.3.6) and Oracle Fusion Middleware Securing a Production Environment for Oracle WebLogic Server 11g.

Additionally, this administrator user must have full permissions (read, write and execute) to the directories that will contain the EDQP installation files, target installation directory, and all database directories.

Always use this administrator user when logging into any of the Oracle DataLens Servers to perform installation, upgrades, or maintenance. This is applicable to all operating systems. Each full installation results in a separate WebLogic Server instance. When installing an Oracle DataLens Administration Server and a Transform Server, separate WebLogic Server instances are created for each and the login credentials are not shared across the two servers. Logging into a Transform Server or WebLogic Server requires the Administration Server user name and password.


When installing EDQP (or WebLogic) on a UNIX or Linux operating system, do not use the root user as your administrator user account. WebLogic User

A WebLogic administrator user account is necessary to install WebLogic and create the EDQP domain during installation. This is the user account you will then use to administer the domain in the WebLogic Administration Console.

You can use the default WebLogic administrator user (dlsadmin), create a new user, or specify an existing WebLogic administrator user during the installation.

If you are not installing WebLogic as part of your EDQP installation, then you must ensure that you specify the WebLogic administrator user that was used to install the WebLogic instance you want to use with EDQP. Database Administration User

You can create a new database administrator user account or use an existing one that has the privileges to access to the database and ability to create schemas and run the database product. This is applicable to any supported database that you want to use with EDQP.

2.3.3 Installing the Java Development Kit

You must install a supported JDK since both the EDQP and WebLogic Server products rely on it. The JDK provides the Java run-time environment (JRE) and tools for compiling and debugging Java applications.

Install an EDQP supported JDK (see Section 2.3.1, "Hardware and Software Requirements") by downloading and installing it using the instructions provided at

On Windows systems, ensure that you do not install the JDK into a directory that contains spaces, which is the default. For example, you could install the JDK into C:\Programs\Java\jdk1.7.0_13.

On Solaris systems, you must install both the 32-bit and 64-bit JDKs in order to run java applications. Install these JDKs by following the instructions at the Oracle Java SE documentation website at

2.3.4 Downloading the WebLogic Server Installer From Oracle E-Delivery

It is necessary to download the WebLogic Server installer and save it to the same directory that contains the EDQP console mode installer, as described in Section 2.5, "Choosing the Type of Installation." You can automatically install the Weblogic Server and configure the necessary domain using the EDQP console mode installer (recommended) or you can install it.

To download the installer from the Oracle Technology Network:

  1. Enter the Oracle Technology Network WebLogic Server Installers URL in a web browser:

  2. Click OTN License Agreement and read the license agreement.

  3. Select the Accept License option. You must accept the license agreement before you can download the installer.

  4. Scroll down to the Oracle WebLogic Server Previous Releases section of the page, expand the Oracle WebLogic Server 10.3.6 files by clicking the plus sign adjacent to See all files.

  5. Locate the Oracle WebLogic Server 11gR1 (10.3.6) + Coherence - Package Installer and click the File1 link under the Generic file.

    The generic installer file, wls1036_generic.jar, must be downloaded because it contains the installers for all supported operating systems.

  6. If prompted, sign into the Oracle Technology Network.

  7. Browse to the EDQP install directory and click Save to start the file download:

    On Linux and UNIX: /opt/edqp_install/edqp/Disk1

    On Windows: C:\edqp_install\edqp\Disk1

    This is the default location for wls1036_generic.jar file for the EDQP installers so that it can be used to install the WebLogic Server. You can download the file into a different directory and specify this directory during the installation.


Installing in console allows you to choose to automatically install WebLogic Sever and the domain necessary for EDQP to operate; to use the graphical mode installation, you must install and configure WebLogic and the EDQP domain.

2.3.5 Determining the Type of Database Your Oracle DataLens Administration Server Will Use

The Derby database that is installed with your Oracle DataLens Administration Server contains all of the operational information for the server, such as jobs, users, tasks, DSAs, data lenses, FTP and database connections, and other configuration information. Derby is supported only in a development environment; Derby is not supported for production.

If you plan to install the EDQP server in a production environment, you should change the Derby database to another supported database (see Section 2.3.1, "Hardware and Software Requirements"), such as an Oracle Database to create a production environment with optimal system performance and maximum system security of your Oracle DataLens Administration Server. Oracle recommends that you make this change immediately after installation if the server is going to be used in a production environment. If you do not change the database immediately after installation, you will need to reestablish all configuration settings and assets (data lenses and DSAs) in the new database on your Oracle DataLens Administration Server. You will then need to redeploy all assets to all Oracle DataLens Transform Servers in your topology.

In addition, any database that want to interact with your Oracle DataLens Administration Server must have a JDBC database driver configured on the server so that you can create a database connection. Oracle provides WebLogic-branded versions of DataDirect drivers for DB2 and MySQL Server though they are not configured for use in the classpath. For information about configuring databases besides Derby and Oracle Database, see Appendix B, "Known Issues."

2.4 Selecting Directories for Installation

During the installation process, you must specify locations for the following home directories:

The following illustration shows the default Middleware home and the Middleware products directory structure post-installation. In this case, both EDQP and WebLogic Server are installed.

Surrounding text describes dir_structure.png.

Additional directories and files are also located in the Middleware home directory, as described in Table 2-1. The user_projects directory is not present until the first WebLogic domain is created.

2.4.1 Choosing a Middleware Home Directory

When the WebLogic Server is being installed, you are prompted to specify a Middleware home directory. This directory serves as a repository for common files that are used by multiple Fusion Middleware products installed on the same machine. For this reason, the Middleware home directory can be considered a central support directory for all the Fusion Middleware products installed on your system.

The files in the Middleware home directory are essential to ensuring that WebLogic Server operates correctly on your system. They facilitate checking of cross-product dependencies during installation.

When you are installing EDQP, you are prompted to choose an existing Middleware home directory or specify a path to create a new Middleware home directory. If you choose to create a new directory, the installation program automatically creates it for you.

The Middleware home directory is referenced as MW_HOME in Fusion Middleware documentation and this guide.

Middleware Home Considerations

Consider the following information when creating the Middleware home directory and installing Fusion Middleware products:

  • Do not include spaces in the name of your Middleware home directory. If the name of this directory contains spaces, the CLASSPATH may not be resolved properly.

  • You can install only one instance of each version of a WebLogic Server product in a single Middleware home directory. If you need to maintain separate versions of WebLogic Server on the same machine, each version must be in its own Middleware home directory.

    For example, you can install only one instance of the current version of WebLogic Server in a Middleware home directory, but you can have an earlier version of WebLogic Server in a separate Middleware home directory.

  • If the home directory is not empty and it does not contain registry.xml, or if any of the product installation directories are not empty, one of the following messages is displayed:

    • For home directory selection task—Middleware home directory is not empty. Proceed with installation?

    • For product installation directory selection task—One or more installation directories are not empty. Proceed with installation?

Functions of the Home Directory

The directories in the Middleware home directory vary depending on the installer that you are using and the products you selected for installation.

For example, the EDQP installer creates the directories and files listed in the following table.

Table 2-1 Directory Description for Middleware Home

Directory or file Description


This is the EDQP home directory.


This directory contains a history file, which has information about installation and uninstallation for the Middleware home directory.


This directory contains the modules installed in the home directory.


This directory contains directories common to all Fusion Middle ware products, such as OUI.


The WebLogic Server 10.3.6 patch directory containing the patch necessary to EDQP.


Once you create WebLogic domains and applications, this directory is created to store them. This directory contains applications and domains sub-directories. The applications directory contains a sub-directory for each application you create, and the domains directory contains a sub-directory for each domain you create.


This directory contains utilities that are used to support the installation of all products installed in this home directory. For more information on installing patches and patch sets, see Oracle Smart Update Installing Patches and Maintenance Packs.


The WebLogic Server home directory.


This file contains the information about the Middleware home directory.


This response file contains information about the Oracle Configuration Manager (OCM) installation.


This registry file contains a persistent record of all WebLogic products installed on the target system. This registry contains product-related information, such as version number, patch set level, patch level, and location of the product installation directories. It also contains the name of the installed JDK(s) and the Java home.

Note: Do not edit this file manually. Doing so may cause operating problems for the currently installed WebLogic products, or result in installation problems when future products or maintenance upgrades are installed.


This is an encrypted version of the registry.xml file.


This registry file contains the location of all domains currently registered with this WebLogic Server installation. Whenever you add a new domain, it is registered in this file.

2.4.2 Choosing Product Installation Directories

During the installation, you will be prompted to enter the home directories for the following products:

  • EDQP

    The EDQP home directory contains all the components necessary to the product, including the Developers Toolkit that includes APIs and Command Line Interface, the Endeca Connector, and the Oracle Fusion and R12 Product Information Management (PIM) installation files. The default installation directory for EDQP is:

    On Linux and UNIX: /opt/Oracle/Middleware/edqp_template1

    On Windows: C:\Oracle\Middleware\edqp_template1

    This directory path is referenced as the EDQP_HOME directory in this document.

  • WebLogic Server

    The default installation directory for WebLogic Server 10.3.6 is:

    On Linux and UNIX: /opt/Oracle/Middleware/wls_server_10.3

    On Windows: C:\Oracle\Middleware\wls_server_10.3

    This directory path is referenced as the WL_HOME directory in this document.

  • JDK

    You must locate the directory into which you installed the JDK/JRE. For example, the directories may be:

    On Linux and UNIX: /opt/jdk1.6.0_30

    On Windows: C:\Program Files\Java\jdk1.6.0_30

2.5 Choosing the Type of Installation

You can run the installation program in the following modes:

In either mode, a sample domain is preconfigured to use the Derby database are created only for the installed components. Derby is supported only in a development environment. Derby is not supported for production