Configuring WCS V7 FEP4 toolkit and Oracle 11g Release 2

What an experience it has been to configure and run my toolkit with a local Oracle installation, I decided to document some of the errors I encountered, hopefully this will help others.

My software stack

WCS V7 toolkit with feature pack 4, fix pack 5
Windows 7 OS (64 bit)
Oracle 11g, Release 2 (installed the "desktop class"  version, this is supposed to be lite version of server edition)

All of the software stack is installed on a single host machine.

Step 1.a
I started with installation of a 64 bit version of Oracle server/client on my laptop, this was probably the first biggest mistake, and here is some explanation and possible workaround.
"WCS developer still makes use of a 32 bit JVM and hence would require a 32 bit Oracle driver"

c:\IBM\WCDE_ENT70\bin>setdbtype.bat oracle "C:\app\~\product\11.2.0\dbhome_2" wcs sys Oracle123 wcs7dev wcs7dev createdb

Error 1

"\Common was unexpected at this time"

to resolve this issue I had to edit c:\IBM\WCDE_ENT70\bin\setenv.bat

and replace following line 

set PATH=%JAVA_HOME%\bin;%PATH%

with following entry

set PATH=%JAVA_HOME%\bin;c:\app\~\product\11.2.0\dbhome_2\bin;C:\Windows\system32;C:\Windows

I believe the issue here is the default script appends rest of system path setting and it had few lengthy URL with spaces etc.. so I decided to include only the path entries required for setdbtype script.

again... I'm not very sure of the root cause, but this hack worked fine for me.

Error 2

All of the tables were created successfully, buy It fails during massload with following error.

"WCS massload utility makes use of OCI driver and expects a 32 bit version of the driver"

Exception in thread "main" java.lang.UnsatisfiedLinkError: ocijdbc11 (.\ocijdbc11.dll is not a valid Win32 application. )

at java.lang.ClassLoader.loadLibraryWithPath(ClassLoader.java:1011)

at java.lang.ClassLoader.loadLibraryWithClassLoader(ClassLoader.java:975)

at java.lang.System.loadLibrary(System.java:469)

at oracle.jdbc.driver.T2CConnection$1.run(T2CConnection.java:3506)

at java.security.AccessController.doPrivileged(AccessController.java:202)

at oracle.jdbc.driver.T2CConnection.loadNativeLibrary(T2CConnection.java:3502)

at oracle.jdbc.driver.T2CConnection.logon(T2CConnection.java:252)

at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:531)

at oracle.jdbc.driver.T2CConnection.<init>(T2CConnection.java:148)

at oracle.jdbc.driver.T2CDriverExtension.getConnection(T2CDriverExtension.java:53)

at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:503)

at java.sql.DriverManager.getConnection(DriverManager.java:322)

at java.sql.DriverManager.getConnection(DriverManager.java:358)

at com.ibm.wca.dbconnect.DbConnectionImpl.connect(DbConnectionImpl.java:243)

at com.ibm.wca.MassLoader.MassLoad.loadDbConnection(MassLoad.java:1176)

at com.ibm.wca.MassLoader.MassLoad.execute(MassLoad.java:181)

at com.ibm.wca.MassLoader.MassLoad.<init>(MassLoad.java:114)

at com.ibm.wca.MassLoader.MassLoad.main(MassLoad.java:101)

Infocenter does provide some options to change it to a thin driver, but then I hit one error after another, and finally decided to give up and go with 32 bit version of Oracle software.

http://publib.boulder.ibm.com/infocenter/wchelp/v7r0m0/topic/com.ibm.commerce.data.doc/tasks/tml_config_massload.htm

you could also try and download a 32 bit version of Oracle client /driver, but I was not so confident of this approach as it could impact the base Oracle installation.

I abandoned this step and moved to Step 1.b

Step 1.b

I downloaded the 32 bit version of Oracle software, this time around problem started with installation of database.

I got following error from Oracle installer and found a possible explanation from this thread.

as suggested in this thread I safely ignored the errors from installer and completed the database installation.

Error: File not found orandce11.dll.dbl

https://forums.oracle.com/forums/thread.jspa?threadID=1059983&start=15&tstart=0

Once the DB installation was completed I moved on to setdbtype command and this time everything ran properly including massload.

c:\IBM\WCDE_ENT70\bin>setdbtype.bat oracle "C:\app\~\product\11.2.0\dbhome_2" wcs sys Oracle123 wcs7dev wcs7dev createdb
Make sure you review WCDE_ENT70\logs\createdb.oracle.log file to ensure there were no errors.

Step 2

After running the setdbtype command, and before publishing any stores in the new database, you need to run the resetstores command to clean the store database, this will reset the stores project to bootstrap.

Any features enabled prior to running the setdbtype command must be re-enabled, I preferred to enable following features.

enableFeature.bat -DfeatureName=foundation

enableFeature.bat -DfeatureName=management-center

enableFeature.bat -DfeatureName=store-enhancements


Prepare Oracle for WCS toolkit configuration:
Few utility SQL's which came in handy during the installation / configuration, there other ways to do this, but these scripts just worked fine for me.

CREATE USER "WCS7DEV" PROFILE "DEFAULT" IDENTIFIED BY "wcs7dev" DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK;
GRANT "CONNECT" TO "WCS7DEV";
GRANT create procedure to "WCS7DEV";
GRANT create sequence to "WCS7DEV";
GRANT create session to "WCS7DEV";
GRANT create synonym to "WCS7DEV";
GRANT create table to "WCS7DEV";
GRANT create trigger to "WCS7DEV";
GRANT create view to "WCS7DEV";
GRANT unlimited tablespace to "WCS7DEV";

Reference Links

Changing development database
http://publib.boulder.ibm.com/infocenter/wchelp/v7r0m0/topic/com.ibm.commerce.install.doc/tasks/tmgdevchgdb.htm

WebSphere commerce feature pack
http://publib.boulder.ibm.com/infocenter/wchelp/v7r0m0/topic/com.ibm.commerce.install.doc/concepts/cigfeaturepack.htm

Pituluik Media

Blogger | Freelancer |Operations Manager | Marketing and Sales Manager | Lancer Evo 4 Community. Indonesian Bloggers Who Become Bloggers Because of Hobby. Feel free to connect with me on Social Media Instagram @alberandesko

Share this post