If you create a new database, you must increase the open_cursors parameter for the eXchange Integrator database to a value of 500.
Some versions of Oracle allow you to do this by using a text editor to modify the init.ora file; see the procedure immediately below.
Other versions of Oracle require you to use the configuration utility.
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.
Start the Oracle configuration utility and open the eXchange database.
Navigate to Databases⇒;(EXCHANGE...)⇒Instance⇒Configuration.
In the General tab, at the bottom, verify the “Started with spfile” parameter has a value such as %ORACLE_HOME%\DATABASE\SPFILE%ORACLE_SID%.ORA.
In the “Edit Database: Configuration [...]” dialog box, click the SPFile option button, scroll to the open_cursors parameter, and change its value to 500.
Click the Apply button. In response to the prompt (“Would you like to apply this change to the current database?”), click Yes.