Upgrading from Version 10.2 (10.4.1)

10.4.1
- 10.5.6
- 10.5.5.1
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.0

Back Next

Verify Database User Account Requirements

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.

Rename Saved Search

Table of Contents

Upgrading from Version 10.2 (10.4.1)

Upgrading from Version 10.2 (10.4.1)

Verify Database User Account Requirements

Verify Database User Account Requirements