Table of Contents

Search

  1. Preface
  2. Part 1: Installation Getting Started
  3. Part 2: Before You Install the Services
  4. Part 3: Run the Services Installer
  5. Part 4: After You Install the Services
  6. Part 5: Informatica Client Installation
  7. Part 6: Uninstallation
  8. Appendix A: Starting and Stopping Informatica Services
  9. Appendix B: Connecting to Databases from UNIX or Linux
  10. Appendix C: Updating the DynamicSections Parameter of a DB2 Database

Installation for Data Engineering

Installation for Data Engineering

Oracle Database Requirements

Oracle Database Requirements

Use the following guidelines when you set up the repository on Oracle:
  • Set the open_cursors parameter to 4000 or higher.
  • Set the permissions on the view
    $parameter
    for the database user.
  • Set the privileges for the database user to run
    show parameter open_cursors
    in the Oracle database.
    When you run the pre-installation (i10Pi) system check tool, i10Pi runs the command against the database to identify the OPEN_CURSORS parameter with the domain database user credentials.
    You can run the following query to determine the open cursors setting for the domain database user account:
    SELECT VALUE OPEN_CURSORS FROM V$PARAMETER WHERE UPPER(NAME)=UPPER('OPEN_CURSORS')
  • Verify that the database user has the following privileges:

      CREATE SEQUENCE

      CREATE SESSION

      CREATE SYNONYM

      CREATE TABLE

      CREATE VIEW

  • Informatica does not support Oracle public synonyms for repository tables. Verify that public synonyms have not been created for any tables in the database.