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


 

HTML Text

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:

www.oracle-script.com

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.