Call (800) 766-1884 for Oracle support & training
Free Oracle Tips

Oracle Consulting Support
Oracle Upgrades
Use New Oracle Features
Oracle Replication Support
Oracle Training
Remote Oracle DBA
System Documentation
Oracle Tips
Oracle Performance

Free Oracle Tips



BC Oracle tuning

Oracle training

Oracle support

Remote Oracle



  Oracle Tips by Burleson

Installation of Oracle

Oracle installation is a complex topic. With the new CD-based installs, many of the platform dependencies dealing with installation have been reduced, but you as database administrator (DBA) need to be aware of the differences that apply to your platform. Usually, these differences will be explained in the release documents and platform-specific installation and user’s guide provided with your software distribution. However, there are universal topics that involve structure and layout issues, and the purpose of this chapter is to present those topics and give you a general idea of the way to proceed with your installation.

Things to Consider Before Installation

Oracle Corporation has devised a standard architecture layout that it suggests should be used when installing Oracle. I have found that this standard layout, known as the Optimal Flexible Architecture or OFA for short, to be a logical way of laying out a database. OFA naming and layout standards should be used even in situations where the boundaries blur between disks, volumes, groups, and arrays, as is happening in the arena of RAID (redundant array of independent disks) technology. OFA should be used even when RAID5 or other RAID solutions are present because of the fact that it is a logical way to layout the database. By using OFA you, and subsequent DBAs, can easily locate all files associated with the database. I have seen databases where OFA or an OFA-based arrangement weren’t being used; files were placed anywhere it was convenient. This chaos method of database file placement led to bad backups due to missed files, deletion of files that were in use, and, because no one was tracking where files where placed, contention issues.

This is an excerpt by Mike Ault’s book “Oracle Administration & Management”.  If you want more current Oracle tips by Mike Ault, check out his new book “Mike Ault’s Oracle Internals Monitoring & Tuning Scripts” or Ault’s Oracle Scripts Download.

Download your Oracle scripts now:

The definitive Oracle Script collection for every Oracle professional DBA


Oracle performance tuning software 

Oracle performance tuning book


Oracle performance Tuning 10g reference poster
Oracle training in Linux commands
Oracle training Excel
Oracle training & performance tuning books



Copyright © 1996 -  2014 by Burleson. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.