Table of Contents

Search

  1. Preface
  2. Prepare to Install Data Validation Option
  3. Install Data Validation Option
  4. Configure Data Validation Option
  5. Configuring Multiple Environments
  6. Upgrade Data Validation Option
  7. Install DVOcmd on UNIX
  8. Appendix A: Installation and Configuration Checklist

Data Validation Option Installation and Configuration Guide

Data Validation Option Installation and Configuration Guide

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 ALTER TABLE, CREATE INDEX, CREATE SEQUENCE, CREATE SESSION, CREATE SYNONYM, CREATE TABLE, CREATE VIEW, and INSERT INTO TABLE privileges.
  • Verify that HIBERNATE_SEQUENCE has SELECT and ALTER privileges.
  • Verify that public synonyms have not been created for any tables in the database. Informatica does not support Oracle public synonyms for repository tables.
  • Verify that the NLS setting is compatible with the code page of the PowerCenter Integration Service process. If the PowerCenter Integration Service runs on a grid, verify the compatibility for every PowerCenter Integration Service process in the grid.

0 COMMENTS

We’d like to hear from you!