| |
 |
|
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.
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
