Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Oracle 11g: Yet another about face on OFA naming conventions

Re: Oracle 11g: Yet another about face on OFA naming conventions

From: LS Cheng <exriscer_at_gmail.com>
Date: Mon, 13 Aug 2007 12:08:47 +0200
Message-ID: <6e9345580708130308u77278d78vbe7b48bfe5383f46@mail.gmail.com>


Not sure if you only work with Windows and that is the Windows OFA but in UNIX/LINUX for example I have never seen oradata under any ORACLE_*

Thanks

--
LSC

On 8/13/07, Paul Vincent <Paul.Vincent_at_uce.ac.uk> wrote:

>
> It seems Oracle have yet again rethought their naming conventions for the
> Optimal Flexible Architecture.
>
> For 10g, for instance, the conventions included:
>
> ORACLE_BASE recommended as e.g. system_drive:\oracle\product\10.2.0
>
> ORACLE_HOME recommended as e.g. ORACLE_BASE\db_1
>
> ADMIN directory recommended to be under ORACLE_BASE, so that bdump
> directory for database ORCL would be:
> system_drive:\oracle\product\10.2.0\admin\ORCL\bdump
>
> ORADATA directory recommended to be under ORACLE_BASE, so that control
> file for database ORCL would be:
> system_drive:\oracle\product\10.2.0\oradata\ORCL\control01.ctl
>
> Now, at the time, on this list and elsewhere, this was criticised for
> being against the aims of the "original" OFA, in that it placed admin files
> and data files under the directory for a specific release of Oracle, instead
> of under the general "oracle" directory. It was pointed out that, when 11g
> came along and 10g databases were migrated to 11g, DBAs would be faced with
> the choice of either leaving the admin and data files under a directory
> whose full path would misleadingly tag them as belonging to a 10g database,
> or moving them under the 11g base directory, with all the inconvenience that
> would entail.
>
> Sure enough, under 11g, we are now told the OFA conventions should be:
>
> ORACLE_BASE recommended as e.g. system_drive:\oracle (There's the first
> difference, straight away)
>
> ORACLE_HOME recommended as e.g. ORACLE_BASE\product\11.1.0\db_1 (same end
> result as in 10g, but derived differently from ORACLE_BASE)
>
> ADMIN directory recommended to be under ORACLE_BASE, so that bdump
> directory for database ORCL would be:
> system_drive:\oracle\admin\ORCL\bdump
>
> ORADATA directory recommended to be under ORACLE_BASE, so that control
> file for database ORCL would be:
> system_drive:\oracle\oradata\ORCL\control01.ctl
>
>
> Now, note that the 11g OFA conventions are once more back in keeping with
> the "original" OFA. Which is a good thing. When you migrate to the next
> version of Oracle (12g?), your admin files and data files can stay put,
> without anything misleading about their path names.
>
> Hurrah!
>
> Except... some of us (well, myself, anyway) decided, when installing 10g
> databases, to stick with Oracle's recommended OFA naming conventions for
> 10g, so as to be as compliant as possible with their recommendations (always
> a good idea when anticipating dealing with Oracle Support). So my Oracle
> Base, under which all present and future Oracle Homes will be slotted, is
> oracle\product\10.2.0, and all other files and directories are named and
> positioned as per the 10g OFA guidelines. But when I upgrade to 11g I'll be
> stuck with this, and will be forced into conventions which are no longer
> consistent with their 11g OFA guidelines.
>
> I wish they'd make their minds up.
>
> Pah!
>
> Paul Vincent
> Database Administrator
> Information and Communication Technology
> UCE Birmingham
> paul.vincent_at_uce.ac.uk
>
>
> ------------------------------
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Stefan Knecht
> *Sent:* 10 August 2007 14:55
> *To:* sacrophyte_at_gmail.com
> *Cc:* oracle-l
> *Subject:* Re: 11g on OTN for download!
>
> Doesn't seem to be that much missing?
>
> http://www.oracle.com/pls/db111/portal.all_books
>
> I don't like the new doc layout they got though.
>
> Stefan
>
> On 8/10/07, Charles Schultz <sacrophyte_at_gmail.com> wrote:
> >
> > Perhaps the more impressive part is that the documentation has been
> > released. Well, I should qualify that and say a small subset of the
> > documentation *grin*.
> > http://www.oracle.com/pls/db111/homepage
> >
> > On 8/10/07, dba1 mcc < mccdba1_at_yahoo.com> wrote:
> > >
> > > Look like 11g database still NOT release. the web
> > > site ONLY 11g compoments can download.
> > >
> > >
> > > ==================================================
> > > Oracle Database 11g Release 1 Client (11.1.0.6.0) for
> > > Linux x86
> > > linux_11gR1_client.zip (458,677,395 bytes) (cksum
> > > - 2693183676)
> > >
> > > Oracle Database 11g Examples (formerly Companion)
> > > linux_11gR1_examples.zip (457,209,469 bytes)
> > > (cksum - 606940067)
> > >
> > > Oracle Clusterware Release 1 (11.1.0.6.0) for Linux
> > > x86
> > > linux_11gR1_clusterware.zip (244,654,895 bytes)
> > > (cksum - 3625236068)
> > >
> > > Oracle Database Gateways 11g Release 1 (11.1.0.6.0)
> > > for Linux x86
> > > linux_11gR1_gateways.zip (451,061,474 bytes)
> > > (cksum - 1541243104)
> > >
> > >
> > > Oracle HTTP Server (Apache 2.0) (10.1.3.3.0) for Linux
> > > x86
> > > as_101330_apache2_lnx.zip (334,457,994 bytes) (cksum -
> > > 499385062)
> > >
> > >
> > > --- Jeremy Paul Schneider
> > > <jeremy.schneider_at_ardentperf.com> wrote:
> > >
> > > > Looks like we can now download Oracle 11g for Linux!
> > > >
> > > >
> > > http://www.oracle.com/technology/software/products/database/index.html
> > >
> > > >
> > > > --
> > > > Jeremy Schneider
> > > > Chicago, IL
> > > > http://www.ardentperf.com/category/technical
> > > >
> > >
> > >
> > >
> > > ____________________________________________________________________________________
> > >
> > > Shape Yahoo! in your own image. Join our Network Research Panel
> > > today! http://surveylink.yahoo.com/gmrs/yahoo_panel_invite.asp?a=7
> > >
> > >
> > > --
> > > http://www.freelists.org/webpage/oracle-l
> > >
> > >
> > >
> >
> >
> > --
> > Charles Schultz
>
>
>
>
> --
> =========================
>
> Stefan P Knecht
> Consultant
> Infrastructure Managed Services
>
> Trivadis AG
> Europa-Strasse 5
> CH-8152 Glattbrugg
>
> Phone +41-44-808 70 20
> Fax +41-808 70 12
> Mobile +41-79-571 36 27
> stefan.knecht_at_trivadis.com
> http://www.trivadis.com
>
> =========================
>
>
-- http://www.freelists.org/webpage/oracle-l
Received on Mon Aug 13 2007 - 05:08:47 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US