Oracle Certification Notes: Part II

My continuation of notes as I prepare for the Oracle 11g Certified Associated credential:

Oracle System Requirements

  • No CPU requirements – what’s good for the OS is good for Oracle
  • Best bang for your Oracle buck: The more RAM, the better
  • Always reference Oracle’s Metalink website for the latest requirements and compatible OS’

    Optimal Flexbile Architecture (OFA)

  • Oracle’s way of creating standard mounting points and file directory structure to Oracle’s install
  • Makes use of multiple physical disks for improved performance
  • Helps separate multiple Oracle homes
  • Mount point recommended standard: /<constant> (e.g., /ora01, /ora02, etc.)
  • Directory recommended standard: /<mount point>/<purpose>/<owner>/product/<version> (e.g., /ora01/db/oracle/product/9.0.4)

    OFA Admin Directories (e.g., /ora01/admin/oracle/<admin dir>)

  • adhoc – Ad hoc SQL and PL/SQL scripts for the database
  • arch – Location of archived redo log files
  • adump – Location of audit files (parm: AUDIT_FILE_DEST)
  • bdump – Location of background process trace files and the alert log file. (parm: BACKGROUND_DUMP_DEST)
  • cdump – Core dump file location. (parm: CORE_DUMP_DEST)
  • create – Location of scripts used to create the database. DBCA places scripts in this location when you use it to create a new database.
  • exp – Recommended location of database export files created by the Export utility or Oracle Data Pump
  • logbook – Location of database history and status log files
  • pfile – The parameter files used to start the database is placed here
  • udump – User process trace files are located here. (parm: USER_DUMP_DEST)

    OFA Database Files (e.g., /ora01/oradata/oca11g)

  • Convention for location includes /<mount point>/<reference to oracle db data – oradata or oracle>/<database name – DB_NAME parameter or ORACLE_SID paramater>/
  • Control files (e.g., controlnn.ctl), redo logs (e.g., redonn.log), and database files (e.g., tablespacenamenn.dbf) are the only files that should be contained within this directory. All other files should be within the admin directories.

    Posted via Woodland Blog (

  • Leave a Comment

    Your email address will not be published. Required fields are marked *

    This site uses Akismet to reduce spam. Learn how your comment data is processed.