Forum Stats

  • 3,733,073 Users
  • 2,246,690 Discussions
  • 7,856,502 Comments

Discussions

Can I remove features from oracle database installation ?

james1982
james1982 Member Posts: 12 Blue Ribbon
edited December 2017 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

  • handat
    handat Member Posts: 4,688 Gold Crown
    edited November 2017

    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 November 2017

    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 December 2017

    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.