Windows stand-alone: Change Oracle or Oracle RAC driver types

IBM WebSphere Portal requires the use of either 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. 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. 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.

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:

  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

1. To validate configuration properties.
   cd WP_PROFILE\ConfigEngine
   ConfigEngine.bat validate-database

2. From the same command prompt as the previous steps, change to the directory WP_PROFILE\bin.

3. Stop the WebSphere_Portal server:
   stopServer.bat WebSphere_Portal -username wpadmin -password foo

4. 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.
   cd WP_PROFILE/ConfigEngine
   ConfigEngine.bat connect-database -Drelease.DbPassword=foo -Dcustomization.DbPassword=foo -Dcommunity.DbPassword=foo -Djcr.DbPassword=foo -Dfeedback.DbPassword=foo -Dlikeminds.DbPassword=foo -DWasPassword=foo

5. Change to the directory WP_PROFILE\bin.

6. Start the WebSphere Portal server.

Parent: Windows stand-alone: Set up a remote Oracle or Oracle RAC database