Use the following guidelines when you set up the repository on Oracle:
Set the OPEN_CURSORS parameter to 4000 or higher.
Verify that the database user has the following privileges:
Informatica does not support Oracle public synonyms for repository tables. Verify that public synonyms have not been created for any tables in the database.
You can configure the connection between the Informatica domain, Model Repository Service, or PowerCenter Repository Service and Oracle RAC. Oracle Real Application Clusters (RAC) enables high availability of database applications. The Informatica domain, Model Repository Service, and PowerCenter Repository Service are resilient to failover of Oracle RAC databases for all CRUD operations.
You cannot perform any administrator operations with Oracle RAC database failover for Informatica domain and Model Repository Service.