Forgot your password?    
+ Reply to Thread
Results 1 to 2 of 2

Thread: Oracle DBA Training : Database 11G Course Content

  1. #1
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    New Delhi, India
    Posts
    412

    Oracle DBA Training : Database 11G Course Content

    PRE Requisites : Knowledge of SQL and Basic Unix / Linux OS Knowledge

    SQL Requirements - Select,DDL,DML,DCL,TCL

    • Unix/Linux commands used by DBA :
    ls , cp ,mv , rm , mkdir , rmdir , which , ls , grep , ps , ln , id ,
    man , head , tail , env , echo , pi ng , kill , wc , export
    df, du ,tar , gzip , top , free , vmstat , netstat , ifconfig
    vi editor


    ORACLE DATABASE ADMINISTRATION 11G TRAINING COURSE CONTENT

    Reviewing tools and Support Sites

    • Introduction to Commonly used Tools : Putty, VNC, Winscp, VPN , telnet . ssh
    • Introduction to Online DBA Support Sites : DBALounge Forum , Oracle Support Sites

    Oracle Database 11G Architecture
    • Instance vs. Oracle Database 11G
    • Components of an Oracle Database 11G Instance
    • Components of an Oracle Database 11G
    • Datafiles, Controlfiles and Redo Logs
    • Checkpoints , Roll Forward and Rollback
    • Redo log concepts, Instance and Media recovery
    • Buffer Cache Block Management - LRU List
    • SGA vs. PGA
    • Background processes

    Software and Database Installation
    • Unix Kernel Parameters Setup
    • Important configuration files - sysctl.conf, limits.conf, meminfo ,cpuinfo
    • Installation of Oracle Software
    • Installation Oracle Database 11G using DBCA
    • Setting up of Environment
    • Startup and Shutdown of the Oracle Database 11G

    Oracle Database 11G Init Parameters
    • Init parameters
    • Displaying init.ora values with v$parameter
    • Sizing SGA components
    • Shared pool concepts and components
    • Overview of PGA for sorting and pga_aggregate_target
    • Alteration of Modifiable and Non Modifiable Init parameters vs. Spfile
    • Explaining the use of control files
    • File locations for control Files
    • Obtaining Control File Information
    • Multiplexing Control Files
    • Convert Oracle Database 11G to Archivelog Mode
    • Archiving the Oracle Redo Logs

    Oracle Database 11G Tablespace Management
    • Managing Tablespaces - Create, alter, drop, rename, offline, online, read only, read write
    • Creating, Resizing, Renaming, offline Datafiles
    • Creating and Managing Temporary Tablespaces and Tempfiles
    • Creating and Managing Undo Tablespaces
    • Understanding Undo Retention
    • Free Space / Used Space in Tablespace
    • Troubleshooting Undo – snapshot too old
    • Online redo log (log_buffer)
    • Dictionary queries

    Oracle Database 11G Redo Management , Management of Database Segments
    • Redo log switch
    • Multiplexing the Online Redo Log Files
    • Dictionary and v$ views
    • The dba_, all_ and user_ structures
    • Querying the tables, indexes, and segments views
    • Monitoring the alert log
    Oracle Database trace/dump files
    Oracle Database tables : Creation and Maintenance Operations
    Oracle Database Indexes : Creating B*-Tree, bitmap and function-based Indexes
    Oracle Database Views

    Oracle Database 11G Reorg, Users , Roles , Profiles , Privileges
    • Reorganize Tables
    • Index rebuilding
    • Creating New Database Users
    • Managing Profiles
    • Auditing User activity
    • Identifying System and Object Privileges
    • Granting and Revoking Privileges
    • Creating and Modifying Roles
    • Displaying user security Information from the Data Dictionary

    Oracle Database 11G*Net configuration
    • Understanding the Listener and how connection takes place from Client to Server
    • Use Netca
    • Creating the listener.ora file
    • Creating the tnsnames.ora file
    • Verifying network connectivity with ping and tnsping
    • Testing Oracle Database 11G connection via Listener

    Oracle Database 11G Backup & Recovery
    • Hot vs. Cold backups
    • Backup in Archivelog vs. Noarchivelog Mode
    • Taking Cold Backups
    • Taking Hot Backups
    • Concepts of Hot Backup
    • Complete and Incomplete Recovery
    • Restoration from cold Backup with complete data loss
    • Restoring and Recovering from loss of Datafiles - System and non system ,loss of Read Only Tablespaces
    • Loss of Controlfiles
    • Loss of Redo Logs - Inactive and Active
    • Complete and Incomplete Recovery

    Oracle Database 11G Backup and Recovery management using RMAN
    • Advantages of RMAN
    • Advantages of Catalog over Nocatalog
    • Catalog Creation
    • RMAN Closed Database and Hot Backups
    • RMAN Backup Management (Backup Database , tablespace , Datafile ,controlfile ,archivelogs , spfile)
    • Viewing Backups using List
    • Configure RMAN(Configure channels , autobackup , tape / disk ,retention Policies)
    • Reporting Bacukups
    • Restoring and Recovering from loss of Datafiles - System and non system ,loss of Read Only Tablespaces
    • Loss of Controlfiles
    • Loss of Redo Logs - Inactive and Active
    • Complete and Incomplete Recovery

    Oracle Database 11G DBA Utilities
    • Imp and exp utilities
    • Data pump (impdp and expdp)
    • SQL*Loader

    Oracle Database 11G DBA Utilities
    • DBVerify for Corruptions
    • Flashback Oracle Database, Flashback Drop , Flashback Query
    • Using Opatch for Oracle Database Patching

    Cloning Of Oracle Database
    • Cloning using Hot Backup
    • Cloning Using RMAN Duplicate Database

    Performance Management : Understand Problem , Check OS and Automated Reports
    • Understand the Performance Problem Scope
    • Discuss with the affected Users
    • Check dynamic performance views useful in tuning
    • Use dynamic performance views to view statistics and wait events
    • Diagnosis of Server Memory Issues
    • Tracking CPU Utilization , High CPU Consuming Processes and Sessions
    • Use of Graphs and Tools for Problem Diagnosis a the OS Level
    • Create and manage AWR snapshots
    • Generate AWR reports
    • Create snapshot sets and compare periods
    • Generate ADDM reports
    • Log a performance Service Request with Oracle Support

    Performance Management : Tuning the Oracle Database 11G Instance

    • Tuning SGA
    • Tuning the Shared Pool
    • Tuning the Buffer Cache
    • Checkpoint and Redo Tuning
    • Diagnose checkpoint and redo issues
    • Size the redo log file
    • Size the redo log buffer
    • Size the redo log file
    • Diagnose PGA memory issues
    • Size the PGA memory
    • Diagnose temporary space issues
    • Understanding Locks
    • Detect enqueue contention
    • Understanding Latches
    • Diagnose and Resolve Latch Issues

    Oracle Database 11G Performance Management : DBMS_STATS, Detect Fragmentation , SQL Tuning
    • Introduction to cost-based optimization
    • optimizer modes
    • Optimizer parameters
    • Using EXPLAIN PLAN
    • Using “set autotrace”
    • Interpreting EXPLAIN PLAN Output
    • Collecting Schema , table and index statistics (dbms_stats)
    • Checking Statistics
    • Diagnose table fragmentation ie. Candidates for reorg
    • Tracing a Database Session
    • Using TKPROF to analyze a trace File

    Oracle Database 11G Standby
    • Physical and logical Standby
    • Creating a Physical Standby
    • Standby Parameters and Log Shipment
    • Log Monitoring
    • Maximum Protection , Maximum Availability , Maximum Performance
    • Activating a Standby Database
    • Standby Troubleshooting

    Oracle Database 11G Maintenance & Job Scheduling and Processes
    • Monitoring Systems
    • Commonly configured Oracle Database Alerts and Actions to be taken
    Oracle Database 11G related Shell Scripts Sceduling through cron
    • DBMS_JOB and DBMS_SCHEDULER
    • Common Monitoring Problems Encountered and Resolution
    • Change Management Process , Approval Process
    • Ticket Management Process (Severity , Priority , SLAs,Communication Protocol)
    Last edited by Pradeep; 11-20-2012 at 02:10 AM.
    Hemant Fulfagar
    Oracle Administration Architect
    hemant@dbalounge.com
    Skype Name: hemant.fulfagar
    --------------------------------------------------------------------------------------------------------------------------
    DBALounge Provides Oracle DBA Training Services. This includes Online Training, Classroom based Training at Noida (Delhi NCR).
    Students come from Delhi, Gurgaon, Noida, Ghaziabad, Faridabad, Greater Noida .
    Trainings : Oracle Database,10G,11G,RAC,Apps,11i,R12,Fusion Middleware,WebLogic,OID,OBIEE,OAM,OIM,Directory Services,Oracle VM.

  2. #2
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    New Delhi, India
    Posts
    412
    Options Available :

    - Oracle DBA Training at Client Premises (only for Corporate Trainings)
    - Oracle Online Trainings
    - Classroom based Trainings are available at our premises at Noida (Delhi NCR) .
    Last edited by Hemant; 11-19-2012 at 12:41 PM.
    Hemant Fulfagar
    Oracle Administration Architect
    hemant@dbalounge.com
    Skype Name: hemant.fulfagar
    --------------------------------------------------------------------------------------------------------------------------
    DBALounge Provides Oracle DBA Training Services. This includes Online Training, Classroom based Training at Noida (Delhi NCR).
    Students come from Delhi, Gurgaon, Noida, Ghaziabad, Faridabad, Greater Noida .
    Trainings : Oracle Database,10G,11G,RAC,Apps,11i,R12,Fusion Middleware,WebLogic,OID,OBIEE,OAM,OIM,Directory Services,Oracle VM.

+ Reply to Thread

Similar Threads

  1. Oracle Access Manager 11g and SSO with EBS R12 - OAM Training : Course Content
    By Hemant in forum Oracle Administration Training Modules, Online Exam Assessment for OCA, OCP Certfication
    Replies: 1
    Last Post: 08-02-2012, 09:59 AM
  2. Oracle Virtual Machine Training Course Content
    By Hemant in forum Oracle Administration Training Modules, Online Exam Assessment for OCA, OCP Certfication
    Replies: 0
    Last Post: 04-20-2012, 12:36 AM
  3. Oracle Applications DBA R12 Training : Course Content
    By Hemant in forum Oracle Administration Training Modules, Online Exam Assessment for OCA, OCP Certfication
    Replies: 1
    Last Post: 02-22-2012, 02:04 AM
  4. Oracle RAC DBA Training : Real Applications Clusters and ASM 11G R2 Course Content
    By Hemant in forum Oracle Administration Training Modules, Online Exam Assessment for OCA, OCP Certfication
    Replies: 1
    Last Post: 02-22-2012, 02:04 AM
  5. Oracle WebLogic Training : Web Logic 11G Course Content
    By Hemant in forum Oracle Administration Training Modules, Online Exam Assessment for OCA, OCP Certfication
    Replies: 1
    Last Post: 02-22-2012, 02:03 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

DBA Lounge (P) Ltd. deals in Oracle Technologies on Consulting, Resourcing, Corporate Training


Online and corporate training available on Oracle Database 11g, Oracle 11g Real Application Cluster (RAC), Oracle Applications 11i/R12, Oracle Fusion Middleware 11g, Oracle Identity Management-OIM, Oracle Internet Directory 11g-OID, Oracle Business Intelligence Enterprise Edition-OBIEE, Oracle Golden Gate, Oracle Access Management-OAM, Oracle Internet Directory-ODS, Oracle Identity Analytics Architecture-OIA Statistics