• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer navigation

The Geek Diary

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • VCS
  • Interview Questions
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • MariaDB
  • DevOps
    • Docker
    • Shell Scripting
  • Big Data
    • Hadoop
    • Cloudera
    • Hortonworks HDP

How To Disable Advanced Analytics in Oracle Database 12c?

by admin

The Ask

The Advanced Analytics is eanbled on the oracle database 12c as shown below.

SQL> select * from v$option where PARAMETER like '%Advanced Analytics%';

PARAMETER                                VALUE                CON_ID
---------------------------------------- -------------------- ----------
Advanced Analytics                       TRUE                 0

User wants to disable this option from database.

The Solution

In Oracle 12c, Oracle Advanced Analytics is a combination of Oracle Data Mining and Oracle R Enterprise.

Verify Oracle Data Mining and Oracle R installed in your database

A. Verify Data Mining option is installed in your database

SQL> select * from v$option where PARAMETER like '%Data Mining%'

PARAMETER VALUE CON_ID
-------------------- -------------------- ----------
Data Mining TRUE 0

B. Verify Oracle R is installed in your database

To verify R installation, just run R in command line. This command will open R command prompt

$ R
Oracle Distribution of R version [Oracle R Version]

...(output truncated)

> q()
Save workspace image? [y/n/c]: n

Another method to check if R is installed is to check its version using the below command.

$ R --version
Oracle Distribution of R version 3.3.0 (--) -- "Supposedly Educational"
Copyright (C) The R Foundation for Statistical Computing
Platform: x86_64-pc-linux-gnu (64-bit)

R is free software and comes with ABSOLUTELY NO WARRANTY.
You are welcome to redistribute it under the terms of the
GNU General Public License versions 2 or 3.
For more information about these matters see
http://www.gnu.org/licenses/.

Disable Oracle Data Mining and Oracle R from database

A. Disable oracle Data Mining option

Steps for RAC Database :

$ cd $ORACLE_HOME/bin
$ srvctl stop database -d [SID]
$ chopt disable dm
$ srvctl start database -d [SID]

Steps for non-RAC Database:

$ cd $ORACLE_HOME/bin
$ sqlplus / as sysdba
sql> shut immediate;
sql> exit
$ chopt disable dm
$ sqlplus / as sysdba
sql> startup;

B. Uninstall Oracle R

A full uninstall removes the rqsys metadata and PL/SQL code from the database and removes all Oracle R Enterprise Server libraries and R packages from Oracle home.

./server.sh --uninstall --full
./server.sh -u -full

Verification

Use the below query to verify that the Advanced Analytics is disabled from the Oracle Database 12c:

SQL> select * from v$option where PARAMETER like '%Advanced Analytics%';

PARAMETER                                VALUE                CON_ID
---------------------------------------- -------------------- ----------
Advanced Analytics                       FALSE                0

Filed Under: oracle, oracle 12c

Some more articles you might also be interested in …

  1. Beginners Guide to Oracle Temporary Tablespace Groups
  2. Oracle Dataguard 12c: How to perform Switchover using DGMGRL
  3. How to Perform Manual Archiving in Oracle Database
  4. How to get datafile information when PDB is Mounted/Read-Write/Restricted Mode
  5. How to Connect without password on Command line when using EZCONNECT
  6. oracleasm Command Examples (Cheat Sheet)
  7. Auto Space Management for Flashback Logs in the Fast Recovery Area – Oracle 19c New Feature
  8. SQL: Difference between delete and truncate
  9. Transaction Control Statement Examples in SQL
  10. How to backup and delete archivelogs older than # number of days

You May Also Like

Primary Sidebar

Recent Posts

  • nixos-rebuild Command Examples in Linux
  • nixos-option: Command Examples in Linux
  • nixos-container : Command Examples in Linux
  • nitrogen Command Examples in Linux

© 2023 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright