This topic describes how to upgrade dSources after an Oracle database upgrade.

Prerequisites

Do not suspend LogSync on the Delphix Engine during an Oracle upgrade of the source environment. LogSync will detect the Oracle version change. It will then notify you to refresh the host and use the Update icon on the configuration tab for all the associated dSources and VDBs (see below). Follow all Oracle instructions and documentation.

Procedure

There are 2 ways to apply a PSU (Patch Set Update)/Oracle upgrade:

  • Apply to existing ORACLE_HOME. Best if on Delphix v4.1.x or higher.
  • Create new ORACLE_HOME (or clone an existing one) and then apply the PSU to the new ORACLE_HOME

Applying to an existing ORACLE_HOME

  1. Following Oracle documentation, patch the ORACLE_HOME and the database.
  2. Refresh the environment in the GUI.

Creating a new ORACLE_HOME

  1. Refresh the environment from the Delphix GUI.
    1. Login to the Delphix Admin application with Delphix Admin credentials.
    2. Click Manage.
    3. Select Environments.
    4. In the Environments panel, click the name of the environment you want to refresh.
    5. Click the Refresh icon below the environment's information.
    6.  Alternatively, to refresh all environments, click the Refresh icon next to the word Environments in the upper left-hand corner 

      Environments Refresh Icon

  2. In the Databases tab, verify that the new ORACLE_HOME appears as an ORACLE Installation.
  3. Following Oracle documentation, patch the production database etc.
  4. Click Manage.
  5. Select My Datasets.
  6. Expand the group containing the dSource.
  7. Select the dSource.
  8. Click the Configuration tab.
  9. In the upper right-hand corner, click the Upgrade icon to switch the ORACLE_INSTALLATION to the new one.

Updating the Oracle User after an Upgrade

There may be cases when you upgrade the Oracle home and the Oracle User (the OS user who owns the Oracle binary) is a different user than the previous Oracle User. You will then need to update the Oracle User for each environment, and then re-connect each dSource and VDB to the upgraded Oracle home using the new Oracle User.

The new Oracle User must be in the same OS group (for example, dba or oinstall) as the previous one.

  1. Log into the Delphix Admin application using delphix_admin credentials.
  2. Click Manage.
  3. Select Environments.
  4. Select the environment where you want to add the user.
  5. Next to Environment Users, click the Pencil icon to add the new user.
  6. Set the new user as the default user.
  7. Follow the procedure to upgrade the dSources and VDBs described in this topic.