Adding partitioning option to a database after software installation

I’ve struggled with this while installing Oracle Enterprise Manager Cloud Control 12c Release 2 (12.1.0.2). 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]

Leave a Reply

Your email address will not be published. Required fields are marked *