Service Times: 9am and 10:30am
6399 North Wells Road, Bigtownville, CO 32748
  • Loading

ORACLE 11g Administration Part I & II

Email Print Export to ical format


Academy of Management & Science (AMS)
House # 89/E, Road # 13/C, Block # E, Banani, Dhaka 1213, Bangladesh
Telephone: +880 (2) 9891190, +880 (2) 8836875, Cell No: (88) 01680878839, (88) 01193070284

Resource Person

Mr Tapan Chandra Das, a renowned professional having 10+ years of expertise in Database Administration, Database Design, ERP, Software Development, Project Implementation & Planning, Database Analysis & PL/SQL.

A few list of his major Training and Certifications includes:

  1. Oracle Real Application Cluster 11g R2
  2. Oracle 11g Administration 1 and 2 in DBA track.
  3. OCP certification in Oracle 10g dba.

Key Database Experiences:

  • Oracle 10g/11g: Database administration like performance tuning, tables pace management, Job scheduling, Enterprise Manager database console and grid control, Database Auditing and data mining, Oracle gateway for Sql Server, RAC, ASM.
  • Sql Server 2005/2008: Database administration like filegroup management, performance tuning, Advance configure options, Communicate with the OS, Job Scheduling, Backup and recovery management, linked server, ETL.

Backup and Recovery Experiences:
Using HP-UX data protector 6.0 to take filesystem and Database(Oracle) Backup and Recover at the earliest in case of failure.

Presently he is working as Manager, Billing at Novotel and his major responsibility is to He started his career as software engineer at Leads Corporation & then he joined at Novotel as senior software engineer. In his tenure at Novotel he accomplished & leads several divisions & presently working as Manager, Billing.
His major responsibility is to improve billing processes and standards, Technical planning and design of expanded billing needs

His major accomplishment in career as follows:

  1. He was the architectural team member & lead programmer of LEADS ERP project using Oracle Developer Suite and Databse 10g.
  2. He developed Broker Back Office Automation Software using Visual Studio 2005, Dot Net Framework 2.0 and C# Dot Net. For Leads Corporation
  3. CMMI Implementation in Auditing Section for Leads Corporation
  4. Develop In house billing management software to manage daily billing activities easily for NOVOTEL
  5. He completed the project of automation of CDR parsing using SQL Server, Altova XML, BAT and Serving XML for NOVOTEL
  6. Create CDR parsing and mediation automation Technology using Oracle.
  7. Billing Management Website Development using Visual Studio 2010, Dot Net Framework 4.0, Oracle ODP Dot Net, Visual Source Safe, Crystal Report.
  8. Configure Radius Server to monitor concurrent calls and Prepaid Billing with GENBAND S3 switch
  9. Administer and configure new functionality of Interconnect Billing Software developed by INTEC.
  10. Reconciliation activities related to Billing.

A few of his other expert domains:

  1. Languages: C# and, HTML, XML, PL/SQL, Java Scripting, OS scripting.
  2. Technology: Dot Net Framework, Web Services, MVC, Ajax, ODP Dot Net.
  3. Tools: Visual Studio 2005/2008/2010, Visual Sourcesafe, Toad, Oracle Developer Suite, IIS 6.0/7.0,
  4. Microsoft Project, Microsoft Visio.

Design Experiences:

  1. ERP Modules(HRM, Payroll, Accounting, Security, Audit Trail, Procurement and Inventory, Sales Forecasting).
  2. UML Design.
  3. Visio Diagrams( Network Diagram, Planning Diagram).
  4. Report Development Experiences:
  5. Crystal Report 10/11, Dynamic Reporting through Dot Net Crystal Report Viewer.
  6. Oracle Report Developer.
  7. Excel Reporting Technique.
  8. Sharepoint Project Management.

Workshop Details

Oracle 11g training/course in Dhaka, Bangladesh
Academy of Management & Science (AMS)
Location: House # 89/E, Road # 13/C, Block # E, Banani, Dhaka-1213, Bangladesh
Telephone: +880-2-9891190
+880 (2) 8836875
Cell No: (88) 01193070284
(88) 01680878839




ORACLE 11g Administration Part I & II

Course Code:

ORC-204 & ORC-206


This Oracle 11g administration training course teaches attendees the skills necessary for day-to-day administration of Oracle® 11g.


No prior experience is presumed.This course is 60% hands-on, 40% discussion, with the longest discussion segments lasting 20 minutes.


80 Housrs

Course Objectives:

All attendees will learn how to:

  • Configure the Linux and MS Windows operating systems in anticipation of a database installation
  • Install Oracle 11g R2 Enterprise Edition database
  • Verify a valid database installation
  • Use database administrator interface options
  • Uninstall the database
  • Patch online software
  • Startup and shutdown database services and related software components
  • Use super administrator authentication options
  • Explore the database architecture, including memory, process and data structures, and the management of those structures
  • Manage database files.
  • Use specialized facilities intended to maximize performance of enterprise-scale transactional applications
  • Manage security policies and procedures, including administration of user accounts, roles, privileges and profiles
  • Use advanced self-tuning and self-management capabilities
  • Monitor preformance, troubleshoot problems, and resolve lock and conflict issues
  • Use the Oracle Enterprise Manager and SQL interfaces for administration tasks
  • Gain gontrol over database support services, including the Database Control, Oracle Net and others
  • Backup and recover
  • Operate system-specific considerations for various platforms, especially Linux and MS Windows

Course Details:

Administration Part-I

  • Introduction
  • Configuring The Server For Installation

o Identify System Requirements
o Optimal Flexible Architecture (Ofa)
o Oracle_Base
o Oracle_Home
o Configure Linux Installation
o Configure Ms Windows Installation
o Prerequisite Checks and Fixup Utility

  • Enterprise Edition Installation

o More About The Installation
o Start The Installation
o Desktop Class Installation 11g R2
o Server Class Installation 11g R2
o Post-Installation Configuration

  • Verify The Installation 

o Accessing The Em Database Control
o Using The Em Interface
o Using Sql*Plus
o Using Em Sql Worksheet
o Using Ssh

  • Upgrade, Deinstallation and Patching

o Database Upgrade
o Netca
o Dbua
o Online Patching
o Oracle Deinstaller

  • Manually Starting and Stopping Database Services 

o Starting and Stopping Database Control
o Starting and Stopping The Listener
o Starting and Stopping The Database
o Sysdba

  • Exploring The Oracle Database Architecture: General

o The Oracle Enterprise Architecture
o General Database Architecture
o V$Version

  • Exploring The Oracle Database Architecture: Instance Memory 

o More About Database Instances
o Using V$Sga_Dynamic_Components
o About The Pga
o Managing Memory

  • Exploring The Oracle Database Architecture: Instance Processes 

o Instance Background Processes
o Sql Execution Processes
o Using V$Session

  • Creating An Oracle Database 

o Create A New Database
o Configure An Existing Database
o Drop A Database
o Manage Dbca Templates
o Manually Create A Database
o More About The Database Files

  • Enabling Transparent Data Encryption

o Transparent Data Encryption
o Managing Tde
o Implementing Column Encryption

  • Manage Database Storage Structures: Tablespaces 

o About Tablespaces
o Tablespace Management
o Autoextend Options
o Drop Tablespace
o Alter Tablespace

  • Manage Database Storage Structures: Advanced Tablespaces

o More About Temporary Tablespaces
o Using V$Sort_Segment
o About Temporary Tablespace Groups
o More About Permanent Tablespaces
o About Database_Properties
o More About Bigfile Tablespaces
o More About The Sysaux Tablespace

  • Manage Database Storage Structures: Data Files and Temp Files 

o Managing Data Files
o Managing Temp Files
o Enable Oracle-Managed Files (Omf)

  • Managing Undo Data

o About Undo Space Management
o Configure Undo Management
o Undo_Management
o Undo_Tablespace
o Undo_Retention
o Guarantee Undo Retention
o Monitor Undo Space
o Use The Undo Advisor

  • Network Environment: Oracle Net Services 

o Oracle Net Services Architecture
o Oracle Net Configuration Assistant
o Oracle Net Manager
o Configuration Using Em
o Troubleshooting Network Problems
o Countering Database Attacks

  • Network Environment: Oracle Shared Servers

o Shared Servers Architecture
o Configure Shared Servers
o Monitor Shared Servers
o V$Shared_Server
o V$Shared_Server_Monitor
o V$Session
o V$Circuit
o V$Dispatcher and V$Dispatcher_Config
o V$Queue

  • Security: Implementing Database Security 

o Database System Privileges
o Database Object Privileges
o Auditing Of Database Activity
o Audit_Trail Parameter
o Enhanced Default Security Settings

  • Security: Administering User Security

o Create and Manage Database Accounts
o Grant and Revoke Database Privileges
o Resource Limits Via Profiles
o Alter Profile
o Drop Profile
o Password Management Via Profiles
o About Role-Based Security
o With Admin Option
o With Admin Option and System Privileges
o With Grant Option and Object Privileges
o Alter User...Default Role
o Set Role
o Enhanced Default Security Settings
o Sec_Case_Sensitive_Logon Setting

  • Moving Data: Sql Loader 

o Loader Concepts
o Control File Options
o Load Methods
o Using The Em Interface

  • Moving Data: Export and Import

o Manage Directory Objects
o About The Data Pump Architecture
o Data Pump Import
o Data Pump Data Dictionary Views
o Using The Em Interface

  • Database Maintenance and Performance Monitoring 

o Management and Advisory Framework
o Manage Awr
o Addm
o Use Metrics and Alert Thresholds
o Automatic Maintenance Tasks

  • Managing Concurrency and Locks

o About Latches and Locks
o Manage and Monitor Latches
o V$Lock
o V$Locked_Object
o V$Session
o V$Session_Wait
o Dba_Blockers and Dba_Waiters
o Dba_Dml_Locks and Dba_Ddl_Locks
o Dml_Locks

  • Backup and Recovery Concepts and Configuration 

o About Backup and Recovery Structures
o Managing Redo Data
o Managing Archival Data
o Automatic Crash Recovery

  • Conclusion

Administration Part II

  • Managing Memory

o About Manual Memory Management
o Automatic Memory Management
o Memory_Target
o Memory_Max_Target
o Sga_Target
o Sga_Max_Size
o Workarea_Size_Policy & Pga_Aggregate_Target
o Using EM & The Memory Advisors
o Monitor In Memory Access Mode

  • Managing Storage & The Segment Advisor

o Monitor Tablespaces
o About Resumable Space Allocation
o Table Storage Management
o Pctfree Illustrated
o Use The Segment Advisor
o Using The Shrink Space Option
o Cascade To Dependent Objects
o Optionally Call Delete_Task()

  • Managing Resources

o Database Resource Manager Architecture
o Consumer Groups
o Resource Plans
o Automatic & Adaptive Consumer Group Mapping
o Activating Plans
o Monitoring Resource Allocation
o Explicit Consumer Group Switching

  • Automating Tasks With The Scheduler (Basic)

o Scheduler Architecture
o Rac Environment
o Manage Programs
o Manage Schedules
o Manage Jobs

  • Automating Tasks With The Scheduler (Advanced)

o Manage Job Classes
o Manage Windows & Window Groups
o Manage Chains
o About Events & The Scheduler

  • Globalization

o Globalization Settings
o Nls_Lang
o Nls_Language & Nls_Territory
o Date & Time Localization
o Linguistic Indexes
o About Locale Builder

  • Diagnosing Database Problems

o About The Fault Diagnosability Infrastructure
o ADR Highlights From EM
o Using The Alert Log
o About The Trace Files
o Database Instance Health Snapshot
o Using The Support Workbench
o Enable Oracle Configuration Manager

  • Automatic Storage Management

o ASM & The Broader Database Architecture
o Creating The ASM Instance
o Administering The ASM Instance
o Sysasm Super Administrator
o ASM Storage Parameters
o Using DBCA
o Using ASMcmd
o Configuring Databases For ASM Storage
o ASM Migration Using EM

  • Recovery Concepts

o About The Backup & Recovery Structures
o Managing Redo Data
o Is Log_Buffer Large Enough?
o What V$Log Reveals
o What V$Log_History Reveals
o What V$Logfile Reveals
o What V$Archived_Log Reveals
o Managing Archived Redo Data
o Archivelog Status
o Creating A Foundation For Sound Recovery

  • Oracle Flashback Technology

o About Flashback Technology
o Flashback Query
o Select...As Of Timestamp
o Select...As Of SCN
o Using Dbms_Flashback()
o Configuring Undo Management For Flashback
o Undo_Retention
o Flashback Table
o Flashback Drop
o Flashback Versions Query
o Flashback Transaction Query
o Flashback Transaction Backout

  • Flashback Database

o About Flashback Database
o Configuring The Flash Recovery Area
o More About Db_Recovery_File_Dest
o Performing Database Flashback
o Monitoring Flashback Performance
o Flashback Database Considerations
o Configure Flashback Data Archive

  • Instance Recovery

o About Instance Recovery
o Smon Process & Instance Recovery
o Pmon Process & Process Recovery
o Instance Recovery Parallelism
o Changing Recovery_Parallelism
o Mttr Advisor & Tuning Checkpoints
o Log_Checkpoints_To_Alert
o Redo Logfile Size Advisor
o Fast-Start On-Demand Parallelism

  • Configuring RMAN

o RMAN Architecture
o RMAN Sample Backup Session
o Launch & Use RMAN
o Configure RMAN Settings
o Allocate RMAN Channels

  • Backup With RMAN

o About Backup File Types
o Performing Full Backups
o Performing Incremental Backups
o Establishing A Backup Retention Policy
o Generate Reports
o Report Unrecoverable
o Report Need Backup
o List Incarnation
o Validate Backup Data Integrity

  • RMAN Management With EM

o Monitoring The Flash Recovery Area
o The EM Interface To RMAN
o Scheduling RMAN Backups
o Using The Oracle-Suggested Backup Strategy
o Manage Current Backups
o Backup Reports
o Manage Restore Points

  • User-Managed Recovery Operations

o Recovery Concepts
o Recover Temporary Tablespaces
o Recover Read-Only Tablespaces
o Recover Index Tablespaces
o Recover Redo Log Group Member
o Recreate The Password File

  • Recovery With RMAN

o Complete Media Recovery
o Incomplete Media Recovery
o Recovery Using EM

  • Using The RMAN Recovery Catalog

o Configuring The Recovery Catalog
o Using A Virtual Private Catalog

  • Advanced RMAN Capabilities

o Backup Set Encryption
o RMAN Duplicate Database

  • Conclusion

Training Calendar

<<  February  2018  >>
 S  M  T  W  T  F  S 
      1  2  3
  4  5  6  7  8  910


AMS Campus Facilities

  • Two Air conditioned seminar halls with projector & audio system [Maximum Capacity up to 50 persons] including video recording capacity.
  • Two different PC Labs (Air conditioned)
  • Centralized server
  • Internet / WIFI facilities
  • Practice facilities in LABS
  • Online Exam Centre
  • Cafeteria & Own cook facility
  • Large lobby with natural surroundings
  • Huge Parking Space
  • Waiting Lounge
  • Distance education facilities
  • Printer, Scanner etc logistics facilities
  • Special Guest Room
  • Registration Booth Arrangement Space
  • 3 Star Accommodation arrangements for foreign guests on demand in walking distance from the center.
    ………and many more

Contact AMS

Academy of Management & Science (AMS)
House #450, Road # 31, New DOHS,Mohakhali, Dhaka-1206, Bangladesh
Cell No: (88) 01616004108
Email: This email address is being protected from spambots. You need JavaScript enabled to view it.

Academy Location