The documentation portal is undergoing maintenance. During this period, you can't create any new user credentials. If you do, you'll need to recreate the user credential after the maintenance period ends.
Perform the following tasks for the domain configuration repository database:
Set the OPEN_CURSORS parameter to 4000 or higher.
Set permissions on the view
$parameter
in the Oracle database.
Set the privileges to run
show parameter open_cursors
in the Oracle database.
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')
Set the DynamicSections parameter to 3000 or higher in the IBM DB2 database.
The default value for DynamicSections is too low for the Informatica repositories. Informatica requires a larger DB2 package than the default. When you set up the DB2 database for the domain configuration repository or a Model repository, you must set the DynamicSections parameter to at least 3000. If the DynamicSections parameter is set to a lower number, you can encounter problems when you install or run Informatica services.