AIX clustered server: Change Oracle or Oracle RAC driver types

IBM WebSphere Portal requires the use of either Oracle JDBC Type 4 drivers or JDBC OCI Type 2 drivers when connecting to Oracle or Oracle RAC. You may need to change driver types after a migration. Direct migration from a previous installation of WebSphere Portal using JDBC Type 4 drivers to an installation using JDBC OCI Type 2 drivers is not supported. To migrate from a previous version of WebSphere Portal using JDBC Type 4 drivers, the target system must use JDBC Type 4 drivers. Once migration is complete, we can continue using JDBC Type 4 drivers or change the driver type to JDBC OCI Type 2 drivers as appropriate.

Before beginning, ensure that the following conditions are met:

• You have completed one of the following goals:

  • You have successfully transferred the data to Oracle or Oracle RAC using the database-transfer configuration task.

  • The WebSphere Portal migration has been successfully transferred to Oracle or Oracle RAC using the Type 4 JDBC driver.

• The files wkplc_dbdomain.properties and wkplc_dbtype.properties have been modified to set the correct values for the Oracle drivers that we are switching to:

  The value for service_name in the database URL is the same value used for the service name value in the tnsnames.ora file on the Oracle database.

  In the file wkplc_dbdomain.properties set each domain.DbUrl property using the following formats:

  The value for service_name in the database URL is the same value used for the service name value in the tnsnames.ora file on the Oracle database.

  Database	Format for domain.DbUrl
  Oracle (JDBC OCI Type 2)	jdbc:oracle:oci:@//YourDatabaseServer:1521/service_name
  Oracle (JDBC Type 4)	jdbc:oracle:thin:@YourDatabaseServer:1521:service_name
  Oracle RAC (JDBC OCI Type 2)	jdbc:oracle:oci:@//NODE_HOSTNAME:1521/NODE_INSTANCENAME
  Oracle RAC (JDBC Type 4)	jdbc:oracle:thin:@NODE_HOSTNAME:1521:NODE_INSTANCENAME

Prerequisites

AIX clustered server: Modify Oracle or Oracle RAC database properties

AIX clustered server: Create Oracle or Oracle RAC databases

AIX clustered server: Set up Oracle or Oracle RAC automatically or manually

AIX clustered server: Configure Portal to use Oracle or Oracle RAC

1. cd WP_PROFILE/ConfigEngine

2. Validate configuration properties...
   ./ConfigEngine.sh validate-database

3. cd WP_PROFILE/bin

4. Stop the WebSphere_Portal server:

   ./stopServer.sh WebSphere_Portal -username wpadmin -password foo

5. cd WP_PROFILE/ConfigEngine

6. To change from one supported driver to the other, run the following task to connect the database, including only the domains that require the switch.
   ./ConfigEngine.sh connect-database -Drelease.DbPassword=foo -Dcustomization.DbPassword=foo -Dcommunity.DbPassword=foo -Djcr.DbPassword=foo -Dfeedback.DbPassword=foo -Dlikeminds.DbPassword=foo -DWasPassword=foo

7. cd WP_PROFILE/bin

8. Start the WebSphere Portal server.

Parent: AIX clustered server: Set up an Oracle or Oracle RAC database
Previous: AIX clustered server: Configure Portal to use Oracle or Oracle RAC