Upgrading from Version 10.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.
For more information about updating the DynamicSections parameter, see Updating the DynamicSections Parameter of a DB2 Database.

Updated May 14, 2019

Explore Informatica Network