Enable partition and OLAP feature in oracle through silent installer

I have been working on enabling partition on oracle which is getting installed using silent installation. This post will give you basic idea about how to install oracle in silent mode.

In my case I was using below command for silent installation of oracle.

Command:

setup.exe -silent -showProgress -force -nontw32FoldersActions -waitforcompletion FROM_LOCATION=ORACLE_INSTALLER_PATH\\database\\stage\\products.xml ORACLE_HOME=ORACLE_HOME_PATH ORACLE_HOME_NAME=CDBORCL INSTALL_TYPE=SE -responseFile RESPONSE_FILE_PATH\\db.rsp

Parameters:

-silent : Tells installer to run in silent mode and does not invoke UI.

-showProgress : It will show progress on command prompt when installation is running. You can see what is being installed. If you don't give this option it will just install without any indication to user.

-force : No idea

-nontw32FoldersActions : No idea

-waitforcompletion : It will hold parent process which has started this installation. i.e. if you are installing oracle as part of some other application installation then main application installation will hold until oracle gets installed.

FROM_LOCATION : Location where installer can find product.xml. This file contains information about various installation type and features to be enabled in those installation types.

ORACLE_HOME : Location where you want to install oracle. Mostly its c:\oracle12c\CDBORCL_home.

ORACLE_HOME_NAME : Usually container database name. i.e. CDBORCL

INSTALL_TYPE : Installation type. It can be EE, SE, PE and Custom. Feature enable/disable depends on installation type. like partition and OLAP is not enabled on SE while its enabled on EE.  Do not confuse it will oracle edition like enterprise or standard. 

-responseFile : Response file which contains all input user gives when we run OUI(Oracle Universal Installer) through UI. You can get some sample response files under ORACLE_INSTALLER_PATH\database\response folder so you can fill values in it and use.

Values to Replace:

You need to replace all italic names with respective values for your installation.

i.e.

ORACLE_INSTALLER_PATH = Where your oracle installer folder is. Oracle installation usually consist two zip files so you need to extract both in single folder before you proceed.

ORACLE_HOME_PATH = Where you want to install your oracle on system. like c:\oracle12c\CDBORCL_home

RESPONSE_FILE_PATH = Response file location.

In my case issue was INSTALL_TYPE as highlighted on above command. Its SE so oracle will install standard installation which does not enable features like partition and OLAP. If you want to enable these feature you need to give INSTALL_TYPE=EE which will enable typical installation type and enables partitioning with other features like OLAP, Advanced Analytics, Real Application Testing.

Please give your feedback so I can improve this post based on that.