Re: Database creation question

> 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 10.1.0.5 to 11.2.0.3. 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.

GL!

Rich

--
http://www.freelists.org/webpage/oracle-l