Forum Stats

  • 3,770,215 Users
  • 2,253,082 Discussions
  • 7,875,368 Comments

Discussions

Can I remove features from oracle database installation ?

james1982
james1982 Member Posts: 12 Blue Ribbon
edited Dec 2, 2017 8:51AM in Database Installation

Hi ,

I would like to know if there is an option to deinstall oracle features from enterprise installation ( like partitioning for example ) ?

And also from 11g I don't think there is any option to chose features during installation , am I correct ?

Thanks a lot !

Tagged:

Answers

  • Dude!
    Dude! Member Posts: 22,826 Black Diamond
    edited Nov 30, 2017 9:36AM

    That's perhaps a somewhat more complex and difficult to answer question. However:

    https://docs.oracle.com/database/121/LADBI/remove_oracle_sw.htm#LADBI7824

    Oracle recommends that you use the deinstallation tool to remove the entire Oracle home associated with the Oracle Database, Oracle Clusterware, Oracle ASM, Oracle RAC, or Oracle Database client installation. Oracle does not support the removal of individual products or components.

    You can however disable certain components after the installation:

    https://docs.oracle.com/cd/E11882_01/install.112/e48740/post_inst_task.htm#AXDBI1274

    Check 5.2.7 Enabling and Disabling Database Options

  • handat
    handat Member Posts: 4,688 Gold Crown
    edited Nov 30, 2017 5:36PM

    It depends on what your understanding of 'installation' is. You can do an 'installation' which only installs, ie copies the oracle binaries and then lets you create a database instance afterwards as a separate step during which you can choose which component to include or exclude for the database instance you are creating. If you want to exclude the component binaries that are installed/copied to your system during the 'install' phase, then that's not supported. However, if your definition of 'installation' includes the second phase and you do not want to include certain components during that phase, then it is possible by using the advance option and you will be able to deselect the components you do not want to be added to the database instance that you are creating. That's available in 11g as well.

  • Wesley D-Oracle
    Wesley D-Oracle Posts: 193 Employee
    edited Nov 30, 2017 10:57PM

    This is basically the extent you can do regarding the Oracle Binaries:

    How to Check and Enable/Disable Oracle Binary Options (Doc ID 948061.1)

  • Constantin C-Oracle
    Constantin C-Oracle Member Posts: 33
    edited Dec 2, 2017 8:51AM

    In order to Enable/Disable options installed in the database one needs to be shutdown it in order to use the chopt utilty to enabe/disable binary options.

    usage:

    chopt <enable|disable> <option>

    For example to enable/disable Oracle Partitioning:

    Enable

    --------

    $ chopt enable partitioning

    References:How to Check and Enable/Disable Oracle Binary Options (Doc ID 948061.1) ( Already mentioned by Wesley)

    If you check the default templates you can

    Bellow from my text box

    more /u01/app/oracle/product/12.1.0.2/dbhome_1/assistants/dbca/templates/General_Purpose.dbc

    <?xml version = '1.0'?>

    <DatabaseTemplate name="General_Purpose" description=" " version="12.1.0.2.0">

    <CommonAttributes>

        <option name="OMS" value="true"/>

        <option name="JSERVER" value="true"/>

        <option name="SPATIAL" value="true"/>

        <option name="IMEDIA" value="true"/>

        <option name="XDB_PROTOCOLS" value="true">

           <tablespace id="SYSAUX"/>

        </option>

        <option name="ORACLE_TEXT" value="true">

           <tablespace id="SYSAUX"/>

        </option>

        <option name="SAMPLE_SCHEMA" value="false"/>

        <option name="CWMLITE" value="true">

           <tablespace id="SYSAUX"/>

        </option>

        <option name="APEX" value="true"/>

        <option name="DV" value="true"/>

    </CommonAttributes>

    <Variables/>

    ....

    So you can do:

    1. run the DBCA in interactive mode

    2. unset all the option that you don't want

    3. save as template

    4. Now every time that you need to run DBCA in silent mode you can use your custom template

    dbca -silent -responseFile <FullPathToResponseFile> -redoLogFileSize 2048 -templateName <Custom template created in the previous steps>

This discussion has been closed.