Creating and Configuring the eXchange Integrator Database Instance

Before you begin: You need to have already created an Oracle database instance with an entry in the tnsnames.ora file. Your TNSlistener service must be running, and you need to know the name of the database instance (default: eXchange) and to temporarily use the system username/password (default: sys/manager or system/manager).

If you have never installed an Oracle database, ask your Oracle database administrator for help. The following constitutes a brief reminder of how to use the Oracle 9i wizard.

To create a new database instance for eXchange Integrator

1. (“Operations”): Choose Create a database.

2. (“Database Templates”): Choose New Database.

3. (“Database Identification”): Enter (for example) eXchange

4. (“Database Features”): Deselect all checkboxes and reply Yes to all prompts.

5. (“Database Connection Options”): Choose Dedicated [...].

6. (“Initialization Parameters”): Keep all values unchanged.

7. (“Database Storage”): Under Datafiles, click \{DB_Name}\undotbs01.dbf (the fifth entry). In the General tab, reduce File Size from 200 to 100.

8. (“Creation Options”): Choose Create Database, and then click Finish.

Modifying the init.ora File for the eXchange Integrator Database

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.

To 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.

To configure the value of open_cursors in the eXchange Integrator database

1. Start the Oracle configuration utility and open the eXchange database.

2. Navigate to Databases⇒;(EXCHANGE...)⇒Instance⇒Configuration.

3. 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.

   Figure 2–8 Oracle Configuration of Initialization Parameters: General Tab

   
   

4. In the “Edit Database: Configuration [...]” dialog box, click the SPFile option button, scroll to the open_cursors parameter, and change its value to 500.

   

5. Click the Apply button. In response to the prompt (“Would you like to apply this change to the current database?”), click Yes.