RE: Seeking opinions

To me, there is a potential problem with having the software, administrative files (init.ora, etc), and database files all under one tree. Has no one else needed to do an "rm -r" in an admin or datafile directory to delete an old database? While there is a certain level of trust that must be given to SAs and DBAs, I try to prevent human error -- especially when that human is me!

If our datafiles all reside under the "/oracle" directory (under several mountpoints) while the software and admin directories are under another, it becomes that much more difficult to accidentally mangle files unintentionally.

And all this aside, Oracle doesn't support OFA in any way on OpenVMS. Trying to implement it there is an excersize in futility. And cause for excessive beer consumption.

:)

Rich Jesse                           System/Database Administrator
Rich.Jesse_at_qtiworld.com              Quad/Tech International, Sussex, WI USA

> -----Original Message-----
> From: Paul Baumgartel [mailto:treegarden_at_YAHOO.COM]
> Sent: Tuesday, April 02, 2002 11:14 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Seeking opinions
>
>
> I agree.
>
> I think that some people don't understand OFA's intentions. First of
> all, it _is_ a standard, meant to provide great flexibility.
>
> The reason mount points are to be named in a generic fashion is to
> allow any type of file to reside on them. Any number of file
> types can
> happily coexist under their own appropriately named subdirectories.
>
> Under OFA, database files can be easily identified by "ls
> /u???/oradata/$ORACLE_SID"; the file name ought to include the name of
> the tablespace to which the file belongs.
>
> Richard's point about a file that gets misnamed is well-taken. The
> only identification of datafiles that matters is the data dictionary.
> Rely on anything else and you're asking for trouble.
>
> Thanks to all for their comments.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: Rich.Jesse_at_qtiworld.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).