Oracle

Oracle DBA Online Training

• Introduction (Theory)
• Identify the oracle product
• Describe the basic concept of a relational database
• New features in oracle 11g

• Installing oracle database 11g software
• System requirements
• Redhat Linux 5.0 Installation (with and without Vmware workstation)
• Installation of multiple oracle servers and multiple oracle databases on Vmware workstation (features and advantages for RAC implementation with Vmware configuration)
• Install software with the Oracle Universal Installer on Linux Platform

• Oracle database Architecture
• Oracle Database 11g Architecture
• Oracle instance architecture
• Oracle Read Consistency and Concurrency

• Database Creation.
• Manual
• Database Configuration Assistant(DBCA)

• Controlling the database
• Start and stop the enterprise manager database console
• Start and stop the listener
• Startup and shutdown the database

• Storage Structures and architecture of Oracle 11g DBA
• Logical structure Vs Physical structure
• Defining the tablespaces and data files
• Create tablespaces
• Manage tablespaces
• Obtain tablespace information
• Managing Undo Data

• File Management ( Theory)
• Control File Management
• Redo Log File Management
• Parameter File Management
• Obtain tablespace information

• User Management
• Create and manage database user accounts
• Roles
• Privileges
• Control resource usage by using Profiles ion

• Oracle Database Security
• Apply the principal of least privilege
• Manage default user accounts
• Implement standard password security features

• Oracle Net Services
• Understand Oracle Net concepts
• Use Oracle Net Manager to create and configure listeners
• Use the listener control utility to control the Oracle Net Listener
• Testing Oracle Net connectivity
• Shared Server: Connection pooling

• Managing schema objects
• Create and modify tables
• Define constraints
• View the attributes of a table
• View the contents of a table
• Create indexes and views

• Oracle Backup & Recovery (User Managed) (Theory)
• Describe the basics of database backup, restore and recovery
• List the types of failure that may occur in an Oracle Database
• Describe ways to tune instance recovery
• Identify the importance of checkpoints, redo log files, and archived log file

• Oracle Backup
• Archive Log Mode
• Hot Backup
• Cold Backup
• RMAN Backup

• Cloning
• Cold Backup Cloning
• RMAN Backup cloning

• Logical Backup & Transporting data between databases
• Introduction Data pump (expdp, impdp) Utilities
• Exporting/Importing Tables
• Exporting/Importing Schemas
• Exporting/Importing Database

• Invalid Objects
• Compiling Invalid objects
• Status of Invalid objects
• Retriving count of each object type for each owner
• Rebuild Indexes

• Proactive Maintenance
• Contents
• Optimizer statistics
• Automatic Workload Repository

• Monitoring and Resolving Lock Conflicts
• Detect and resolve lock conflicts
• Manage deadlocks

• Automatic Storage Management (Theory)
  • New features and implementation
• Database Recovery (Practice only after getting experience)
• Recover from loss of a control file
• Recover from loss of a redo log file
• Recover from loss of a data file