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:
  • Verify that the database user has the following privileges:

      ALTER TABLE

      CREATE ANY INDEX

      CREATE PROCEDURE

      CREATE SESSION

      CREATE TABLE

      CREATE VIEW

      DROP TABLE

      UPDATE TABLE

  • Informatica does not support Oracle public synonyms for repository tables. Verify that public synonyms have not been created for any tables in the database.
  • Set the following parameters to the Informatica recommended values:
    Parameter
    Recommended Value
    open_cursors
    4000
    Sessions
    1000
    Processes
    1000