I’ve struggled with this while installing Oracle Enterprise Manager Cloud Control 12c Release 2 (18.104.22.168). The documentation does not state that the database need to be installed with the partitioning option enabled. So because I’m a resource freak and I want to install only what is needed and nothing else, I did not enabled that option when I did the software install.
Based on the Oracle Database 11gR2 documentation this is easily done with the chopt utility that is provided in the ORACLE_HOME/bin directory when the database is closed.
[oracle@test bin] sqlplus / as sysdba shutdown immediate; exit [oracle@test bin] $ORACLE_HOME/bin/chopt enable partitioning Writing to /u01/app/oracle/product/11.2.0/dbhome_1/install/enable_partitioning.log... /usr/bin/make -f /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/ins_rdbms.mk part_on ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 /usr/bin/make -f /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/ins_rdbms.mk ioracle ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 [oracle@test bin]