Create wcs instance

 

 

 Create WCS instance

·       Log in to WCS server as wcsadmin.

·       Open the following file /opt/IBM/WebSphere/CommmerceServer80/schema/oracle/wcs.data.sql

·       Replace

INSERT INTO dmelementnvp (dmelement_id, name, value) select i,n,v from (SELECT dmelement_id, 'socialActivityType', '*' FROM dmelement WHERE dmeletemplate_id IN (160, 215) UNION ALL SELECT dmelement_id, 'comparison', 'any' FROM dmelement WHERE dmeletemplate_id IN (160, 215)) s (i,n,v) where not exists (select 1 from dmelementnvp where dmelement_id = i and name = n and value = v);

 

With:

INSERT INTO dmelementnvp (dmelement_id, name, value)

select i,n,v from (SELECT dmelement_id i, 'socialActivityType' n, '*' v FROM dmelement WHERE dmeletemplate_id IN (160, 215)

                   UNION ALL

                  SELECT dmelement_id i , 'comparison' n, 'any' v FROM dmelement WHERE dmeletemplate_id IN (160, 215)

               ) s

where not exists (select 1 from dmelementnvp where dmelement_id = i and name = n and value = v);

·       Save and exit.

·       Create a directory /opt/IBM/WebSphere/CommerceServer80/instances/DEMO/properties

·       Run the following command

cp /opt/wcsfiles/RESOURCES/WCS_INSTANCES/LIVE/TEMPLATE-LIVEver01_createInstance.properties /opt/IBM/WebSphere/CommerceServer80/instances/DEMO/properties/createInstance.properties

·       Edit createInstance.properties and update it with environment specific information such as database user, password, dba user, password, db connection url etc. A sample file is attached here.


·       Create WCS Instance. You can tail /opt/IBM/CommerceServer80/instances/DEMO/logs/createInstanceANT.log

cd /opt/IBM/WebSphere/CommerceServer80/bin

 

./config_ant.sh -DinstanceName=DEMO -verbose

·       After instance creation, check the wcs_instances file to make sure instance exist

 

Comments

Post a Comment

Popular posts from this blog

Docker build

 The `docker build` command is used to build Docker images from a `Dockerfile`. This command automates the process of creating a Docker image by executing the instructions defined in the Dockerfile. Let’s break down the internal workings of `docker build` step by step: --- ### 1. **What is `docker build`?** The `docker build` command creates a Docker image from a **Dockerfile**, which is a text file that contains a series of instructions on how to assemble the image. The process takes the base image, applies modifications step-by-step (such as adding files, installing packages, or setting environment variables), and creates a final image that can be used to run containers. ### 2. **Command Syntax** ```bash docker build [OPTIONS] PATH | URL | - ``` - **PATH**: This is the path to the directory containing the `Dockerfile`. It can also be a URL or `-` (for reading from stdin). - **OPTIONS**: There are several options available, like `-t` for tagging, `--file` for specifying a differen...
Read more

Create Oracle users with correct permissions in wcs commerce

      Create Oracle users with correct permissions ·        Login to Oracle SQL developer as a master user ·        Run the following scripts to create a database user and DBA user. Make sure you change username according to the environment. If createInstance fails and you need to drop and recreate users, you don’t need to run the “create tablespace” command again.   # Install/Configure Oracle database # Configure the oracle database # Change the user and passwords according to the environment create tablespace WCTBLSPC datafile size 100M autoextend on next 2M maxsize unlimited; CREATE USER jbdev2user IDENTIFIED BY jbdev2user DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP"; CREATE USER jbdev2dba IDENTIFIED BY jbdev2dba DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP"; grant create procedure, create sequence, create session, create synonym, create table,cre...
Read more