| |
 |
|
Donald K. Burleson
Oracle Tips |
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.
|
