portal 6: cloudscape to oracle migration

boris...@koncar-ket.hr

unread,

Dec 11, 2007, 8:26:08 AM12/11/07

to

I ran into problems while trying to migrate from embedded cloudscape portal database to Enterprise Oracle 10.2.0.3.0. I followed guidelines from InfoCenter (<a class="jive-link-external" href="http://publib.boulder.ibm.com/infocenter/wpdoc/v6r0/index.jsp,">http://publib.boulder.ibm.com/infocenter/wpdoc/v6r0/index.jsp,</a> under Search: "installing oracle"). 

What I did is, in short: 
 
1. Installed Oracle database software 
2. Upgraded to patch level 10.2.0.3.0 
3. Created database using AL16UTF16 
4. Created users, granted permissions 
5. Run confgiwizard.bat 
 
What happend: 
 
RELEASEUSR partially migrated but at some point java.lang.ArrayIndexOutOfBoundsException occurred (see error log below). Then I tried to increase Oracle SGA, PGA size (automatic memory management enabled) but that didn't help. Further more I noticed that some validations failed: Validation of the Character Set, Validating user roles. Should I disable automatic memory management and set memory variables to precisely those values suggested at InfoCenter. What about those validations? 
 
Boris

pescador

unread,

Dec 11, 2007, 11:33:12 AM12/11/07

to

There have been multiple problems when trying to use the Oracle 10.2.0.3 driver. Searching the Portal Support site for 10.2.0.3 will point you to this TechNote 
 
<a class="jive-link-external" href="http://www-1.ibm.com/support/docview.wss?rs=688&ca=portall2&uid=swg21257024">http://www-1.ibm.com/support/docview.wss?rs=688&ca=portall2& uid=swg21257024</a> 
 
Hope this helps

boris...@koncar-ket.hr

unread,

Dec 14, 2007, 4:48:07 AM12/14/07

to

I managed to transfer all but one of the database domains using "step by step" approach. To be precise I first run config wizard for the wmmdbusr user. Afterward I checked that everything went ok, started the portal server and made sure that it really uses the new database. Then I transferred: releaseusr, communityusr, customizationusr and wmmdbusr. Following that, I tried again to start the server - this time unsuccessfully. It just doesn't come back online. 
 
Putting that aside for the time being, when trying to transfer the content management (jcrdb, icmadmin) another exception poped out: 
 
action-generate-jcr-ddl-files-standard: 
Wed Dec 12 11:11:50 CET 2007 
<a href="http://www-128.ibm.com/developerworks/forums/">echo</a> Creating dynamic DDL files 
<a href="http://www-128.ibm.com/developerworks/forums/">mkdir</a> Created dir: C:\IBM\WEBSPH~1\PORTAL~1\jcr\config\dynamic 
<a href="http://www-128.ibm.com/developerworks/forums/">echo</a> source.jcr.Db: jdbc:db2j:wpsdb;create=true 
<a href="http://www-128.ibm.com/developerworks/forums/">echo</a> source.jcr.DbUser: db2admin 
<a href="http://www-128.ibm.com/developerworks/forums/">echo</a> FromDbLibrary: C:/oracle/product/10.2.0/db_1/jdbc/lib/ojdbc14.jar 
 
generate-dynamic-ddl-scripts-cloudscape: 
Wed Dec 12 11:11:52 CET 2007 
<a href="http://www-128.ibm.com/developerworks/forums/">java</a> Connected to CSP 
<a href="http://www-128.ibm.com/developerworks/forums/">java</a> Exception in thread "main" java.lang.ExceptionInInitializerError 
<a href="http://www-128.ibm.com/developerworks/forums/">java</a> at com.ibm.icm.da.portable.connection.ConnectionManager.logon(ConnectionManager.java:39) 
<a href="http://www-128.ibm.com/developerworks/forums/">java</a> at com.ibm.icm.test.TGenDDL.main(TGenDDL.java:162) 
<a href="http://www-128.ibm.com/developerworks/forums/">java</a> Caused by: java.util.MissingResourceException: Can't find com.ibm.icm.da.portable.i18n.messages bundle 
<a href="http://www-128.ibm.com/developerworks/forums/">java</a> at java.util.logging.Logger.setupResourceInfo(Logger.java:1340) 
<a href="http://www-128.ibm.com/developerworks/forums/">java</a> at java.util.logging.Logger.<init>(Logger.java:230) 
<a href="http://www-128.ibm.com/developerworks/forums/">java</a> at java.util.logging.Logger.getLogger(Logger.java:298) 
<a href="http://www-128.ibm.com/developerworks/forums/">java</a> at com.ibm.icm.log.LogFactory.getLog(LogFactory.java:96) 
<a href="http://www-128.ibm.com/developerworks/forums/">java</a> at com.ibm.icm.da.portable.log.LogFactory.getLog(LogFactory.java:53) 
<a href="http://www-128.ibm.com/developerworks/forums/">java</a> at com.ibm.icm.da.portable.connection.Logon.<clinit>(Logon.java:53) 
<a href="http://www-128.ibm.com/developerworks/forums/">java</a> ... 2 more 

Then I tried the transfer from the start using a 10.2.0.2. driver. Same story all over again - same exception from above. Any ideas/similar problems? 
 
Boris

pescador

unread,

Dec 14, 2007, 8:56:19 AM12/14/07

to

Looks like the action-generate-jcr-ddl-files-standard sub-task is having a problem. This sub-task wants to connect to your source db....which is CloudScape, but as you can see below your FromDbLibrary has an Oracle library path

action-generate-jcr-ddl-files-standard: 
Wed Dec 12 11:11:50 CET 2007

echo Creating dynamic DDL files 
mkdir Created dir: C:\IBM\WEBSPH~1\PORTAL~1\jcr\config\dynamic 
echo source.jcr.Db: jdbc:db2j:wpsdb;create=true 
echo source.jcr.DbUser: db2admin 
echo FromDbLibrary: C:/oracle/product/10.2.0/db_1/jdbc/lib/ojdbc14.jar 
 
This condidtion may when you attempt to transfer the domains one by one like you have done. The FromDbLibrary is pulling its value from the WebSphere\PortalServer\jcr\lib\com\ibm\icm\icmadmin.properties. Please edit this file and change the property 
 
jcr.database.type=db2 
 
to 
 
jcr.database.type=cloudscape 
 
and then re-run the transfer to move the jcr domain.