Re: Dear Oracle Corp.: ORACLE 7.2: No more OFA / $ORACLE_BASE support ?
Date: 1995/11/01
Message-ID: <4781lj$lct_at_peanuts.Materna.DE>#1/1
In article <476fmd$6ub_at_ddi2.digital.net>, delphi_at_digital.net says...
>
>OFA is more a directory structure for storing multiple versions of
Oracle
>executables, message files, *.sql scripts, etc. You will be well
advised
>NOT to locate any local datafiles under OFA. This includes init...ora,
>control, redo log, and datafiles. In the installation manual Oracle
>clearly states that no data files should be so stored.
>
>Dr.Phil
>
OFA is more than a directory structure for multiple Oracle Versions. Rule 3.9/10 of the OFA says (7.2.2 (SNI RM400/600) Oracle for UNIX Performance Tuning Tips, Appendix 1: OFA Rules):
"For each Oracle database on the system, create a directory /u[0-9][0-9]/ORACLE/d, where d is the db_name of the database. Put a file in this directory only if it is a control file, redo log file, or DATA FILE of the Oracle database d."
OFA means: Non admin files are located in /u??/ORACLE/MYDB and admin files are in the directory $ORACLE_BASE/admin/MYDB. OFA is better than you think!
Frank Received on Wed Nov 01 1995 - 00:00:00 CET