Installation for PowerCenter and Data Quality

10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0

Back Next

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. Default session value is calculated using the expression: (1.5 * PROCESSES) + 22. If the session value is lower than the default value, the Oracle database uses the default session value.
Processes	1000