Re: Database creation question

From: Rick Weiss <>
Date: Wed, 23 Jan 2013 07:33:54 -0700
Message-ID: <>

Something else to consider - we have recently had to bring existing databases to DISA/NIST security levels. It's far easier to read all the things you can't have in the catalog (xdb, APEX, OCM) and not install them than to try and get through the process of uninstalling them (in the correct order). I am now at the point where I install base DB, and JServer and consider it done unitl someone needs another functionality. The most fun is when the auditors come in and ask why Context is installed and your answer is "because Oracle does it by default". I use dbca on to generate the creation scripts and then run them all by hand after tweaking to our environment.
Richard W Weiss
Oracle DBA

Student Assistance Foundation
2500 Broadway
Helena, MT  59601
(406) 495-7356 Office
(406) 438-7007 Cell

W. Clement Stone<>
"If you are really thankful, what do you do? You share."

On Tue, Jan 22, 2013 at 9:07 PM, Rich Jesse <> wrote:

> 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.
> GL!
> Rich
> --
-- ---------------------------------------------- This email and any files transmitted with may be confidential and are intended solely for the use of the individual or entity to which they are addressed. If you have received this email in error please notify the sender immediately and delete this e-mail from your system. This message may contain confidential information and the contents of this email are strictly prohibited from being disseminated, distributed, printed or copied. Student Assistance Foundation 2500 Broadway Helena MT 59601 ---------------------------------------------- --
Received on Wed Jan 23 2013 - 15:33:54 CET

Original text of this message