Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 6465 invoked from network); 8 Aug 2006 10:24:56 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 8 Aug 2006 10:24:55 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1136A3BDC0C; Tue, 8 Aug 2006 11:24:40 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 07549-06; Tue, 8 Aug 2006 11:24:39 -0400 (EDT) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 80F173BDBD7; Tue, 8 Aug 2006 11:24:39 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 08 Aug 2006 11:23:52 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 36F003BDB97; Tue, 8 Aug 2006 11:23:52 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 07356-03; Tue, 8 Aug 2006 11:23:52 -0400 (EDT) Received: from gscodenm05.cr.usgs.gov (gscodenm05.cr.usgs.gov [136.177.7.15]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id EB96B3BCD76; Tue, 8 Aug 2006 11:23:51 -0400 (EDT) In-Reply-To: <6.2.1.2.0.20060808223753.01fd46f0@pop.singnet.com.sg> MIME-Version: 1.0 To: hkchital@singnet.com.sg Cc: oracle-l@freelists.org, oracle-l-bounce@freelists.org, Paul.Vincent@uce.ac.uk Subject: RE: Inheriting a "interesting" recovery process Message-ID: From: William B Ferguson Date: Tue, 8 Aug 2006 09:23:26 -0600 X-MIMETrack: Serialize by Router on gscodenm05/SERVER/USGS/DOI(Release 6.5.5HF94 | February 6, 2006) at 08/08/2006 09:24:06, Serialize complete at 08/08/2006 09:24:06 Content-Type: multipart/alternative; boundary="=_alternative 0054D52E872571C4_=" X-archive-position: 37881 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: wbfergus@usgs.gov Precedence: normal Reply-to: wbfergus@usgs.gov X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at avenirtech.net --=_alternative 0054D52E872571C4_= Content-Type: text/plain; charset="US-ASCII" Personally, I prefer the datafiles at the same level as ORACLE_BASE or higher. When I upgrade or install a new version, I don't have to worry about juggling the datafiles around to a new location before I delete the old binaries. I'm probably missing something though on why it's defined the way it is, but that's my preference. ----------------------------------------------------------------------------- Bill Ferguson U.S. Geological Survey - Minerals Information Team PO Box 25046, MS-750 Denver Federal Center Denver, Colorado 80225 Voice (303)236-8747 ext. 321 Fax (303)236-4208 ~ Think on a grand scale, start to implement on a small scale ~ Hemant K Chitale Sent by: oracle-l-bounce@freelists.org 08/08/2006 08:38 AM Please respond to hkchital@singnet.com.sg To Paul.Vincent@uce.ac.uk, cc Subject RE: Inheriting a "interesting" recovery process I don't understand how putting ORADATA under ORACLE_BASE is "Flexible" in any way. Hemant At 09:56 PM Tuesday, Paul Vincent wrote: >Well, let's see... > >Oracle Database Installation Guide, 10g Release 2 (10.2) for Microsoft >Windows (32-Bit) B14316-02. Appendix C, Optimal Flexible Architecture. >Page C-5, in the section "OFA Directory Naming Conventions": > >"ORADATA Directory > >Database files are stored in ORACLE_BASE\oradata\DB_NAME. Names and >brief descriptions are: Hemant K Chitale http://web.singnet.com.sg/~hkchital -- http://www.freelists.org/webpage/oracle-l --=_alternative 0054D52E872571C4_= Content-Type: text/html; charset="US-ASCII"
Personally, I prefer the datafiles at the same level as ORACLE_BASE or higher. When I upgrade or install a new version, I don't have to worry about juggling the datafiles around to a new location before I delete the old binaries.

I'm probably missing something though on why it's defined the way it is, but that's my preference.
-----------------------------------------------------------------------------

                              Bill Ferguson
           U.S. Geological Survey - Minerals Information Team
                          PO Box 25046, MS-750
                          Denver Federal Center
                         Denver, Colorado 80225
          Voice (303)236-8747 ext. 321     Fax   (303)236-4208
     ~ Think on a grand scale, start to implement on a small scale ~


Hemant K Chitale <hkchital@singnet.com.sg>
Sent by: oracle-l-bounce@freelists.org

08/08/2006 08:38 AM
Please respond to
hkchital@singnet.com.sg
To
Paul.Vincent@uce.ac.uk, <oracle-l@freelists.org>
cc
Subject
RE: Inheriting a "interesting" recovery process






I don't understand how putting ORADATA   under ORACLE_BASE
is "Flexible"  in any way.

Hemant

At 09:56 PM Tuesday, Paul Vincent wrote:
>Well, let's see...
>
>Oracle Database Installation Guide, 10g Release 2 (10.2) for Microsoft
>Windows (32-Bit) B14316-02. Appendix C, Optimal Flexible Architecture.
>Page C-5, in the section "OFA Directory Naming Conventions":
>
>"ORADATA Directory
>
>Database files are stored in ORACLE_BASE\oradata\DB_NAME. Names and
>brief descriptions are:


Hemant K Chitale
http://web.singnet.com.sg/~hkchital


--
http://www.freelists.org/webpage/oracle-l
--=_alternative 0054D52E872571C4_=-- -- http://www.freelists.org/webpage/oracle-l