Install > Installing WebSphere Commerce > Installing WebSphere Commerce using the custom installation > Prepare for a custom installation > Preparing database servers to use with WebSphere Commerce > Use an Oracle database
Install and configure Oracle11g Database
Procedure
- Install the following Oracle database components on the database node.
- Oracle11g Database
- Oracle Net Services
- Oracle Call Interface (OCI)
- Create and configure a database for use with WebSphere Commerce.
Take note of the following information...
- User account to own Oracle software
- Oracle database home directory
- Oracle WebSphere Commerce database name
- Oracle SID for WebSphere Commerce database
- Oracle ID and password for database administrator
- Oracle ID and password for WebSphere Commerce database user
- Oracle TCP/IP listener port number
This information is required when creating the WCS instance.
For security reasons, an Oracle DBA account should not be used as the WebSphere Commerce database user.
Do not use SYSTEM or SYS as user IDs for the Commerce schema.
IBM recommends that you use the Oracle automatic memory management feature to manage the Oracle database memory on the system.
Ensure the following settings are applied when creating the Oracle database through the Oracle Database configuration assistant:
Parameter Value block size 8 KB open_cursors 1000 MEMORY_TARGET 700 MB MEMORY_MAX_TARGET 700 MB
Verify the database uses the following character sets:
Parameter Value Database character set AL32UTF8 National character set UTF8
Note that you cannot change character sets after the WebSphere Commerce database is created.
- Complete the creation of the database.
- The WCS instance creation wizard does the following tasks when you select Create a new database or tablespace in the wizard...
- Creates a tablespace for WebSphere Commerce.
- Creates an Oracle database user ID for the WebSphere Commerce database.
The tablespace is assigned as the default to this user ID.
- Populates the WebSphere Commerce tablespace.