Oracle: OFA Part 9

Dear Readers,

My name is Franz Devantier, creator of this blog.  I am an Oracle Certified Professional (OCP DBA 11g) Security DBA.  I will be sharing with you the basic duties of an Oracle DBA, and also some of the undocumented, and not so well known tasks. 

OFA – Optimal Flexible Architecture

(Part 9, Exploiting the OFA Structure for Oracle Files)

You should be able to easily find any components, if the structure was set up according to standards from a UNIX/LINUX perspective.  Windows should not have strayed too far from the same outlines.

/*/home/* user home directories

/*/app/* user application software directories

/*/app/applmgr Oracle apps software subtrees

/*/app/oracle/product Oracle Server software subtrees

/*/app/oracle/product/9.0.1. Oracle Server distribution files

/*/app/oracle/admin/<db_name> database administrative subtrees

/*/oradata Oracle database directories

/*/oradata/<db_name>/* <db_name> database files, control files and redo logs, or at least the control files and redo logs, that are still in this directory structure after duplexing, and moving to other mount points, of the control and redo files.

The above represents an OFA compliant directory / file structure.  The directory structure is compliant, but remember that there are also the considerations of having the different structures on separate mount points or drives.  The question of I/O balancing etc.

Franz Devantier,

Need a database health check?

devantierf@gmail.com

Income stabilizer (win-win opportunity)

Join the carefully selected and tested cash-flow generating program below to potentially create a long-term residual or annuity type income enhancer for yourself.

Traffic Wave - Free Report:  The report will give you all the information you need to start making a nice long-term residual income stream for yourself.