Oracle Server

IBM has certified Oracle Server versions 8.1.7.4 and 9.2.0.4 (9i) for use as a database server for supported Windows operating environments (Professional, Server, and Advanced Server).

Note:
Oracle Server version 8.1.7.4 is not supported on Windows 2003.

Procedures for installing and configuring Oracle Server are explained in the following sections:

Installation recommendations

The recommendations in this section may help if you are installing Oracle Server to run with InterChange Server. Your environment may have different requirements. Refer to Oracle Server documentation for more detailed instructions. For tablespace size suggestions, see Appendix C, Windows installation checklists.

Before installing Oracle Server, stop all previous versions of Oracle Server running on the same machine (if any exist). For performance and administrative purposes, installing multiple Oracle homes on the same machine is not recommended.

For best performance, install the Oracle Server and its server networking components on a machine other than that on which InterChange Server is installed. If you follow this recommendation, you must also do the following:

Configuring Oracle Server version 8.1.7.4

The following steps describe how to configure Oracle for use with InterChange Server during the Oracle installation process:

  1. Start the Installer and click Next on the Welcome screen.
  2. At the File Locations screen, set the Destination Name to ORACLE_HOME and set the Path to where you want Oracle installed.
  3. Select Oracle8i Enterprise Edition 8.1.7.4.0.0 in the Available Products screen and click Next.
  4. Select Typical (779 MB) for Oracle8i 8.1.7.4.0.0 in the Installation Types screen and click Next.
  5. If you selected to install a database, name the database and SID in the Database Identification screen and click Next.
    Note:
    It is useful to use the name wicsrepos for both. However, another name may be chosen.
  6. Click Install on the Summary screen.
  7. On the Net8 Configuration Assistant screen, select the "Perform typical configuration" check box.
  8. Click Next and Finish.

Configuring Oracle Server version 9i

The following steps describe how to configure Oracle for use with InterChange Server during the Oracle installation process:

  1. Start the Installer and click Next on the Welcome screen.
  2. At the File Locations screen, set the Destination Name to ORACLE_HOME and set the Path to where you want Oracle Server installed. Click next.
  3. Select Oracle9i Database 9.2.0.4 in the Available Products screen and click Next.
  4. Select Enterprise Edition in the Installation Types screen and click Next.
  5. Select General Purpose in the Database Configuration screen and click Next.
  6. If you selected to install a database, name the database and SID in the Database Identification screen and click Next.
    Note:
    It is useful to use the name wicsrepos for both. However, another name may be chosen.
  7. Accept the default installation directory for database files or browse for a different location, then click Next.
  8. Select the appropriate database character set from the list of character sets and click Next.
  9. Click Install in the Summary screen.
  10. Change your passwords (if desired) on the Oracle Database Configuration Assistant window and click Exit.
  11. Click Exit on the "End of Installation" screen.

Modifying the InterchangeSystem.cfg file

If you plan to use the Installer to install the InterChange Server software, you may skip this section. Installer generates the correct InterchangeSystem.cfg file. Proceed to "Configuring Oracle Server".

For Oracle 8.1.7.4 and 9.2.0.4 (9i), InterChange Server uses a Type 4 JDBC driver.

To modify the InterchangeSystem.cfg file:

  1. Click Start > Programs > IBM WebSphere InterChange Server > IBM WebSphere InterChange Server > IBM WebSphere InterChange Server Configuration Wizard.
  2. On the InterChange Server Configuration window, click the Database tab, modify the parameters, then click Apply.
  3. Click OK on the Changes complete window, then click Exit.

Configuring Oracle Server

These instructions describe one method for configuring Oracle to work efficiently with the InterChange Server system. Your environment may require that you configure Oracle differently. Be sure to read Installation recommendations The following topics are covered:

Adding the database to the DBA Studio

Important:
If you are using InterChange Server in an internationalized environment, set the NLS_LANG environment variable as follows:
NLS_LANG = language_territory.UTF-8

Where language is the name of your locale's language and territory is the name of your locale's territory. For example, the NLS_LANG setting for the US locale is NLS_LANG = AMERICAN_AMERICA.UTF-8.

  1. For Oracle 8.1.7.4, click Start > Programs > Oracle - OraHome81 > Database Administration > DBA Studio.

    For Oracle 9i, click Start > Programs > Oracle - ORACLE_HOME > Enterprise Manager Console.

  2. On the Oracle Enterprise Manager Login dialog screen, select Launch DBA Studio standalone (Launch Standalone for version 9i), then click OK.

    For Oracle 8.1.7.4, the Oracle DBA Studio opens to the "Add Database to Tree" dialog box .

    For Oracle 9i, the Oracle Enterprise Manager Console Standalone opens. Select "Add Database to Tree" from the Navigator menu.

    Note:
    The Add Database To Tree dialog box appears only the first time you connect to the Oracle DBA Studio. It allows you to configure the startup database that was automatically created during installation.
  3. Select "Add selected databases from your local tnsnames.ora file located in ProductDir\Oraxx\NETWORK\ADMIN". Select the wicsrepos check box from the Service Name list, clear all other service names, then click OK.

    For version 9i, wicsrepos appears in the left pane of the Oracle DBA Studio.

  4. Expand wicsrepos. In the Database Connect Information dialog box type the following user name and password:

    Username: system

    Password: manager

    Select the Save as Local Preferred Credentials check box, then click OK.

  5. On the Oracle Enterprise Manager password encryption messenger, click OK.
  6. Keep the Oracle DBA Studio open, and proceed to Storage configuration.

Storage configuration

In this procedure, you create the InterChange Server repository, temporary, and rollback tablespaces.

Note:
The tablespace sizes shown in this section are examples only. Configure your settings based on your specific InterChange Server implementation.

Oracle 8.1.7.4

To create the repository, temporary, and rollback tablespaces:

  1. In the Oracle DBA Studio, expand cwld, then expand storage.
  2. Right-click the Tablespaces folder, then click Create.
  3. In the Create Tablespace dialog box, set the following parameters:

    In the General tab:

    In the Storage tab, select "Managed in the Dictionary" for Extent Management.

  4. Select the Override default Extent Values check box and type the following values:
  5. Click Create and OK.
  6. Repeat steps 1 through 5 to create the temporary tablespace and modify the following information:
  7. Select the Temporary check box.
  8. Repeat steps 1 through 5 to create the rollback tablespace and modify the following information:
  9. Keep the Oracle DBA Studio open, and proceed to Creating rollback segments (Oracle 8.1.7.4 only).

Oracle 9i

To create the repository, temporary, and rollback tablespaces:

  1. In the Oracle DBA Studio, expand wicsrepos, then expand storage.
  2. Right-click the Tablespaces folder, then click Create.
  3. In the General tab of the Create Tablespace dialog box, type wicsrepos in the Name field. You do not need to type all capital letters; the Oracle installation program displays what you type in all capital letters.
  4. Type a value in the Size field that is, at a minimum, large enough to contain and use the repository, for example, 300 MB. Allow at least 30 MB for each installation of the repository. For example, if 10 users will use the system, make the file size at least 10 x 30 = 300 MB.
  5. In the Storage tab, select Locally managed and Automatic Allocation.
  6. Click Create and OK.
  7. Repeat steps 1 through 6 to create the temporary tablespace and modify the following information in the General tab:
  8. Repeat steps 1 through 6 to create the rollback tablespace and modify the following information in the General tab:

Creating rollback segments (Oracle 8.1.7.4 only)

Create the rollback segments after you have created the CWROLLBACK tablespace (see the previous section) and before you create the ICS user.

In this procedure, you create the rollback segments that the repository uses.

  1. In the Oracle DBA Studio, expand cwld, expand Storage, then expand the Tablespaces folder.
  2. Right-click CWROLLBACK, then select Add Rollback Segment.

    In the Create Rollback Segment dialog box:

  3. Accept all other defaults, then click Create.
  4. On the Oracle Enterprise Manager window with the message "Rollback Segment created successfully," click OK.
  5. Create four more rollback segments using the instructions in steps 1 through 4. Set the same storage parameters as those in step 1 and use the following names:

    CW_RBS2 CW_RBS3 CW_RBS4 CW_RBS5

  6. Keep the Oracle DBA Studio open, and proceed to Creating the user and granting user access.

Creating the user and granting user access

Create the ICS user and grant tablespace access to wicsrepos.

  1. In the Oracle DBA Studio (the Oracle Enterprise Manager Console Standalone for version 9i), expand cwld, then expand Security.
  2. Right-click the Users folder, then select Create.
  3. In the Create User dialog box, enter the following values:
  4. Accept all other defaults, then click Create.
  5. On the Oracle Enterprise Manager window with the message "User created successfully,"click OK.
  6. To check that you have set the correct parameters, expand the Users folder, then select CROSSWORLDS. Check the parameters in the right pane.
  7. Exit the Oracle DBA Studio (the Oracle Enterprise Manager Console Standalone for version 9i).
    Note:
    To properly shut down the instance of the database, type each of the following commands separately and in sequence into a command prompt window:

    Oracle 8.1.7.4

    svrmgrl
    connect internal
    shutdown normal
    exit
    

    Oracle 9i

    sqlplus /nolog
    connect / as sysdba
    shutdown normal
    exit
    

Configuring the database initialization parameters

Oracle uses default parameters to initialize the integration broker repository. The following instructions explain how to modify some of those parameters for optimal performance with ICS.

To configure the parameters, follow these steps:

Oracle 8.1.7.4

Modify the init.ora file:

  1. Make a copy of the ProductDir\admin\cwld\pfile\init.ora file for backup. Rename the copy as a .txt file.
  2. Use Notepad or another text editor to open the init.txt file.
  3. Change the parameters in Table 4.

    Table 4. Changing parameters in the init.ora file

    Find the following text: Replace it with the following text:
    open_cursors = 300 (Oracle 8.1.7.4)
    open_cursors = 1200
    

    Note: Set a value of at least 1200 for open cursors. You may set a highter value, depending on the requirements of your system.

    db_file_multiblock_read_count = 8 db_file_multiblock_read_count = 32
    processes = 150 processes = 300
  4. Save the init.ora file, and close the text editor.
  5. Restart your machine.

Oracle 9i

Modify the server parameter file by opening an Oracle command prompt and entering the following statements:

Copyright IBM Corp. 1997, 2004