Create new Websphere Commerce Database schema using developer machine

Steps to follow

1. Create a user (schema) with DBA privileges in oracle 11g.
2. Go to command prompt where WCS Installed
Ex: D:\WCDE_ENT70\bin>
3. Prepare setdbtype.bat statement.
Ex: setdbtype oracle D:\app\testuser\product\11.2.0\client_1 UATDB wcs7 wcs7 wcs7 wcs7 192.168.140.2 1521 createdb

4. Execute the setdbtype.bat file as mentioned above.


5. setdbtype.bat command will open one more window


6. Verify the createdb.oracle.log file.
7. WCS schema created.