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.