Install > Installing WebSphere Commerce > Installing WebSphere Commerce using the custom installation > Create a WCS instance > Database considerations when creating WCS instances


Oracle database considerations

As a part of the WCS instance creation process the Configuration Manager creates an Oracle user (schema) for the WebSphere Commerce instance with specific privileges and configuration. You can create your own user manually, using the considerations in this file.

If you wish to create an Oracle user (schema) manually, ensure that the user has the following privileges:

create tablespace tablespaceName datafile 'dataFilePath' 
   size 100M reuse autoextend on next 2M maxsize unlimited; grant create procedure, create session, create synonym, create table, create 
   trigger, create view, create materialized view to oracleUser;

ALTER USER oracleUser QUOTA UNLIMITED ON tablespaceName; 


+

Search Tips   |   Advanced Search