wps 6 db2 数据库 to oracle数据库

    oracle 10g

     停止 was 与 wps

    sqlplus system/admin@wpsdb
    create user release identified by password default tablespace users temporary tablespace temp;
    create user community identified by password default tablespace users temporary tablespace temp;
    create user customization identified by password default tablespace users temporary tablespace temp;
    create user wmmdb identified by password default tablespace users temporary tablespace temp;
    create user likeminds identified by password default tablespace users temporary tablespace temp;
    create user feedback identified by password default tablespace users  temporary tablespace temp;
    //create user lmdbusr identified by password default tablespace users temporary tablespace temp;

 

 

    system/admin@jcrdb
   
    create user icmadmin identified by password default tablespace users temporary tablespace temp;
    create user jcr identified by password default tablespace users temporary tablespace temp;

 

   新建表空间

   在oracle jcrdb(F:\oracle\product\10.2.0\oradata\jcrdb)目录下面建立 data和 index目录

   portal_server_root/config/work/db/oracle 之下的SQL Scriptjcr_ora_tablespaces.sql 修改对应项

 

define jcrdb = JCRDB;
define logfile = F:/oracle/product/10.2.0/oradata/icmjcr.log;
define dbpath = F:/oracle/product/10.2.0/oradata;

spool &logfile;
whenever sqlerror exit sql.sqlcode rollback;
CONNECT &&dbadmin/&&password@&jcrdb .;
create tablespace ICMLFQ32 datafile '&dbpath./&jcrdb./data/&jcrdb._ICMLFQ32_01.dbf' size 300M reuse autoextend on next 10M maxsize UNLIMITED extent management local autoallocate;
create tablespace ICMLNF32 datafile '&dbpath./&jcrdb./data/&jcrdb._ICMLNF32_01.dbf' size 25M reuse autoextend on next 10M maxsize UNLIMITED extent management local autoallocate;
create tablespace ICMVFQ04 datafile '&dbpath./&jcrdb./data/&jcrdb._ICMVFQ04_01.dbf' size 25M reuse autoextend on next 10M maxsize UNLIMITED extent management local autoallocate;
create tablespace ICMSFQ04 datafile '&dbpath./&jcrdb./data/&jcrdb._ICMSFQ04_01.dbf' size 150M reuse autoextend on next 10M maxsize UNLIMITED extent management local autoallocate;
create tablespace ICMLSNDX datafile '&dbpath./&jcrdb./index/&jcrdb._ICMLSNDX_01.dbf' size 10M reuse autoextend on next 10M maxsize UNLIMITED extent management local autoallocate;
spool off;
exit;

 

 

執行SQL Script。#sqlplusSQL >@jcr_ora_tablespaces.sql  提示输入用户名:system 密码

 

授权给用户,经测试按信息中心采用单独授权给用户,我这里都将用户授权为dba,可以将数据传输成功后,可以改成不同的权限

 

sqlplus system/admin@wpsdb as sysdba;

grant dba to release ; 一次类推.

 

sqlplus system/admin@jcrdb as sysdba;

grant dba to jcr;  一次类推.

 

 

wpconfig_dbdomain.properties

 

release.DbType=oracle
release.DbName=wpsdb
release.DataSourceName=releaseDS
release.DbUrl=jdbc:oracle:thin:@YourDatabaseServer:1521:wpsdb
release.DbUser=release

release.DbPassword=ReplaceWithYourDbAdminPwd

customization.DbType=oracle
customization.DbName=wpsdb
customization.DataSourceName=customizationDS
customization.DbUrl =jdbc:oracle:thin:@YourDatabaseServer:1521:wpsdb
customization.DbUser= customization
customization.DbPassword= ReplaceWithYourDbAdminPwd

 

 

 

community.DbType=oracle
community.DbName=wpsdb
community.DataSourceName=communityDS
community.DbUrl =jdbc:oracle:thin:@YourDatabaseServer:1521:wpsdb
community.DbUser=community
community.DbPassword= ReplaceWithYourDbAdminPwd

 

 

 

jcr.DbType=oracle
jcr.DbName=jcrdb
jcr.DataSourceName=jcrDS
jcr.DbUrl =jdbc:oracle:thin:@YourDatabaseServer:1521:jcrdb
jcr.DbUser=icmadmin
jcr.DbPassword= ReplaceWithYourDbAdminPwd

 

 

 

wmm.DbType=oracle
wmm.DbName=wpsdb
wmm.DataSourceName=wmmDS
wmm.DbUrl =jdbc:oracle:thin:@YourDatabaseServer:1521:wpsdb
wmm.DbUser=wmmdb
wmm.DbPassword= ReplaceWithYourDbAdminPwd

 

 

feedback.DbType=oracle
feedback.DbName=wpsdb
feedback.DataSourceName=feedbackDS
feedback.DbUrl =jdbc:oracle:thin:@YourDatabaseServer:1521:wpsdb
feedback.DbUser= feedback
feedback.DbPassword= ReplaceWithYourDbAdminPwd

 

 

 

likeminds.DbType=oracle
likeminds.DbName=wpsdb
likeminds.DataSourceName=likemindsDS
likeminds.DbUrl =jdbc:oracle:thin:@YourDatabaseServer:1521:wpsdb
likeminds.DbUser=likeminds
likeminds.DbPassword= ReplaceWithYourDbAdminPwd

 

 

 

 

wpconfig_dbtype.properties

DbSafeMode=false
oracle.DbDriver=oracle.jdbc.driver.OracleDriver
oracle.DbLibrary=C:/jdbc/lib/ojdbc14.jar

 

 

 

wpconfig.properties

WasPassword=<ReplaceWithYourWASUserPwd>

 

 

 

wpconfig_sourceDb.properties

将对应的用户密码补上,这里主要设置db2的密码

.DbPassword=admin  //注意事项,如果是从cloudscape传送到其它库不要设置些项

 

 

验证是数据库配置是否成功

 

WPSconfig  validate-database-connection-wps -DDbPassword=password
WPSconfig validate-database-connection-jcr -DJcrDbPassword=password
WPSconfig validate-database-connection-feedback -DFeedbackDbPassword=password
WPSconfig validate-database-connection-likeminds -DLikemindsDbPassword=password
WPSconfig validate-database-connection-wmm -DWmmDbPassword=password
WPSconfig validate-database-driver

 

传送开始,时间比较久,耐心等!!!

WPSconfig.bat database-transfer -Drelease.DbPassword=password -Dcustomization.DbPassword=password -Dcommunity.DbPassword=password -Djcr.DbPassword=password -Dwmm.DbPassword=password -Dfeedback.DbPassword=password -Dlikeminds.DbPassword=password

 

发现错误,查看日志,解决问题,注意jcr这个用户,当在这个用户传送发生失败后drop user jcr  再重新建立,重新授权

 

 

sqlplus system/admin@jcrdb as sysdba

execute dbms_stats.gather_schema_stats(ownname=> 'icmadmin', cascade=> TRUE); //防止数据库反应减慢

 

传送成功后,打开wps 主页看有没有错误,查看wps wcm  是否可以用

 

 

每天都在进步!!

 

 

 

 

评论

1 楼 wufeipeng2001 2018-02-23  

这个速度快吗？我们现在有一个项目就是要上传数据，从DB2到oracle.现在用的是SPOON这个工具。