Re: Practice of using chopt to disable database options
Date: Fri, 15 Nov 2013 14:31:38 -0600 (CST)
Message-ID: <7475bc99a4f77c6edb9cfaf8909321f3.squirrel_at_society.servebeer.com>
Hans replies:
> For example, Locator is free and included in all Oracle editions.
> Locator uses exactly the same code as Spatial option - Spatial option is
> a superset. It is not easy to install Locator but avoid Spatial.
> "How To Deinstall Oracle Spatial Keeping Oracle Locator (Doc ID 1070647.1)"
LOL -- ever try to remove the OLAP option that was accidentally installed?
Prior to upgrading our 10.1 to 11.2, I used MOS 332351.1, 1060023.1, 565773.1, 1449652.1, and 565773.1, plus an SR that I needed to open because those didn't completely remove OLAP. And the techs still couldn't get it cleaned. I had to use 2 scripts from 11.2 on our 10.1 DB to finally wipe it where the upgrade wouldn't fail.
I spent the better part of 6 weeks to clean up DBs from errant option installations. Bleah!
Rich
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Nov 15 2013 - 21:31:38 CET