The Oracle 26ai EE on-premises GUI installation process does not allow you to opt out of choosing Spatial, Label Security, etc. Therefore, the following components are available right after a fresh, non-RAC installation:
SCHEMA COMP_ID VERSION STATUS COMP_NAME
-------------- --------- ------------------------------ ------------ ----------------------------------------
SYS APS 23.0.0.0.0 VALID OLAP Analytic Workspace
SYS CATALOG 23.0.0.0.0 VALID Oracle Database Catalog Views
SYS CATJAVA 23.0.0.0.0 VALID Oracle Database Java Packages
SYS CATPROC 23.0.0.0.0 VALID Oracle Database Packages and Types
CTXSYS CONTEXT 23.0.0.0.0 VALID Oracle Text
DVSYS DV 23.0.0.0.0 VALID Oracle Database Vault
SYS JAVAVM 23.0.0.0.0 VALID JServer JAVA Virtual Machine
LBACSYS OLS 23.0.0.0.0 VALID Oracle Label Security
WMSYS OWM 23.0.0.0.0 VALID Oracle Workspace Manager
SYS RAC 23.0.0.0.0 OPTION OFF Oracle Real Application Clusters
MDSYS SDO 23.0.0.0.0 VALID Spatial
XDB XDB 23.0.0.0.0 VALID Oracle XML Database
SYS XML 23.0.0.0.0 VALID Oracle XDK
OLAPSYS XOQ 23.0.0.0.0 VALID Oracle OLAP API
If you have a reliable source stating that having Spatial, Database Vault, OLAP and Label Security in your database is not a licence violation, even if you did not pay for them, that’s good. If you don’t have such a source see below how to de-install them. Have a note, a chopt utility has only options to disable Real Application Testing and Partitioning.
OLAP
# cd $ORACLE_HOME/rdbms/lib
# make -f ins_rdbms.mk olap_off
# make -f $ORACLE_HOME/rdbms/lib/ins_rdbms.mk ioracle ORACLE_HOME=$ORACLE_HOME
Here you create your database from scratch
Database Vault
sqlplus "/as sysdba"
sql> startup upgrade
sql> @$ORACLE_HOME/rdbms/admin/dvremov.sql
sql> @utlrp.sql
Label Security
sqlplus "/as sysdba"
sql> startup upgrade
sql> @catnools.sql << You should take this file from Oracle 12g
sql> @utlrp.sql
Spatial and Graph
sqlplus "/as sysdba"
sql> startup upgrade
sql> @$ORACLE_HOME/md/admin/mddins.sql
sql> @utlrp.sql
Results
SCHEMA COMP_ID VERSION STATUS COMP_NAME
-------------- --------- ------------------------------ ------------ ----------------------------------------
SYS APS 23.0.0.0.0 OPTION OFF OLAP Analytic Workspace
SYS CATALOG 23.0.0.0.0 VALID Oracle Database Catalog Views
SYS CATJAVA 23.0.0.0.0 VALID Oracle Database Java Packages
SYS CATPROC 23.0.0.0.0 VALID Oracle Database Packages and Types
CTXSYS CONTEXT 23.0.0.0.0 VALID Oracle Text
SYS JAVAVM 23.0.0.0.0 VALID JServer JAVA Virtual Machine
WMSYS OWM 23.0.0.0.0 VALID Oracle Workspace Manager
SYS RAC 23.0.0.0.0 OPTION OFF Oracle Real Application Clusters
XDB XDB 23.0.0.0.0 VALID Oracle XML Database
SYS XML 23.0.0.0.0 VALID Oracle XDK
OLAPSYS XOQ 23.0.0.0.0 OPTION OFF Oracle OLAP API