Re: Database creation question
- From: Rick Weiss <rweiss@xxxxxxxxx>
- To: "List, Oracle Discussion" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 23 Jan 2013 07:33:54 -0700
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
rweiss@xxxxxxxxx
W. Clement
Stone<http://www.brainyquote.com/quotes/authors/w/w_clement_stone.html>
-
"If you are really thankful, what do you do? You share."
On Tue, Jan 22, 2013 at 9:07 PM, Rich Jesse <
rjoralist2@xxxxxxxxxxxxxxxxxxxxx> 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 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
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
----------------------------------------------
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
http://www.safmt.org
----------------------------------------------
--
//www.freelists.org/webpage/oracle-l
Other related posts:
