Websphere Portal V6.1 – Database Transfer

A set of Brief steps, included in the process of migrating the Database (DB) from the default light weight DB to Oracle XE DB.

Hi All,

For those of you who are interested in working with the Programming & Development activities, specially with Websphere Application & Portal Server, i hope this will be a useful article.

Following are the steps that are essentially required to successfully migrate the Default Derby DB (- the default Database that comes with the portal server v6.1) to any other DB (- Oracle XE DB, in the following Example)

Step1 : Installation of the Oracle DB

Step 2 : Creating the 6 Users (release, community, customization, feedback, likeminds, jcr)

( Oracle XE DB can be downloaded from http://download.oracle.com/otn/nt/oracle10g/xe/10201/OracleXEUniv.exe location. U must be logged in to download)

Step3 : Modification of the following Files, under wp_profile_root/ConfigEngine/properties Folder.
wkplc_comp.properties
wkplc_dbtype.properties
wkplc_dbtype_ascii.properties

The DB Name, Type, JDBC URL, DbScheme, etc… these information must be specified in the “wkplc_comp.properties” file

Specify the location of ojdbc14.jar file & the DBDriver, in “wkplc_dbtype.properties” file.

(ex: oracle.DbLibrary=C:/IBM/WebSphere/PortalServer/drivers/ojdbc14.jar

oracle.DbDriver=oracle.jdbc.driver.OracleDriver)

Step4 : Creating the tablespace Mapping for the 6 files (folder : wp_profile_root/PortalServer/config/tablespaces).
[This step is Optional.]

Step5 : Validate the Database Driver by executing the command
ConfigEngine.bat validate-database-driver -DTransferDomainList=release,customization,community,jcr,feedback,likeminds

Step6 : Stop All the Servers.

Step8 : Execute the command for the database transfer.
ConfigEngine.bat database-transfer -DTransferDomainList=release,customization,community,jcr,feedback,likeminds [-DuseCustomTablespaceMapping=true] (- this parameter is optional. This parameter should be added if Step 4 is performed.)

Note : More detailed description is available in the following WebPage

http://www-10.lotus.com/ldd/portalwiki.nsf/page.xsp?documentId=302B0A15D71B4AB0852575D60075E05F&action=openDocument