• 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. Unable to instantiate disk “ASM_DISK” – error on running ‘oracleasm scandisks’ command
  2. How to check which options or features are used in the Oracle database
  3. Why Can I Login AS SYSDBA With Any Username and Password
  4. ORA-06512: at line num
  5. ASM background processes in 11gR2
  6. How to Set Timeout for WebLogic Web Service Client (JAX-WS and JAX-RPC)
  7. Script/Queries to Monitor Temporary (TEMP) Tablespace Usage in Oracle Database
  8. Oracle GoldenGate: How to start Extract & Replicat using Shell Script
  9. Oracle GoldenGate: Replicat Sample Parameter File
  10. How to install and configure Oracle ASMLIB on Native Linux multipath mapper devices

You May Also Like

Primary Sidebar

Recent Posts

  • vgextend Command Examples in Linux
  • setpci command – configure PCI device
  • db_load command – generate db database
  • bsdtar command – Read and write tape archive files

© 2022 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright