System management for Oracle DBAs  

home
Up
checklist
db config

 

AppsDBA.com 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 any Oracle server security patches.

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.
  10. Linux Specifics:
    11. bulletFor 32-bit installations add VLM changes if needed
    bulletModify memory to accommodate Huge Pages
    bulletRelink Oracle and enable asynchronous I/O support (optional)
    bulletEnable direct I/O support (optional)
  11. Optional tasks:
    12. bulletChange SYSTEM default tablespace to TOOLS or SYSAUX
    bulletVerify the MAXSIZE setting for all tablespaces
    bulletVerify that the SQL*Plus script pubbld.sql has been run and run the plustrce.sql script from the $ORACLE_HOME/sqlplus/admin directory
    bulletRun $ORACLE_HOME/install/changePerm.sh to relax permissions on some files for client access
    bulletCreate a system plan_table by running the following as SYSTEM:

    NOTE: In 10g catplan.sql will create a public global temporary plan table so these steps are unnecessary!

    bullet@?/rdbms/admin/utlxplan.sql
    bulletCREATE PUBLIC SYNONYM plan_table FOR system.plan_table;
    bulletGRANT SELECT, INSERT, DELETE ON plan_table TO public;
bulletGenerate schema level statistics
bulletCreate 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. bulletBackup utility (e.g. bkctrl)
    bulletlogdelete utility
    bulletchkdberr utility
    bulletSYSMON utility
    bulletSPACEMON utility
  5. Create crontab entries for any installed utilities
   

Copyright © 1998-2008 AppsDBA Consulting. All Rights Reserved.