Re: Database creation question

From: Rich Jesse <>
Date: Tue, 22 Jan 2013 22:07:37 -0600 (CST)
Message-ID: <0637cdf93d16da2ad9fe8da6e170e053.squirrel_at_hops>

Maureen writes:

> Do most people install Oracle Text when creating a new 11g database?

Not here, unless specifically required.

> I'm finding that with the newly created databases we get an error when we
> run utlrp. We haven't been installing Oracle Text in the new databases
> because it wasn't installed in the 10g database. Oracle Application Express
> is installed, though, because the screen in dbca says not to uncheck it.

I think this is a pretty good example of why I never use dbca. I don't think dbca's programmers can keep up with the changes to add-on modules (e.g. Text, OLAP, JVM) for each version.

Case in point, last year I upgraded our DBs from to One DB was seemingly created with dbca (by the prior DBA) because it's the only one with *every* module installed, including ones we weren't licensed for (and thankfully never used!). The upgrade via dbua (yes, first time I used it and I have to say it worked very well) required the removal of the addon modules, which suited me just fine.

It took me weeks to track down and organize the *16* MOS articles with the order-specific scripts and methods to remove those modules -- but they didn't all work. Three SRs later and I still had bad dependencies, and invalid and leftover objects that weren't dropped. In the end, everything did get cleaned up, but it was a LOT of work.

It just reaffirms my minimalist belief that if a module isn't needed for a DB, do not install it. Period. It *will* come back to haunt you some day! ;)

Create databases manually. There's a lot to learn by using that method.



Received on Wed Jan 23 2013 - 05:07:37 CET

Original text of this message