Oracle database upgrade effect on Oracle Intelligent Policies
Upgrade of an Oracle database causes instance information for the upgraded database to become invalid. If this instance is associated with one or more current NetBackup for Oracle Intelligent Policies, run-time failures can occur. The issue occurs when an Oracle database is upgraded to a new version. The new version is likely to have a different ORACLE_HOME, ORACLE_SID, or Oracle User. If any of these values have changed, the existing instance information in the NetBackup instance repository and in the current Oracle Intelligent Policies becomes invalid. When the discovery service (nbdisco) polls the clients again, it discovers the database as a new instance. Consequently, there is no way to associate the new instance to the old instance.
This issue is not version-specific and can affect any valid Oracle upgrade patch, such as:
Oracle 10 to version 11
Oracle 10 to version 12
Oracle 11 to version 12
For more information on valid Oracle upgrade paths, review the following documentation on the Oracle Support website:
http://www.oracle.com/technetwork/database/upgrade/upgrading-oracle-database-wp-12c-1896123.pdf
Therefore, when an existing Oracle database is upgraded and the ORACLE_HOME, ORACLE_SID, or Oracle User are modified, remove the existing instance in the instance repository. After the existing instance is removed, update the instance repository with the new instance information. Make sure to update any policies with the newly-discovered instances.
More Information