292 IBM Workplace Collaboration Services: Release 2.5 Deployment Guide
12.You are now ready to transfer the Portal data to the Oracle database.
13.Finally, make sure that the Configuration Wizard successfully transferred the
Portal data.
5.4.5 Transferring Workplace data to Oracle
Now, you need to transfer the Workplace data to the Oracle database server.
Perform the following steps:
1. Stop WebSphere Portal:
/opt/IBM/Workplace/AppServer/bin/stopServer.sh WebSphere_Portal
2. Stop server1:
/opt/IBM/Workplace/AppServer/bin/stopServer.sh server1
3. Stop the Cloudscape server:
/opt/IBM/Workplace/PortalServer/rootscripts/subtasks/stopNetworkServer.sh
4. Select your language.
5. Select IBM Workplace Database Transfer as the configuration type.
6. Select 3 - Oracle Enterprise Edition.
7. Enter the values shown in Table 5-5.
Table 5-5 Oracle database connection settings
Important: You need to specify OCI as the Oracle driver type in the
LWPDBUrl.
Field Value
LWPDBDriver oracle.jdbc.driver.OracleDriver
LWPDbLibrary /opt/oracle/product/9ir2/jdbc/lib/classes12.zip
LWPDBName wps50
LWPDBUrl jdbc:oracle:oci:@ts-db.cam.itso.ibm.com:1521:wps50
LWPDBAdmin User This is the user you specified in 5.4.3, “Setting up the
Oracle database” on page 288, step 11.
In our case, it is SYSTEM.
LWPDBAdmin Password Enter the password for the user.
LWPDBAppUser This is the user you specified in 5.4.3, “Setting up the
Oracle database” on page 288, step 12.
In our case, it is SYSTEM.
Chapter 5. Installing Workplace Collaboration Services on Linux using console mode 293
8. You are now ready to transfer the Workplace data to the Oracle database.
9. After finishing these steps, make sure that the wizard successfully transferred
the Workplace data.
10.Now, you update the access rights for the Portal database IDs. This step has
to be done on the Oracle server using SQLPlus:
grant ALTER on EJB.BRBeans_Rule to PZNADMIN;
grant DELETE on EJB.BRBeans_Rule to PZNADMIN;
grant INSERT on EJB.BRBeans_Rule to PZNADMIN;
grant SELECT on EJB.BRBeans_Rule to PZNADMIN;
grant UPDATE on EJB.BRBeans_Rule to PZNADMIN;
grant ALTER on EJB.BRBeans_RuleFolder to PZNADMIN;
grant DELETE on EJB.BRBeans_RuleFolder to PZNADMIN;
grant INSERT on EJB.BRBeans_RuleFolder to PZNADMIN;
grant SELECT on EJB.BRBeans_RuleFolder to PZNADMIN;
grant UPDATE on EJB.BRBeans_RuleFolder to PZNADMIN;
conn sys/<password>@<connect string> as sysdba;
grant SELECT on DBA_PENDING_TRANSACTIONS to PUBLIC;
Return to the Workplace Collaboration Services server and perform the following
actions:
1. Stop WebSphere_Portal:
/opt/IBM/Workplace/AppServer/bin/stopServer.sh WebSphere_Portal
2. Delete all files and subdirectories in
/opt/IBM/Workplace/AppServer/TRANLOG.
Now, check if the transfer is successful by starting Workplace Collaboration
Services and logging in to the system:
/opt/IBM/Workplace/AppServer/bin/startServer.sh WebSphere_Portal
/opt/IBM/Workplace/AppServer/bin/startServer.sh Mail_Server_1
http://servername:9081/lwp/workplace
LWPDBApp Password Enter the password for the user.
BackEndId ORACLE_V9_1
(Although you are using Oracle 9.2, this setting refers to
Oracle 9.1.)
Field Value

Get IBM Workplace Collaboration Services: Release 2.5 Deployment Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.