How to disable OLAP option in Oracle
To Disable Online Analytical Process (OLAP) option in Oracle.
Step 1)Database version 11g Release 2 and newer col parameter format a15 col value format a15 select * from v$option where parameter='OLAP'; SQL> col parameter format a15 col value format a15 select * from v$option where parameter='OLAP'; SQL> SQL> PARAMETER VALUE CON_ID --------------- --------------- ---------- OLAP TRUE 0 Step 2) stop all DB services Connect to root . oraenv +ASM $crsctl stop has step 3) $ chopt disable olap
For example o/p looks like this Writing to
$ORACLE_HOME/install/disable_olap_2022-08-26_19-23-58PM.log... /usr/bin/make -f
/u01/app/oracle/product/19.0.0/dbhome_1/rdbms/lib/ins_rdbms.mk
olap_off ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1 /usr/bin/make -f
/u01/app/oracle/product/19.0.0/dbhome_1/rdbms/lib/ins_rdbms.mk
ioracle ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1 b0d0euq2:oracle:CHKQIAM11 Step 4) start database services coonect to root . oraenv +ASM $crsctl start has
rollback plan
Step 1 ) Stop all the DB services coonect to root . oraenv +ASM $crsctl stop has Step 2)In order to enable OLAP you only need to run the following command:I $ chopt enable olap SQL> col parameter format a15 col value format a15 select * from v$option where parameter='OLAP'; SQL> SQL> PARAMETER VALUE CON_ID --------------- --------------- ---------- OLAP TRUE 0 Step 3) start all the DB services coonect to root $. oraenv +ASM $crsctl start has
See Also: