Delphix Products

Hi Mouhssine,

Thanks for the reply.

From the DB perspective everything looks quite clear. When Delphix comes to the picture we need same clarity, that's why I have opened this thread as well as mentioned this in the Support Ticket to Delphix.

Delphix has "Upgrade vDB" option in vDB GUI but the documentation does not clarify which steps to be performed before/after Oracle binary installation (as well as ASM, grid installations in the Target systems that will be performed by DBAs).

Hi Mouhssine,

Thanks for the reply.

From the DB perspective everything looks quite clear. When Delphix comes to the picture we need same clarity, that's why I have opened this thread as well as mentioned this in the Support Ticket to Delphix.

Delphix has "Upgrade vDB" option in vDB GUI but the documentation does not clarify which steps to be performed before/after Oracle binary installation (as well as ASM, grid installations in the Target systems that will be performed by DBAs).

Hi Mouhssine,

Thanks for the reply.

From the DB perspective everything looks quite clear. When Delphix comes to the picture we need same clarity, that's why I have opened this thread as well as mentioned this in the Support Ticket to Delphix.

Delphix has "Upgrade vDB" option in vDB GUI but the documentation does not clarify which steps to be performed before/after Oracle binary installation (as well as ASM, grid installations in the Target systems that will be performed by DBAs).

Hi Mouhssine,

Thanks a lot for the steps and explanation.

Below is the steps explained in Delphix documentation:

Creating a new ORACLE_HOME

1. Refresh the environment from the Delphix Management application. Verify that the new ORACLE_HOME is picked up and displayed in the Databases tab as an ORACLE Installation.
2. Stop the VDB from the command line (old ORACLE_HOME).
3. Export ORACLE_HOME=(newORACLE_HOME). Follow Oracle documentation to patch the database.
4. Copy the init.ora for that VDB in this new $ORACLE_HOME/dbs directory. The delphix_os user will need write permissions to this directory.
5. If there are any database parameter changes, update the spfile located on the delphix mount base with those values.
6.  Navigate to the Datasets view, select the VDB and then select the Configuration tab.  
7. From the Actions menu (...) select  Upgrade to switch the ORACLE_INSTALLATION to the new one you just used and verified. 

Adding these together, it looks like all the steps should be something like below

1. [DBA] Install new ORACLE_HOME to the Target Host
2. [Delphix Admin] Take backup sapshot on vDB before upgrade from Delphix GUI
3. [Delphix Admin] Refresh the environment from Delphix GUI
4. [DBA] Backup old version of spfile
5. [DBA] Stop the VDB from the command line (old ORACLE_HOME)
6. [DBA] Export ORACLE_HOME=(newORACLE_HOME). Follow Oracle documentation to patch the database.
7. [DBA] Copy the init.ora for that VDB in this new $ORACLE_HOME/dbs directory. The delphix_os user will need write permissions to this directory.
8. [DBA] If there are any database parameter changes, update the spfile located on the delphix mount base with those values.
9. [DBA] Re-create the spfile using the new parameters recommended by Oracle for the upgrade
10. [Delphix Admin] Once the upgrade is complete, update the ORACLE_HOME in the UI, by selecting the "Upgrade" option for the upgraded VDB
11. [Delphix Admin] Set the new ORACLE_HOME for the upgraded vdb (you may need to refresh the environment first to refresh the OHs)
12. [Delphix Admin] Stop / Start VDB
13. [Delphix Admin] Take snapshot for the new upgraded VDB

Can you please check the steps?

Hi Mouhssine,

Thanks for the reply.

From the DB perspective everything looks quite clear. When Delphix comes to the picture we need same clarity, that's why I have opened this thread as well as mentioned this in the Support Ticket to Delphix.

Delphix has "Upgrade vDB" option in vDB GUI but the documentation does not clarify which steps to be performed before/after Oracle binary installation (as well as ASM, grid installations in the Target systems that will be performed by DBAs).

Hi Mouhssine,

Thanks a lot for the steps and explanation.

Below is the steps explained in Delphix documentation:

Creating a new ORACLE_HOME

1. Refresh the environment from the Delphix Management application. Verify that the new ORACLE_HOME is picked up and displayed in the Databases tab as an ORACLE Installation.
2. Stop the VDB from the command line (old ORACLE_HOME).
3. Export ORACLE_HOME=(newORACLE_HOME). Follow Oracle documentation to patch the database.
4. Copy the init.ora for that VDB in this new $ORACLE_HOME/dbs directory. The delphix_os user will need write permissions to this directory.
5. If there are any database parameter changes, update the spfile located on the delphix mount base with those values.
6.  Navigate to the Datasets view, select the VDB and then select the Configuration tab.  
7. From the Actions menu (...) select  Upgrade to switch the ORACLE_INSTALLATION to the new one you just used and verified. 

Adding these together, it looks like all the steps should be something like below

1. [DBA] Install new ORACLE_HOME to the Target Host
2. [Delphix Admin] Take backup sapshot on vDB before upgrade from Delphix GUI
3. [Delphix Admin] Refresh the environment from Delphix GUI
4. [DBA] Backup old version of spfile
5. [DBA] Stop the VDB from the command line (old ORACLE_HOME)
6. [DBA] Export ORACLE_HOME=(newORACLE_HOME). Follow Oracle documentation to patch the database.
7. [DBA] Copy the init.ora for that VDB in this new $ORACLE_HOME/dbs directory. The delphix_os user will need write permissions to this directory.
8. [DBA] If there are any database parameter changes, update the spfile located on the delphix mount base with those values.
9. [DBA] Re-create the spfile using the new parameters recommended by Oracle for the upgrade
10. [Delphix Admin] Once the upgrade is complete, update the ORACLE_HOME in the UI, by selecting the "Upgrade" option for the upgraded VDB
11. [Delphix Admin] Set the new ORACLE_HOME for the upgraded vdb (you may need to refresh the environment first to refresh the OHs)
12. [Delphix Admin] Stop / Start VDB
13. [Delphix Admin] Take snapshot for the new upgraded VDB

Can you please check the steps?

Hi Mouhssine,

Thanks for the reply.

From the DB perspective everything looks quite clear. When Delphix comes to the picture we need same clarity, that's why I have opened this thread as well as mentioned this in the Support Ticket to Delphix.

Delphix has "Upgrade vDB" option in vDB GUI but the documentation does not clarify which steps to be performed before/after Oracle binary installation (as well as ASM, grid installations in the Target systems that will be performed by DBAs).

Hi Mouhssine,

Thanks a lot for the final arrangements. This looks great!

Hi Mouhssine,

Thanks a lot for the steps and explanation.

Below is the steps explained in Delphix documentation:

Creating a new ORACLE_HOME

1. Refresh the environment from the Delphix Management application. Verify that the new ORACLE_HOME is picked up and displayed in the Databases tab as an ORACLE Installation.
2. Stop the VDB from the command line (old ORACLE_HOME).
3. Export ORACLE_HOME=(newORACLE_HOME). Follow Oracle documentation to patch the database.
4. Copy the init.ora for that VDB in this new $ORACLE_HOME/dbs directory. The delphix_os user will need write permissions to this directory.
5. If there are any database parameter changes, update the spfile located on the delphix mount base with those values.
6.  Navigate to the Datasets view, select the VDB and then select the Configuration tab.  
7. From the Actions menu (...) select  Upgrade to switch the ORACLE_INSTALLATION to the new one you just used and verified. 

Adding these together, it looks like all the steps should be something like below

1. [DBA] Install new ORACLE_HOME to the Target Host
2. [Delphix Admin] Take backup sapshot on vDB before upgrade from Delphix GUI
3. [Delphix Admin] Refresh the environment from Delphix GUI
4. [DBA] Backup old version of spfile
5. [DBA] Stop the VDB from the command line (old ORACLE_HOME)
6. [DBA] Export ORACLE_HOME=(newORACLE_HOME). Follow Oracle documentation to patch the database.
7. [DBA] Copy the init.ora for that VDB in this new $ORACLE_HOME/dbs directory. The delphix_os user will need write permissions to this directory.
8. [DBA] If there are any database parameter changes, update the spfile located on the delphix mount base with those values.
9. [DBA] Re-create the spfile using the new parameters recommended by Oracle for the upgrade
10. [Delphix Admin] Once the upgrade is complete, update the ORACLE_HOME in the UI, by selecting the "Upgrade" option for the upgraded VDB
11. [Delphix Admin] Set the new ORACLE_HOME for the upgraded vdb (you may need to refresh the environment first to refresh the OHs)
12. [Delphix Admin] Stop / Start VDB
13. [Delphix Admin] Take snapshot for the new upgraded VDB

Can you please check the steps?

Hi Mouhssine,

Thanks for the reply.

From the DB perspective everything looks quite clear. When Delphix comes to the picture we need same clarity, that's why I have opened this thread as well as mentioned this in the Support Ticket to Delphix.

Delphix has "Upgrade vDB" option in vDB GUI but the documentation does not clarify which steps to be performed before/after Oracle binary installation (as well as ASM, grid installations in the Target systems that will be performed by DBAs).