When you run the pre-installation (i10Pi) system check tool, i10Pi runs the command against the database to identify the OPEN_CURSORS parameter with the domain database user credentials.

You can run the following query to determine the open cursors setting for the domain database user account:

 SELECT VALUE OPEN_CURSORS FROM V$PARAMETER WHERE UPPER(NAME)=UPPER('OPEN_CURSORS')

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.