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 (http://dramse01.blogspot.com)