Oracle System Administration

Oracle Unix System Administration – I

OSA4 4-day course,
Price: $2,875 List, Including lodging $3,250

Course Description

This course is designed to introduce experienced Unix System Administrators to an overview of the Oracle Relational Database Management System as it relates to the Unix Operating System environment. The course will help bridge the gap between worlds of the Oracle Database Administrator and the Unix Administrator. It includes topics such as system preparation and Unix kernel tuning for Oracle installation, configuration of the Oracle initialization file, backup strategies, Oracle structures, and performance issues. In addition, enhancement comparisons are made between 9i and 10g.

Target Audience

The course is ideal for Unix System Administrators with no experience or limited experience with Oracle. It is designed for System Administrators seeking a broad overview of oracle as it relates to the Unix environment. Although various flavors of Unix (HP-UX, AIX, Solaris) are mentioned within the curriculum, the course is taught on the HP-UX platform.

Course Activities

  • Research and implement system preparation tasks for a typical Oracle Installation .
  • Modify the Oracle initialization file
  • Add user, change privileges, roles, and profiles
  • Query Oracle views to observe the database structural layout
  • "hot" and "cold" backups
  • Perform various types of database recovery
  • Configure Oracle Networking files
  • Perform basic SQL and SQL* Plus queries on a Production database.
  • Upgrade to a new release of Oracle (optional)

Course Content

Understanding Oracle

  • Relational Database Concepts
  • The Optimal Flexible Architecture
  • The Oracle Initialization file
  • Database Structure
  • Role of the Database Administrator

Key Oracle Processes

  • Database Writer
  • Checkpoint (CKPT)
  • System Monitor (SMON)
  • Process Monitor (PMON)
  • Remote Monitor (RMON)

The Initialization File

  • Key File Parameters
  • Log Destination Parameters
  • Statement Parameters
  • SGA Parameters
  • Performance Parameter
  • Limit Parameters

Oracle Structures

  • Introduction to Data Dictionaries
  • Static Data Dictionary Views
  • Dynamic Data Dictionary Views
  • Modifying Database Control Files
  • Modifying Online Redo Log Files
  • Modifying Database Data Files

Oracle Database Backup & Recovery

  • Offline and Online Backups
  • Configuring Archived Log Mode
  • Review of Oracle Components Necessary for Oracle Recovery
  • Recovery of a Database Configured in Archived Log Mode
  • Recovery of a Database NOT Configured in Archived Log Mode
  • Recovery After the Loss of Archived Redo Log Files
  • Recovery After the Loss of Online Redo Log Files
  • Recovery After the Loss of the Control Files

Oracle Installation [ 9i & 10g ]

  • Pre-Installation Planning and Preparation
  • Preparing System Resources
  • Creating the Oracle Owner and Configuring its Environment
  • Planning the Layout of the Physical Database Components
  • Running the Oracle Installer
  • Creating a sample Database
  • Unix Kernel configuration

Startup and Shutdown

  • Modes of Startup
  • Modes of Shutdowns
  • Automatic Startup and Shutdown

SQL and SQL*Plus

  • SQL Commands, Statements, and Clauses
  • SQL*Plus Commands
  • Connecting to the Database Using SQL*Plus

Users and Security

  • Creating Users
  • Querying Users, Profiles, and Privileges
  • Deleting Users
  • Operation System Authentication
  • Oracle Password File Authentication

Oracle Networking Products

  • SQL*Net and Net9
  • Oracle Network Listener
  • Configuring Multiple Listeners
  • Local Naming Resolution Using tnsnames.ora

Migrating an Oracle Database (Optional)

  • Migration Methods and Paths
  • Preparing the Oracle9i Database
  • Migrating from 8i -> 9i -> 10g
  • Using the Migration Utility
  • Using ODMA
  • Post-Migration Tasks


  • Disk I/O
  • Memory
  • Oracle Performance Statistics
  • Oracle Optimizer and the Analyze Command
  • Baseline Performance Data


  • Recovery Manager (RMAN)
  • Kernel Tuning Parameters
  • Logical Volume Management
  • Filesystems
  • Kernel Configuration

What past students have to say about our Oracle System Administration on Unix class:

  • “The Course was what I expected, I knew bits and piecs, but now have a better understanding of what is happening.”
  • “The Course and Instructor exceeded my expectations.”
  • “Very pleased with the instructor’s extra effort.”
  • “Good overview of Oracle.”
  • “I was leaving with the knowledge I was expecting to.”
  • The instructor and the profeesional staff. The manual is exactly what I am looking for, understanding Oracle and especially the backup and recovery.”

features of every Netsysco course:

  • No sharing! Class Delivery on 11i HP-UX server for each student.
  • Curriculum developed by Netsysco based on real world practical applications.
  • Well-documented color reference manual.
  • Instructors who are experienced system administrators.
  • Lots of opportunity for practicing what is taught, not just being guided through exercises.
  • Small class size with personal attention from the instructor.
  • Daily computerized self-assessments to monitor progress.

♦ For course content, schedules, and pricing, click on course title.


メールアドレスが公開されることはありません。 * が付いている欄は必須項目です