DatabaseTransfer - cws-khuntly/WebSphere GitHub Wiki

date: 2025-05-08 14:11:05 created: 2025-05-08 14:10:57 categories:

  • WebSphere / Server Build / Portal Server / Primary Node

Database Transfer

Login to the Portal host via SSH

Export the profile name variable:

declare -x PROFILE_NAME=XXX

Source setupCmdLine.sh:

source /opt/IBM/WebSphere/profiles/${PROFILE_NAME}/bin/setupCmdLine.sh

Export the WAS_INSTALL_ROOT variable:

declare -x WAS_INSTALL_ROOT="/opt/IBM/WebSphere/AppServer"

Export the environment variable:

declare -x ENV=XXX

Export the deployment manager variable:

declare -x DMGR_HOSTNAME=XXX

NOTE: This document assumes an Oracle database environment.

Create a working copy of the workplace database domain property file:

cp /nfs/software/WebSphere/PortalServer/properties/wkplc_dbdomain.properties ${HOME}/workspace/WebSphere/PortalServer/properties/${ENV}/ConfigEngine/wkplc_dbdomain.properties

Update the workplace database domain property file, modifying the following values:

 - Feedback database:

  - Name: feedback.DbName

   - Current value: ReplaceWithYourDatabaseName

   - New value: feedback

  - Name: feedback.DbUrl

   - Current value: jdbc:oracle:thin:@ReplaceWithDatabaseHostFQDN:ReplaceWithDatabasePort:ReplaceWithDatabaseName

  - Name: feedback.DbPassword

   - Current value: ReplaceWithYourPassword

   - New value: See PAM

  - Name: feedback.DBA.DbPassword

   - Current value: ReplaceWithYourPassword

   - New value: See PAM

  - Name: feedback.DbRuntimePassword

   - Current value: ReplaceWithYourPassword

   - New value: See PAM

 - Likeminds database:

  - Name: likeminds.DbName

   - Current value: ReplaceWithYourDatabaseName

   - New value: likeminds

  - Name: likeminds.DbUrl

   - Current value: jdbc:oracle:thin:@ReplaceWithDatabaseHostFQDN:ReplaceWithDatabasePort:ReplaceWithDatabaseName

  - Name: likeminds.DbPassword

   - Current value: ReplaceWithYourPassword

   - New value: See PAM

  - Name: likeminds.DBA.DbPassword

   - Current value: ReplaceWithYourPassword

   - New value: See PAM

  - Name: likeminds.DbRuntimePassword

   - Current value: ReplaceWithYourPassword

   - New value: See PAM

 - Release database:

  - Name: release.DbName

   - Current value: ReplaceWithYourDatabaseName

   - New value: release

  - Name: release.DbUrl

   - Current value: jdbc:oracle:thin:@ReplaceWithDatabaseHostFQDN:ReplaceWithDatabasePort:ReplaceWithDatabaseName

  - Name: release.DbPassword

   - Current value: ReplaceWithYourPassword

   - New value: See PAM

  - Name: release.DBA.DbPassword

   - Current value: ReplaceWithYourPassword

   - New value: See PAM

  - Name: release.DbRuntimePassword

   - Current value: ReplaceWithYourPassword

   - New value: See PAM

 - Community database:

  - Name: community.DbName

   - Current value: ReplaceWithYourDatabaseName

   - New value: community

  - Name: community.DbUrl

   - Current value: jdbc:oracle:thin:@ReplaceWithDatabaseHostFQDN:ReplaceWithDatabasePort:ReplaceWithDatabaseName

  - Name: community.DbPassword

   - Current value: ReplaceWithYourPassword

   - New value: See PAM

  - Name: community.DBA.DbPassword

   - Current value: ReplaceWithYourPassword

   - New value: See PAM

  - Name: community.DbRuntimePassword

   - Current value: ReplaceWithYourPassword

   - New value: See PAM

 - Customization database:

  - Name: customization.DbName

   - Current value: ReplaceWithYourDatabaseName

   - New value: customization

  - Name: customization.DbUrl

   - Current value: jdbc:oracle:thin:@ReplaceWithDatabaseHostFQDN:ReplaceWithDatabasePort:ReplaceWithDatabaseName

  - Name: customization.DbPassword

   - Current value: ReplaceWithYourPassword

   - New value: See PAM

  - Name: customization.DBA.DbPassword

   - Current value: ReplaceWithYourPassword

   - New value: See PAM

  - Name: customization.DbRuntimePassword

   - Current value: ReplaceWithYourPassword

   - New value: See PAM

 - JCR database:

  - Name: jcr.DbName

   - Current value: ReplaceWithYourDatabaseName

   - New value: jcr

  - Name: jcr.DbUrl

   - Current value: jdbc:oracle:thin:@ReplaceWithDatabaseHostFQDN:ReplaceWithDatabasePort:ReplaceWithDatabaseName

  - Name: jcr.DbPassword

   - Current value: ReplaceWithYourPassword

   - New value: See PAM

  - Name: jcr.DBA.DbPassword

   - Current value: ReplaceWithYourPassword

   - New value: See PAM

  - Name: jcr.DbRuntimePassword

   - Current value: ReplaceWithYourPassword

   - New value: See PAM

Set file security:

chmod 600 ${HOME}/workspace/WebSphere/PortalServer/properties/${ENV}/ConfigEngine/wkplc_dbdomain.properties

Copy the working workplace database domain property file into the Portal profile ConfigEngine:

cp ${HOME}/workspace/WebSphere/PortalServer/properties/${ENV}/ConfigEngine/wkplc_dbdomain.properties ${USER_INSTALL_ROOT}/ConfigEngine/properties/wkplc_dbdomain.properties

Copy the working workplace database type property file into the Portal profile ConfigEngine:

cp /nfs/software/WebSphere/PortalServer/properties/ConfigEngine/wkplc_dbtype.properties ${USER_INSTALL_ROOT}/ConfigEngine/properties/wkplc_dbtype.properties

Begin the transfer process:

${USER_INSTALL_ROOT}/ConfigEngine/ConfigEngine.sh validate-database validate-database-environment

${USER_INSTALL_ROOT}/ConfigEngine/ConfigEngine.sh backup-property-files-for-dbxfer

${USER_INSTALL_ROOT}/ConfigEngine/ConfigEngine.sh stop-portal-server

${USER_INSTALL_ROOT}/ConfigEngine/ConfigEngine.sh \

    -DTransferDomainList=feedback,likeminds,release,community,customization,jcr \

    database-transfer enable-profiles-check-managed package-profiles

${USER_INSTALL_ROOT}/ConfigEngine/ConfigEngine.sh grant-runtime-db-user-privileges

${USER_INSTALL_ROOT}/ConfigEngine/ConfigEngine.sh datasource-enable-fully-materialize-lob-data

Synchronize and restart the node:

${USER_INSTALL_ROOT}/bin/syncNode.sh ${DMGR_HOSTNAME} 8879 -restart

Start the Portal server:

${USER_INSTALL_ROOT}/ConfigEngine/ConfigEngine.sh start-portal-server

[Install SQL*Plus](onenote:Oracle%20SQLPlus%20Installation.one#Install SQL*Plus Client&section-id={5DD1E567-AA9A-452F-BC51-91A951AD5DCD}&page-id={31ABC535-05DD-4A99-8EC9-0243F4F930B4}&end&base-path=https://d.docs.live.net/695f42c59c29bbc9/Documents/WebSphere/Documentation/WebSphere/WebSphere)

[Configure the tnsnames.ora file for SQL*Plus](onenote:Oracle%20SQLPlus%20Installation.one#Create tnsnames.ora&section-id={5DD1E567-AA9A-452F-BC51-91A951AD5DCD}&page-id={44ACC849-D3D7-4198-9C19-EBD9BFCCC89C}&end&base-path=https://d.docs.live.net/695F42C59C29BBC9/Documents/WebSphere/Documentation/WebSphere/WebSphere)

Once the database transfer process is complete, execute the following:

sqlplus jcrusr/jcrpassword@${DATABASE_HOST_NAME}:${DATABASE_HOST_PORT}/${DATABASE_SCHEMA_NAME}

EXEC DBMS_STATS.GATHER_SCHEMA_STATS(ownname=> 'JCRUSR', cascade=> TRUE);

COMMIT;

⚠️ **GitHub.com Fallback** ⚠️