Table of Contents

Search

  1. Preface
  2. Upgrade Overview
  3. Before You Upgrade the Domain on Linux
  4. Before You Upgrade the Domain on UNIX
  5. Before You Upgrade the Domain on Windows
  6. Prepare for the Upgrade
  7. Upgrade the Domain
  8. Upgrade the Domain with Changes to Node Configuration
  9. Before You Upgrade the Application Services
  10. Application Service Upgrade
  11. Informatica Client Upgrade
  12. After You Upgrade
  13. Upgrade Checklist

Upgrading from Version 10.0 (10.4.1)

Upgrading from Version 10.0 (10.4.1)

Verify Database User Account Requirements

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.

0 COMMENTS

We’d like to hear from you!