OraFAQ Forum: Server Administration » disabling extra money database options in 26ai

Home » RDBMS Server » Server Administration » disabling extra money database options in 26ai

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

disabling extra money database options in 26ai [message #690463]

Fri, 06 March 2026 10:58

Olexandr Siroklyn
Messages: 45
Registered: September 2018
Location: USA

Member

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

Result

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

[Updated on: Fri, 06 March 2026 11:09]

Report message to a moderator

Previous Topic:

Faster apply of an RU

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 06 23:34:42 CDT 2026