WebSphere Commerce 7 | SetDBType is failing | Issues Faced & Resolution | No data found in OOB Tables

After WebSphere Commerce Installation, we have migrated from Cloudscape to Oracle Database. After running "setdbtype" command with "createdb" option for the Oracle Database Schema, we have noticed SITE Table is not updated with the feature pack details and it was totally empty. And also, we have noticed most of the OOB tables hasn't populated (Tables are there, but data is not available in that). After running "updatedb" command also, we have the same result.

SETDBTYPE Command with CREATEDB Option,
setdbtype oracle C:\oracle\product\11.2.0\dbhome_1 orcl system Passw0rd wcsb2bdev Passw0rd localhost 1521 createdb

Later, we could able to notice the following error in messages log,
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.\
.............
.............

As part of the resolution, we have download "ocijdbc11.dll" of Windows 32 and replaced it with one in the oracle folder "C:\oracle\product\11.2.0\dbhome_1\BIN". After we ran the process again and it started working fine as expected.