Navigate to Oracle home\admin\eXchange database name\pfile\. For example:
cd C:\oracle\admin\exchange\pfile |
Use a text editor to open the init.ora file in this folder. For example:
notepad init.ora |
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 |
Save the file.
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.