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 storage size for the tablespace to a small number to prevent the repository from using an excessive amount of space. Also verify that the default tablespace for the user that owns the repository tables is set to a small size.
    The following example shows how to set the recommended storage parameter for a tablespace named REPOSITORY:
    ALTER TABLESPACE "REPOSITORY" DEFAULT STORAGE ( INITIAL 10K NEXT 10K MAXEXTENTS UNLIMITED PCTINCREASE 50 );
    Verify or change the storage parameter for a tablespace before you create the repository.
  • 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.