We're here to help!

Steps required when planning to upgrade Oracle software using a new $O_H location


Read our docs The steps in this article apply when you want to upgrade your Oracle software using a new $O_H location. (Example upgrade to

When upgrade recreates Oracle Data Dictionary this article doesn't apply, because object and user IDs are overwritten during the upgrade. Setup Wizard must be re-run in such case.  

Problem Details

Problem Statement

What is the correct process to when upgrading Oracle software using a new $O_H location

Applicable Error Code


Affected Versions

2.7, 2.8

Affected Platforms




When planning to upgrade the Oracle software using a new $O_H location, make sure the following are done, eg : to

Steps Performed
1. Determine the MINE.ORACLE_HOME value using the console:
dbvrep> show oracle 
*.ORACLE_HOME = /home/u01/app/ 
MINE.ORACLE_HOME = /home/u01/app/ 
Old Home:
ORACLE_HOME /home/u01/app/oracle/product/
GRID_HOME /home/u01/app/
New Home:
ORACLE_HOME /u01/app/oracle/product/
GRID_HOME /u01/app/


2. Update -MINE.ddc file

memory_set TNS_ADMIN /u01/app/oracle/product/
memory_set ORACLE_HOME /u01/app/


3. Restart MINE process



If OPEN RESETLOGS is used, replicate will not be able to handle it and will have to reconfigure replication from scratch.

Have more questions? Submit a request