IBM Workplace Collaboration Services: Release 2.5 Deployment Guide

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