WebSphere Portal8数据库迁移至oracle

详细的配置信息+ 截图,一步一步的帮助

Linux环境下Portal8数据库迁移至oracle

1.一般步骤：设置数据库，设置门户的配置文件，运行门户迁移任务，迁移后的性能调整等

a,根据实际情况规划数据库，数据库要求的字符集是utf8，al32utf8或al16utf16 c,数据库驱动文件拷到服务器上

d, 修改门户的配置文件：

wp_profile\ConfigEngine\properties\wkplc.properties

wp_profile\ConfigEngine\properties\wkplc_dbtype.properties

wp_profile\ConfigEngine\properties\wkplc_domain.properties

wkplc.properties 需要was管理员密码

WasUserid=uid=wpsadmin,o=defaultWIMFileBasedRealm

WasPassword=password

wkplc_dbtype.properties 数据库类型，jdbc的信息

oracle.DbDriver oracle.jdbc.driver.OracleDriver

oracle.DbLibrary /opt/IBM/WebSphere/wp_profile/jdbc/oracle/ojdbc6.jar oracle.JdbcProviderName wpdbJDBC_oracle

2.非定制迁移至oracle

a.开启oracle的XA事务支持

b.设置数据库缓冲池的参数

db_block_size 8192

db_cache_size 300M

db_files 1024

log_buffer 65536

open_cursors 1500

pga_aggregate_target 200M

pre_page_sga true

processes 300

详细的配置信息+ 截图,一步一步的帮助

shared_pool_size 200M

c.创建jcr表空间目录，如：

c:/oracle/product/10.2/oradata/portaldb/data

c:/oracle/product/10.2/oradata/portaldb/index

d.备份配置文件：

wp_profile_root/ConfigEngine/properties/wkplc.properties

wp_profile_root/ConfigEngine/properties/wkplc_domain.properties

wp_profile_root/ConfigEngine/properties/wkplc_dbtype.properties

e.修改wkplc.properties,修改WasPassword和PortalAdminPwd的值为相应的密码

f.修改wkplc_dbtype.properties

属性值

oracle.DbDriver oracle.jdbc.driver.OracleDriver

oracle.DbLibrary /opt/IBM/WebSphere/wp_profile/jdbc/oracle/ojdbc6.jar oracle.JdbcProviderName wpdbJDBC_oracle

g.修改wkplc_domain.properties

属性值

feedback.DbType oracle

feedback.DbName portaldb

feedback.DbSchema feedback

feedback.DataSourceName fdDS

feedback.DbUrl jdbc:oracle:thin:@192.168.27.148:1521:portaldb feedback.DbUser feedback

feedback.DbPassword password

feedback.DBA.DbUser sys

feedback.DBA.DbPassword password

feedback.DbHome /u01/app/oracle/oradata

likeminds.DbType oracle

likeminds.DbName portaldb

likeminds.DbSchema lmdbusr

likeminds.DataSourceName lmdDS

likeminds.DbUrl jdbc:oracle:thin:@192.168.27.148:1521:portaldb

详细的配置信息+ 截图,一步一步的帮助

likeminds.DbUser lmdbusr

likeminds.DbPassword password

likeminds.DBA.DbUser sys

likeminds.DBA.DbPassword password

likeminds.DbHome /u01/app/oracle/oradata

release.DbType oracle

release.DbName portaldb

release.DbSchema releaseusr

release.DataSourceName

release.DbUrl

release.DbUser

release.DbPassword

release.DBA.DbUser

release.DBA.DbPassword

release.DbHome

community.DbType

community.DbName

community.DbSchema

community.DataSourceName

community.DbUrl

community.DbUser

community.DbPassword

community.DBA.DbUser

community.DBA.DbPassword

community.DbHome

customization.DbType

customization.DbName

customization.DbSchema

customization.DataSourceName

customization.DbUrl

customization.DbUser

customization.DbPassword

customization.DBA.DbUser

customization.DBA.DbPassword

customization.DbHome

jcr.DbType

jcr.DbName

jcr.DbSchema

jcr.DataSourceName

jcr.DbUrl relDS jdbc:oracle:thin:@192.168.27.148:1521:portaldb releaseusr password sys password /u01/app/oracle/oradata oracle portaldb communityusr commDS jdbc:oracle:thin:@192.168.27.148:1521:portaldb communityusr password sys password /u01/app/oracle/oradata oracle portaldb customizationusr custDS jdbc:oracle:thin:@192.168.27.148:1521:portaldb customizationusr password sys password /u01/app/oracle/oradata oracle portaldb jcr jrDS jdbc:oracle:thin:@192.168.27.148:1521:portaldb

详细的配置信息+ 截图,一步一步的帮助

jcr.DbUser jcr

jcr.DbPassword password

jcr.DBA.DbUser sys

jcr.DBA.DbPassword password

jcr.DbHome /u01/app/oracle/oradata

h.停掉portal，确定数据库正常，在wp_profile/ConfigEngine下运行设置数据库脚本

i.数据库的设置

ConfigEngine.bat setup-database -DWasPassword=password

j.运行数据库校验：

在命令行状态下，到wp_profile/ConfigEngine 目录下运行：

ConfigEngine.bat validate-database -DWasPassword=password

k.运行迁移脚本

在命令行状态下，到wp_profile_root\ConfigEngine 目录下运行：

ConfigEngine.bat database-transfer -DWasPassword=password

l.清理敏感信息，

如数据库管理员密码，各个域用户密码，was管理员密码等

m.设置数据库，提升性能，用sqlplus运行：

execute dbms_stats.gather_schema_stats(ownname=>'releaseusr',cascade=>TRUE);

execute dbms_stats.gather_schema_stats(ownname=>'communityusr',cascade=>TRUE); execute dbms_stats.gather_schema_stats(ownname=>'customizationusr',cascade=>TRUE); execute dbms_stats.gather_schema_stats(ownname=>'jcr',cascade=>TRUE);

execute dbms_stats.gather_schema_stats(ownname=>'feedback',cascade=>TRUE);

execute dbms_stats.gather_schema_stats(ownname=>'lmdbusr',cascade=>TRUE);

--------------------------------------------------------------------------------

注：在昨天迁移数据时，因为将 xxx.DbHome 设置成了oracle_home 所以不能找到index和data目录导致不能正常新建表空间，所以我们手动创建表空间之后正常迁移：

create tablespace ICMLFQ32 datafile '/u01/app/oracle/oradata/wpsdb/data/wpsdb_ICMLFQ32_01.dbf' size 300M reuse autoextend

详细的配置信息+ 截图,一步一步的帮助

on next 10M maxsize UNLIMITED extent management local autoallocate;

create tablespace ICMLNF32 datafile '/u01/app/oracle/oradata/wpsdb/data/wpsdb_ICMLNF32_01.dbf' size 25M reuse autoextend on next 10M maxsize UNLIMITED extent management local autoallocate;

create tablespace ICMVFQ04 datafile '/u01/app/oracle/oradata/wpsdb/data/wpsdb_ICMVFQ04_01.dbf' size 25M reuse autoextend on next 10M maxsize UNLIMITED extent management local autoallocate;

create tablespace ICMSFQ04 datafile '/u01/app/oracle/oradata/wpsdb/data/wpsdb_ICMSFQ04_01.dbf' size 150M reuse autoextend on next 10M maxsize UNLIMITED extent management local autoallocate;

create tablespace ICMLSNDX datafile '/u01/app/oracle/oradata/wpsdb/index/wpsdb_ICMLSNDX_01.dbf' size 10M reuse autoextend on next 10M maxsize UNLIMITED extent management local autoallocate;