The Application DBA  

Database Installation Checklist

Verify system requirements

  1. Check memory, swap and temp space
  2. Verify OS version and patch levels
  3. Verify package requirements
  4. Verify kernel parameters

Pre-installation Setup

  1. Verify/add Oracle and database mount points
  2. Create Oracle groups
  3. Create Oracle user account
  4. Set Oracle user environment

Oracle user configuration

  1. Create OFA compliant ORACLE_BASE directory structure
  2. Configure ASM libraries if using ASM
  3. Create OFA compliant database file directories if using file systems

Install Oracle server software

  1. If using CRS and/or ASM then create a separate CRS and/or ASM ORACLE_HOME first. Two ORACLE_HOME installations will be made with this configuration.
  2. Install any Oracle server patch sets.
  3. Install latest appropriate OPatch version.
  4. Install any Oracle server security patches.
  5. Install any Oracle server security patches (i.e. Critical Patch Updates).
  6. Install Daylight Savings Time patches if not incorporated in the patchset.
  7. Verify ORACLE_HOME/jdk Java DST and patch if necessary.

Oracle Database Creation

  1. If using ASM then create ASM instance first.
  2. Create the target Oracle database.
  3. Apply any server security patches.

Oracle Database Post-Creation Tasks

  1. Verify external password file
  2. Configure init.ora parameters
  3. Convert to spfile (optional)
  4. Move spfile to $ORACLE_BASE/admin/$ORACLE_SID/pfile (optional)
  5. Clean up the oratab file
  6. Grant SYSDBA to system
  7. Verify the database global name
  8. Verify database accounts for locked and expired status, verify passwords for unlocked accounts.
  9. Generate system statistics (minimally create "NOWORKLOAD" stats).
  10. Linux Specifics:
  11. bullet For 32-bit installations add VLM changes if needed
    bullet Modify memory to accommodate Huge Pages
    bullet Relink Oracle and enable asynchronous I/O support (optional)
    bullet Enable direct I/O support (optional)
  12. Optional tasks:
    1. Verify JVM Daylight Savings Time post-installation tasks.
    2. Change SYSTEM default tablespace to TOOLS or SYSAUX
    3. Verify the MAXSIZE setting for all tablespaces
    4. Verify that the SQL*Plus script pubbld.sql has been run and run the plustrce.sql script from the $ORACLE_HOME/sqlplus/admin directory
    5. Run $ORACLE_HOME/install/ to relax permissions on some files for client access
    6. Create a system plan_table by running the following as SYSTEM:
    7. NOTE: In 10g catplan.sql will create a public global temporary plan table so these steps are unnecessary!

      1. @?/rdbms/admin/utlxplan.sql
      2. CREATE PUBLIC SYNONYM plan_table FOR system.plan_table;
      3. GRANT SELECT, INSERT, DELETE ON plan_table TO public;
    8. Generate schema level statistics (optional)
    9. Create custom roles (i.e. data_owner)

Network Configuration

  1. Verify sqlnet.ora, tnsnames.ora and listener.ora configuration files exist (or their links) in $ORACLE_HOME/network/admin
  2. Verify parameters and log file locations
  3. Configure each database explicitly in the listener.ora file (recommended)
  4. Password protect the listener (recommended)
  5. Configure IPC local database connections (optional)
  6. Move sqlnet.ora and tnsnames.ora files to $ORACLE_BASE/admin/snet/admin directory and create links in each $ORACLE_HOME/network/admin directory

Utility Setup

  1. Create $ORACLE_BASE/local directory and create "log" and "script" subdirectories
  2. Set up dbcontrol and orasetup utilities
  3. Set up dbora utility and follow script directions to install in /etc/init.d
  4. Optionally add:
  5. bullet Backup utility (e.g. bkctrl)
    bullet logdelete utility
    bullet chkdberr utility
    bullet SYSMON utility
    bullet SPACEMON utility
  6. Create crontab entries for any installed utilities


Copyright 1998-2013 AppsDBA Consulting. All Rights Reserved.