Archive

Posts Tagged ‘option’

enable, disable options in 11.2

Starting with 11.2 the installation procedure changed.
There is no more custom installation – all options will be installed.

To check which options are active run
select * from v$option order by parameter;

Stop all instances using this ORACLE_HOME !

cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk part_on ioracle

SQL>  select * from v$option where upper(parameter) like ‘%PARTI%’;
PARAMETER                                        VALUE
—————————————- —————————————————————-
Partitioning                                           TRUE

make -f ins_rdbms.mk part_off ioracle

SQL>  select * from v$option where upper(parameter) like ‘%PARTI%’;
PARAMETER                                        VALUE
—————————————- —————————————————————-
Partitioning                                           FALSE

These options can be disabled or enabled

                             Enable      Disable
Partitioning                  part_on     part_off
Datamining                    dm_on       dm_off
OLAP                          olap_on     olap_off
Data Vault                    dv_on       dv_off
Real Application Testing      rat_on      rat_off
to disable ALL those options:
make -f ins_rdbms.mk part_off dm_off olap_off dv_off rat_off ioracle

Is it possible to deinstall/remove a specific component from already installed Oracle Database Home using OUI? (Doc ID 888934.1)

Categories: installation Tags: , ,