Contents

• Introduction
  • The Relational Model
  • Play Along at Home
  
  
• Installation and the OFA
  • UNIX Users and Groups
  • Environmental Vars
  • File Locations
  • Memory Parameters
  • Troubleshooting Logs
  • Steps for installation
  
  
• Oracle Basics
  • Create a database
  • Connect and Startup
  • Create a table
  • Add data to a table
  • Create an index
  • Query the table
  • Creating and Querying a View
  • Destroying Schema Objects
  • Stopping the database
  • Destroy the database
  
  
• Poking around inside Oracle
  • The Data Dictionary
  • Essential System Tables
  • The Dollar Views
  • A word about STATSPACK
  
  
• Files and Componants
  • Database Files
  • Initialization Parameters
  • Oracle Startup
  • Oracle Distribution Files
  
  
• Users and Permissions
  • Users and Passwords
  • Adding New Users
  • Privileges, Roles and Profiles
  • Other Permissioning Problems
  • Changing Passwords
  
  
• The Listener
  • Configuring the Listener
  • Starting the Listener
  • TNS Resolution
  • Connecting remotely
  • Troubleshooting TNS
  
  
• Oracle Programming
  • SQL
  • PL/SQL
  • Pro*C: The Oracle SQL Precompiler
  • The C Interface: OCI
  • Regarding PERL
  
  
• SQL*Loader
  • Loading SYSLOG into a table
  
  
• Exporting databases with Data Pump
  • The Export
  • The Import
  • Digging Deeper
  
  
• Using RMAN
  • Enabling ARCHIVELOG Mode
  • Basic RMAN Backup
  • Basic Recovery
  • Listing Backups
  • Advanced Backup
  • Advanced Recovery
  
  
• Loose Ends
  • Oracle Flashback
  • Data Guard
  • OLTP
  • Data Warehousing and Data Marts
  • Oracle Options and Extensions
  • Oracle Pricing
  • License Enforcement
  • Oracle Support
  
  
• Tools to lessen the pain
  • YaSQL
  • TOra
  
  
• Oracle Proccesses