RE: OMF or not OMF? DBCA or Manual scripts

From: Patterson, Joel <>
Date: Tue, 25 Mar 2014 15:19:55 -0400
Message-ID: <C1117B1AA0340645894671E09A7891F715F3F5C0B4_at_EIHQEXVM2.ei.local>

chopt only does part of the job -- might make you legal, but all the stuff is still going to hang around on the database side and to someone that wants it clean, it's rather annoying and still hard to get rid of/uninstall.

Then you might forget or move on, and the next guy sees all the stuff and uses up time on it.

Joel Patterson
Sr. Database Administrator | Enterprise Integration
Phone: 904-928-2790 | Fax: 904-733-4916!/entint

This message (and any associated files) is intended only for the use
of the addressee and may contain information that is confidential,
subject to copyright or constitutes a trade secret. If you are not the
intended recipient, you are hereby notified that any dissemination,
copying or distribution of this message, or files associated with this
message, is strictly prohibited. If you have received this message in
error, please notify us immediately by replying to the message and
deleting it from your computer. Messages sent to and from us may be
monitored. Any views or opinions presented are solely those of the
author and do not necessarily represent those of the company. [v.1.1]

From: [] On Behalf Of Norman Dunbar
Sent: Tuesday, March 25, 2014 1:45 PM
Subject: Re: OMF or not OMF? DBCA or Manual scripts

Evening Rich,

On 25/03/14 14:14, Rich Jesse wrote:

> It seems I'm the only stick in the mud who doesn't like using DBCA. I
> just gave it another shot on to make sure it's still a terrible GUI.
I use template databases set up as required and company standardised. There are quite a few but they are all neatly packaged and RMAN backed up. When we need a new database, we simply "recover" the template we want, and "Robert is your Mother's Brother". Speaking only for myself, I'm with you on the DBCA front, it is indeed dire. I have never liked it since it first appeared. In a previous life, I did use it once to build a set of 11g database build scripts which I kept and used frequently for new builds - a quick copy into a scripts directory, and an even quicker "sed -i" to replace stuff and I had a new working set of scripts to build the database. No need to keep on running DBCA. I do, on the other hand rather like DBUA for running upgrades. (Or at least, I did in a past life!)
> ... I don't like tools that make it easy for a Jr.
> DBA to screw up, as the default template includes licensed options
> (which are also a major pain to remove post-install, from experience).
Chopt is your friend, as is cd $ORACLE_HOME/rdbms/lib && make -f ..... ioracle.
> No OMF. No ASM. No DBCA. They are (potentially) answers to problems
> I don't have, and include or have included major bugs that I don't
> need. As a solo DBA, there is just no ROI that anyone's been able to
> prove for me to use them.
OMF is pretty nifty, I never used to like it, but I am one of the converted. ASM also - and the two go hand in hand. I don't need to care about the names of my database files any more because they are not on filesystem discs, so nobody needs to ask "what database do these files belong to?".
> Sigh. I don't get to attend the Cool Tool Party...again. APEX! I
> love APEX! Does that count? :)
Toad, the coolest tool of all. :-) Cheers, Norm. -- Norman Dunbar Dunbar IT Consultants Ltd Registered address: 27a Lidget Hill Pudsey West Yorkshire United Kingdom LS28 7LG Company Number: 05132767 -- --
Received on Tue Mar 25 2014 - 20:19:55 CET

Original text of this message