What happens to components with OPTION OFF status during upgrade?

What happens to components with OPTION OFF status during upgrade?In the newer releases of Oracle database you may see components with status OPTION OFF in the database’s registry. But what happens to components with OPTION OFF status during upgrade? Will those stay on the old release?

What happens to components with OPTION OFF status during upgrade?

You may have a quick look into your DBA_REGISTRY (or CDB_REGISTRY). I used the check_components.sql script.

COMP_ID	COMP_NAME			   SCHEMA	STATUS	   VERSION
-------- ---------------------------------- ------------ ---------- ------------
CATALOG	Oracle Database Catalog Views	   SYS		VALID	   12.1.0.2.0
CATJAVA	Oracle Database Java Packages	   SYS		VALID	   12.1.0.2.0
CATPROC	Oracle Database Packages and Types SYS		VALID	   12.1.0.2.0
JAVAVM	JServer JAVA Virtual Machine	   SYS		VALID	   12.1.0.2.0
OLS	Oracle Label Security		   LBACSYS	VALID	   12.1.0.2.0
OWM	Oracle Workspace Manager	   WMSYS	VALID	   12.1.0.2.0
RAC	Oracle Real Application Clusters   SYS		OPTION OFF 12.1.0.2.0
XDB	Oracle XML Database		   XDB		VALID	   12.1.0.2.0
XML	Oracle XDK			   SYS		VALID	   12.1.0.2.0

You see that the RAC component has the status OPTION OFF. Its version is 12.1.0.2.

Component version after an upgrade

After you completed a database upgrade the component status is still OPTION OFF – but the version number has changed:

COMP_ID	COMP_NAME			   SCHEMA	STATUS	   VERSION
-------- ---------------------------------- ------------ ---------- ------------
CATALOG	Oracle Database Catalog Views	   SYS		VALID	   12.2.0.1.0
CATJAVA	Oracle Database Java Packages	   SYS		VALID	   12.2.0.1.0
CATPROC	Oracle Database Packages and Types SYS		VALID	   12.2.0.1.0
JAVAVM	JServer JAVA Virtual Machine	   SYS		VALID	   12.2.0.1.0
OLS	Oracle Label Security		   LBACSYS	VALID	   12.2.0.1.0
OWM	Oracle Workspace Manager	   WMSYS	VALID	   12.2.0.1.0
RAC	Oracle Real Application Clusters   SYS		OPTION OFF 12.2.0.1.0
XDB	Oracle XML Database		   XDB		VALID	   12.2.0.1.0
XML	Oracle XDK			   SYS		VALID	   12.2.0.1.0

As a result the RAC component has been upgraded – even though the component has an OPTION OFF status. Every installed component with OPTION OFF will be upgraded.

Hence for clarification we will add a sentence to the documentation:

Components supported for upgrades to the target release but have a status of OPTION OFF prior to the upgrade – they will still get upgraded. After the upgrade, these version #s will be updated but status will remain OPTION OFF.

–Mike

Share this: