Sun B2B Suite eXchange Integrator User's Guide

ProcedureTo edit the value of open_cursors in the init.ora file for the eXchange Integrator database

  1. Navigate to Oracle home\admin\eXchange database name\pfile\. For example:


    cd C:\oracle\admin\exchange\pfile
  2. Use a text editor to open the init.ora file in this folder. For example:


    notepad init.ora
  3. Search for the text open_cursors; if not found, add a new line. Edit the line so that it reads as follows:


    open_cursors = 500
  4. Save the file.

  5. Restart the database.

    Next: Continue with the steps in Extracting, Customizing, and Running Database Setup Scripts; at this release, you must extract and run database scripts whether you are installing from scratch or upgrading a previous release of eXchange Integrator.