Oracle Database 11g: Administration II — Question 3

What are the recommendations for Oracle Database 11g installation to make it Optimal Flexible Architecture (OFA)-compliant? (Choose all that apply.)

Answer options

• A. ORACLE_BASE should be set explicitly.
• B. An Oracle base should have only one Oracle home created in it.
• C. Flash recovery area and data file location should be on separate disks.
• D. Flash recovery area and data file location should be created under Oracle base in a non-Automatic Storage Management (ASM) setup.

Correct answer: A, C, D

Explanation

Setting ORACLE_BASE explicitly ensures a clear structure for Oracle installations, which is a key principle of OFA. Having the flash recovery area and data files on separate disks enhances performance and reliability, while placing them under Oracle base in a non-ASM setup maintains organization in the filesystem. Option B is incorrect because OFA allows multiple Oracle homes within the same Oracle base.