+

Search Tips   |   Advanced Search

Install and prepare Oracle or Oracle RAC

We can use Oracle or Oracle RAC with HCL WebSphere Portal.

The Oracle OCI Type-2 JDBC driver with the full oracle client works with HCL WebSphere Portal. However, for Linux, to successfully complete the database transfer task, the Oracle Thin Type-4 JDBC is required. After successfully completing the database transfer task using the thin driver, if needed, we can specify and then return to using the Oracle OCI Type-2 full client.

  1. Install Oracle JDBC Type 4 drivers or Oracle JDBC OCI Type 2 client and drivers as appropriate.

  2. Oracle RAC

    1. Ensure the Oracle CRS (Cluster Ready Service) and Oracle RAC databases are installed and configured on the primary and secondary nodes.

    2. Start global services daemon (GSD), oracle listeners, and agents in both RAC nodes.

      • $ gsdctl start
      • $ lsnrctl start
      • $ agentctl start

    3. The default table space size for Oracle RAC might need to be set to 1024 MB with autoextend turned on for database transfer to be successful.

  3. Update environment variables

  4. JDBC OCI Type 2 drivers only (AIX): Set the environment variable on the HCL WebSphere Portal server to point to the directory where we downloaded and extracted the compressed Oracle client files.

      LIBPATH=/u01/app/oracle/product/11.2.0/client_1;export LIBPATH

  5. JDBC OCI (Linux and Solaris): Set the environment variable on the HCL WebSphere Portal server to point to the directory where we downloaded and extracted the compressed Oracle client files.

      LD_LIBRARY_PATH=/u01/app/oracle/product/11.2.0/client_1;export LD_LIBRARY_PATH

  6. Restart server1 to ensure that the Configuration Wizard uses the updated environment variables.

      cd AppServer_home/profiles/cw_profile/bin
      ./stopServer.sh server1 -username username -password password
      ./startServer.sh server1


What to do next

Use the Configuration Wizard to set up and configure the database to work with HCL WebSphere Portal. Use the wizard to create custom scripts that our database administrator can use to configure the database. We can also use the wizard to automatically set up and configure the database. The wizard creates instructions and scripts that are based on your selections and provided data.

Important: To successfully complete the database transfer task, the Oracle Thin Type-4 JDBC is required for Linux . When using the wizard, you provide information about the database for the environment.

Note: Before entering the database name (dbdomain.DbName) in the Configuration Wizard, check the database documentation for restrictions on character length.

We cannot use the Database Transfer option in the configuration wizard to assign custom table spaces on the database server. We can perform manual steps to assign custom table spaces.

Parent topic: Install the database software