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:
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:
- Install the Oracle client software on the same machine where InterChange
Server is installed.
- Install the SQL*Net client components on the same machine where
InterChange Server is installed. The SQL*Net Client is required for
network access and system troubleshooting.
The following steps describe how to configure Oracle for use with
InterChange Server during the Oracle installation process:
- Start the Installer and click Next on the Welcome screen.
- At the File Locations screen, set the Destination Name to
ORACLE_HOME and set the Path to where you want Oracle
installed.
- Select Oracle8i Enterprise Edition
8.1.7.4.0.0 in the Available Products
screen and click Next.
- Select Typical (779 MB) for Oracle8i
8.1.7.4.0.0 in the Installation Types
screen and click Next.
- 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.
- Click Install on the Summary screen.
- On the Net8 Configuration Assistant screen, select the "Perform
typical configuration" check box.
- Click Next and Finish.
The following steps describe how to configure Oracle for use with
InterChange Server during the Oracle installation process:
- Start the Installer and click Next on the Welcome screen.
- 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.
- Select Oracle9i Database 9.2.0.4 in the Available
Products screen and click Next.
- Select Enterprise Edition in the Installation Types screen and click
Next.
- Select General Purpose in the Database Configuration screen and click
Next.
- 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.
- Accept the default installation directory for database files or browse for
a different location, then click Next.
- Select the appropriate database character set from the list of character
sets and click Next.
- Click Install in the Summary screen.
- Change your passwords (if desired) on the Oracle Database Configuration
Assistant window and click Exit.
- Click Exit on the "End of Installation" screen.
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:
- Click Start > Programs > IBM WebSphere InterChange Server > IBM
WebSphere InterChange Server > IBM WebSphere InterChange Server
Configuration Wizard.
- On the InterChange Server Configuration window, click the Database tab,
modify the parameters, then click Apply.
- Click OK on the Changes complete window, then click Exit.
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:
- 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.
- 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.
- 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.
- 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.
- 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.
- On the Oracle Enterprise Manager password encryption messenger, click
OK.
- Keep the Oracle DBA Studio open, and proceed to 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:
- In the Oracle DBA Studio, expand cwld, then
expand storage.
- Right-click the Tablespaces folder, then click Create.
- In the Create Tablespace dialog box, set the
following parameters:
In the General tab:
- 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.
- In the Size field, type a value 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.
In the Storage tab, select "Managed in the Dictionary" for Extent
Management.
- Select the Override default Extent Values check box and type the following
values:
- Initial Size = 1024KB
- Next Size = 20KB
- Minimum Size = 0
- Increment Size By = 0
- Minimum Number = 1
- Maximum Number = unlimited
- Enable logging = yes (default)
- Click Create and OK.
- Repeat steps 1 through 5 to create the temporary tablespace and modify the
following information:
- General Tab: Name = CWTEMP Size = 500MB
- Storage Tab: Initial Size = 20KB Next Size = 20KB
- Select the Temporary check box.
- Repeat steps 1 through 5 to create the rollback tablespace and modify the
following information:
- General Tab: Name = CWROLLBACK Size = 500MB
- Storage Tab: Initial Size = 1024KB Next Size = 1024KB
- 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:
- In the Oracle DBA Studio, expand wicsrepos, then expand
storage.
- Right-click the Tablespaces folder, then click Create.
- 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.
- 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.
- In the Storage tab, select Locally managed and Automatic
Allocation.
- Click Create and OK.
- Repeat steps 1 through 6 to create the temporary tablespace and modify the
following information in the General tab:
- Name = CWTEMP
- Size = 500MB
- Repeat steps 1 through 6 to create the rollback tablespace and modify the
following information in the General tab:
- Name = CWROLLBACK
- Size = 500MB
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.
- In the Oracle DBA Studio, expand cwld,
expand Storage, then expand the Tablespaces folder.
- Right-click CWROLLBACK, then select Add Rollback
Segment.
In the Create Rollback Segment dialog box:
- In the General tab, select the Public check box.
- In the General tab, type CW_RBS1 in the Name field.
- In the Storage tab, type the following
values for storage parameters:
- Initial Size: 1024KB
- Next Size: 1024KB
- Optimal Size: 20480KB
- Minimum Number: 2
- Maximum Number: Unlimited
- Accept all other defaults, then click Create.
- On the Oracle Enterprise Manager window with
the message "Rollback Segment created successfully," click OK.
- 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
- Keep the Oracle DBA Studio open, and proceed to Creating the user and granting user access.
Create the ICS user and grant tablespace access to
wicsrepos.
- In the Oracle DBA Studio (the Oracle
Enterprise Manager Console Standalone for version 9i), expand cwld, then
expand Security.
- Right-click the Users folder, then select Create.
- In the Create User dialog box, enter the following values:
- In the General tab:
- Name: CROSSWORLDS
- Profile: DEFAULT
- Authentication: Password
- Password: admin
- Default: cwld
- Temporary: CWTEMP
- Status: Unlocked
- In the Role tab:
Click the arrow buttons in the middle of the screen to move the Connect
role from the Granted list to the Available list, and move the DBA role from
the Available list to the Granted list.
- In the System Privileges tab (System tab in 9i):
Click the arrow buttons in the middle of the screen to move the
"Unlimited Tablespace" privilege from the Granted list to the
Available list.
- Accept all other defaults, then click Create.
- On the Oracle Enterprise Manager window with the message "User created
successfully,"click OK.
- To check that you have set the correct parameters, expand the Users
folder, then select CROSSWORLDS. Check the parameters in the
right pane.
- 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
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:
- Make a copy of the
ProductDir\admin\cwld\pfile\init.ora file for
backup. Rename the copy as a .txt file.
- Use Notepad or another text editor to open the init.txt
file.
- 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
|
- Save the init.ora file, and close the text
editor.
- Restart your machine.
Oracle 9i
Modify the server parameter file by opening an Oracle command prompt and
entering the following statements:
- SQL> ALTER SYSTEM SET open_cursors=1500 scope=both;
- SQL> ALTER SYSTEM SET db_file_multiblock_read_count=32
scope=both;
- SQL> ALTER SYSTEM SET processes=300 scope=spfile;
