SQL> 2: Clean OLAP-Related Objects ( OLAP AW component) : Step 1: Remove the XOQ component: SQL> connect / as sysdba Note: In my case, my Oracle database is an Enterprise Edition database that was created as a General Purpose, Transaction Processing, or Custom database without OLAP, then I am going to remove this component: To remove it, then just execute the catnoamd.sql script before or after upgrade.
REMOVE OWM ORACLE WORKSPACE MANAGER ORACLE UPGRADE
After upgrade from 11.2.0.4, this component is already exist with the status OPTION OFF. This component is desupported with Oracle database 12c. Dealing with Oracle database components: 2.1. The component registry tracks components that can be separately loaded into the Oracle Database. Note: DBA_REGISTRY displays information about all components in the database that are loaded into the component registry. You cannot uninstall Oracle XML DB, and there is no option to exclude it when you create an Oracle database. Note: Starting with Oracle Database 12 c, Oracle XML DB is a mandatory component of Oracle Database.
Overview of Oracle components and their status.Īfter upgrade to 12.1.0.2, the Oracle database components Oracle Multimedia (ORDIM), JServer java VM (JAVAVM), Oracle database Java (CATJAV) and Oracle OLAP API (XOQ) have the status INVALID and also the component OLAP Catalog has the status OPTION OFF. Oracle Enterprise Manager (EM) component 1. Oracle database Java & JServer Java VM components:Ģ.5. Dealing with Oracle database components:Ģ.1. Overview of Oracle components and their status.Ģ. This article deals with INVALID, OPTION OFF status of Oracle database components AMD, ORDIM, JAVAVM, CATJAVA and XOQ after upgrade to 12c using a full RMAN backup.
0 kommentar(er)
