Re: the joy of version numbers

  • From: Hans Forbrich <fuzzy.graybeard@xxxxxxxxx>
  • To: "Mark W. Farnham" <mwf@xxxxxxxx>
  • Date: Wed, 22 May 2013 13:32:47 -0600

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


Other related posts: