Upgrading dSources after an Oracle Upgrade
Delphix Administration / Oracle Environments and Data Sources / Managing Oracle, Oracle RAC, and Oracle PDB Data Sources / Upgrading dSources after an Oracle Upgrade

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 Management application.
    1. Login to the Delphix Management 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. Select the Refresh icon.
    6. In the Refresh confirmation dialog select Refresh.


  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 Datasets.
  6. Expand the group containing the dSource.
  7. Select the dSource.
  8. Click the Configuration tab.
  9. In the upper right-hand corner, from the Actions menu (...) select Upgrade 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 Management 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 edit the new user.
  6. Follow the procedure to upgrade the dSources and VDBs described in this topic.

Post-requisites

After upgrading the dSource to a new major release of Oracle (11.2.0.4 to 12.1 for example), you must re-run the createDelphixDBUser.sh script.