websphere commerce

      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...

      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...

  Create DMGR profiles on WAS 8.5.5 [wcsadmin@wcs7 bin]$ pwd /opt/WAS855/WebSphere/AppServer/bin [wcsadmin@wcs7 bin]$ ./manageprofiles.sh -create -profileName Dmgr01 -profilePath /opt/WAS855/WebSphere/AppServer/profiles/Dmgr01 -templatePath /opt/WAS855/WebSphere/AppServer/profileTemplates/management -serverType DEPLOYMENT_MANAGER -nodeName Node name -cellName Cellname -hostName hostname INSTCONFSUCCESS: Success: Profile Dmgr01 now exists. Please consult /opt/WAS855/WebSphere/AppServer/profiles/Dmgr01/logs/AboutThisProfile.txt for more information about this profile.

 Backup All Solr Node Profiles on Wcs V7 [wcsadmin@wcs7 bin]$ ./backupConfig.sh -nostop ADMU0116I: Tool information is being logged in file            /opt/IBM/WebSphere/AppServer/profiles/QAStage_solr/logs/backupConfig.log ADMU0128I: Starting tool with the QAStage_solr profile ADMU5001I: Backing up config directory            /opt/IBM/WebSphere/AppServer/profiles/QAStage_solr/config to file            /opt/IBM/WebSphere/AppServer/profiles/QAStage_solr/bin/WebSphereConfig_date.zip

  Backup All Commerce Node Profiles on V7 [wcsadmin@wcsv7 bin]$ ./backupConfig.sh -nostop ADMU0116I: Tool information is being logged in file            /opt/IBM/WebSphere/AppServer/profiles/QAStage/logs/backupConfig.log ADMU0128I: Starting tool with the QAStage profile ADMU5001I: Backing up config directory            /opt/IBM/WebSphere/AppServer/profiles/QAStage/config to file            /opt/IBM/WebSphere/AppServer/profiles/QAStage/bin/WebSphereConfig_date.zip

 (Backup DMGR profile on V7) [wcsadmin@wcs7 bin]$ pwd /opt/IBM/WebSphere/AppServer/profiles/Dmgr01/bin [wcsadmin@wcs7 bin]$ ./backupConfig.sh -nostop ADMU0116I: Tool information is being logged in file            /opt/IBM/WebSphere/AppServer/profiles/Dmgr01/logs/backupConfig.log ADMU0128I: Starting tool with the Dmgr01 profile ADMU5001I: Backing up config directory            /opt/IBM/WebSphere/AppServer/profiles/Dmgr01/config to file            /opt/IBM/WebSphere/AppServer/profiles/Dmgr01/bin/WebSphereConfig_date.zip