Partitioning

Remove components from Oracle’s kernel with chopt

Posted on February 23, 2017 by Mike.Dietrich Removal 6

Remove

I’ve had an interesting discussion today. Somebody removed OLAP with chopt – and got issues afterwards. My guess: chopt will only remove the binary option and is meant to be used before a database got created. But if you use it afterwards you’ll have to make sure to remove the dictionary components as well.

A while back a blogged about chopt already:

Removing Options from the Oracle Database kernel in 12c

And there are some helpful Support Notes out there:

MOS Note: 948061.1
How to Check and Enable/Disable Oracle Binary Options
This note WILL NOT address product specific scripts that

RMAN Catalog requires Enterprise Edition (EE)
since Oracle Database 12.1.0.2

Posted on August 14, 2014 by Mike.Dietrich Flaws and Pitfalls RMAN 26

Credits go to Cameron Hodge, Malcom and Martin Mäs who all highlighted issues to me following my previous entry about RMAN – and sorry for any disappointment but I wasn’t aware of all these nice little things.

Ok, you’d upgrade your RMAN Catalog to be ready to backup/recover Oracle Database 12.1.0.2 databases and you see this error:

RMAN>
upgrade catalog;
error creating create_deleted_object_seq
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-06004: ORACLE error from recovery catalog database:
ORA-00439:  feature not enabled: Partitioning

Now you start to wonder as your Catalog Database had been an Oracle Standard …