English
  • Shared Content for Data Engineering 10.5
  • All Products

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

Back Next

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

      ALTER VIEW

      CREATE SEQUENCE

      CREATE SESSION

      CREATE SYNONYM

      CREATE TABLE

      CREATE VIEW

      DROP TABLE

      DROP 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.
  • Set the connection pooling parameters.
    The following table lists the connection pooling parameters that you must set:
    Parameter
    Value
    Maximum Connection Pool Size
    128
    Minimum Connection Pool Size
    0
    Maximum Idle Time
    120 seconds