Re: the joy of version numbers

From: Hans Forbrich <fuzzy.graybeard_at_gmail.com>
Date: Wed, 22 May 2013 13:32:47 -0600
Message-ID: <519D1D5F.4070700_at_gmail.com>

On 22/05/2013 1:15 PM, Mark W. Farnham wrote:
>
> IF you've got a single mount point big enough to be reserved for
> /orasoft (as is mostly true these days) in place of the
> pre-oracle-dominance and much smaller /u01, /u02, /u03... allocations
> of often less than a gig back when Cary first wrote out OFA,
>
> THEN why bother with .../app/oracle/product/... ?
>

A single /orasoft instead of /u01 is OK by me, and I don't particularly like or need the app/ portion, but the oracle/ portion is based on userid and clusterware/infrastructure in a best-practices env goes into it's own BASE
So:

   /orasoft/oracle OR /u01/oracle is ORACLE_BASE for stuff owned by oracle amd

   /u01/grid is ORACLE_BASE for stuff owned by grid

Under the Oracle Base, there is a new plethora of directories

   ORACLE_BASE/diag (which should be a separate mount point due to growth)

   ORACLE_BASE/data     (sub SID could be separate MP)
   ORACLE_BASE/fra        (common for all??)
   ORACLE_BASE/admin  (which should include bunches of stuff in OH/dbs

and there should be

   ORACLE_BASE/logs
so I see

   ORACLE_BASE/product as useful

In my case, I also have a bunch of non-DB products, so I end up with

    ORACLE_BASE/product/database
    ORACLE_BASE/product/middleware
    ORACLE_BASE/product/management (cloud or grid control)
       - this one gets an additional layer: OMS, OMA

and so on

And since I test multiple versions of each, the next level down is the version, and then the HOME - see my SLA comment

A HOME should ideally be a mount point, as I've seen silly configurations fill up the Home with logs, or control file autobackups or other stuff.

And by maintaining Cary's mount point strategy, I can quickly toss or add new subs.

Of course, that is theory, and any SysAdmin and DiskAdmin orth their salt will explain about how difficult it is to maintain all these mount points and file systems and collapse it to one. (Which can take out all the Oracle stuff in one simple runaway log session. But that's a story of a different colour. Need to make tings easy for the SAs and DAs.)

/Hans

--
http://www.freelists.org/webpage/oracle-l

Received on Wed May 22 2013 - 21:32:47 CEST