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 是否可以用
每天都在进步!!