Oracle 11g Administration I

Oracle 11g Administration I


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



  • 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


No prior experience is presumed.


All students receive comprehensive courseware and a related textbook.


  • A complete installation of Oracle Enterprise Edition 11g or 11g R2
  • Oracle SQL Developer
  • For classes delivered online, all participants need either dual monitors or a separate device logged into the online session so that they can do their work on one screen and watch the instructor on the other. A separate computer connected to a projector or large screen TV would be another way for students to see the instructor’s screen simultaneously with working on their own.


  • Introduction
  • Configuring The Server For Installation
    • Identify System Requirements
    • Optimal Flexible Architecture (Ofa)
    • Oracle_Base
    • Oracle_Home
    • Configure Linux Installation
    • Configure Ms Windows Installation
    • Prerequisite Checks and Fixup Utility
  • Enterprise Edition Installation
    • More About The Installation
    • Start The Installation
    • Desktop Class Installation 11g R2
    • Server Class Installation 11g R2
    • Post-Installation Configuration
  • Verify The Installation
    • Accessing The Em Database Control
    • Using The Em Interface
    • Using Sql*Plus
    • Using Em Sql Worksheet
    • Using Ssh
  • Upgrade, Deinstallation and Patching
    • Database Upgrade
    • Netca
    • Dbua
    • Online Patching
    • Oracle Deinstaller
  • Manually Starting and Stopping Database Services
    • Starting and Stopping Database Control
    • Starting and Stopping The Listener
    • Starting and Stopping The Database
    • Sysdba
  • Exploring The Oracle Database Architecture: General
    • The Oracle Enterprise Architecture
    • General Database Architecture
    • V$Version
  • Exploring The Oracle Database Architecture: Instance Memory
    • More About Database Instances
    • Using V$Sga_Dynamic_Components
    • About The Pga
    • Managing Memory
  • Exploring The Oracle Database Architecture: Instance Processes
    • Instance Background Processes
    • Sql Execution Processes
    • Using V$Session
  • Creating An Oracle Database
    • Create A New Database
    • Configure An Existing Database
    • Drop A Database
    • Manage Dbca Templates
    • Manually Create A Database
    • More About The Database Files
  • Enabling Transparent Data Encryption
    • Transparent Data Encryption
    • Managing Tde
    • Implementing Column Encryption
  • Manage Database Storage Structures: Tablespaces
    • About Tablespaces
    • Tablespace Management
    • Autoextend Options
    • Drop Tablespace
    • Alter Tablespace
  • Manage Database Storage Structures: Advanced Tablespaces
    • More About Temporary Tablespaces
    • Using V$Sort_Segment
    • About Temporary Tablespace Groups
    • More About Permanent Tablespaces
    • About Database_Properties
    • More About Bigfile Tablespaces
    • More About The Sysaux Tablespace
  • Manage Database Storage Structures: Data Files and Temp Files
    • Managing Data Files
    • Managing Temp Files
    • Enable Oracle-Managed Files (Omf)
  • Managing Undo Data
    • About Undo Space Management
    • Configure Undo Management
    • Undo_Management
    • Undo_Tablespace
    • Undo_Retention
    • Guarantee Undo Retention
    • Monitor Undo Space
    • Use The Undo Advisor
  • Network Environment: Oracle Net Services
    • Oracle Net Services Architecture
    • Oracle Net Configuration Assistant
    • Oracle Net Manager
    • Configuration Using Em
    • Troubleshooting Network Problems
    • Countering Database Attacks
  • Network Environment: Oracle Shared Servers
    • Shared Servers Architecture
    • Configure Shared Servers
    • Monitor Shared Servers
    • V$Shared_Server
    • V$Shared_Server_Monitor
    • V$Session
    • V$Circuit
    • V$Dispatcher and V$Dispatcher_Config
    • V$Queue
  • Security: Implementing Database Security
    • Database System Privileges
    • Database Object Privileges
    • Auditing Of Database Activity
    • Audit_Trail Parameter
    • Enhanced Default Security Settings
  • Security: Administering User Security
    • Create and Manage Database Accounts
    • Grant and Revoke Database Privileges
    • Resource Limits Via Profiles
    • Alter Profile
    • Drop Profile
    • Password Management Via Profiles
    • About Role-Based Security
    • With Admin Option
    • With Admin Option and System Privileges
    • With Grant Option and Object Privileges
    • Alter User…Default Role
    • Set Role
    • Enhanced Default Security Settings
    • Sec_Case_Sensitive_Logon Setting
  • Moving Data: Sql Loader
    • Loader Concepts
    • Control File Options
    • Load Methods
    • Using The Em Interface
  • Moving Data: Export and Import
    • Manage Directory Objects
    • About The Data Pump Architecture
    • Data Pump Import
    • Data Pump Data Dictionary Views
    • Using The Em Interface
  • Database Maintenance and Performance Monitoring
    • Management and Advisory Framework
    • Manage Awr
    • Addm
    • Use Metrics and Alert Thresholds
    • Automatic Maintenance Tasks
  • Managing Concurrency and Locks
    • About Latches and Locks
    • Manage and Monitor Latches
    • V$Lock
    • V$Locked_Object
    • V$Session
    • V$Session_Wait
    • Dba_Blockers and Dba_Waiters
    • Dba_Dml_Locks and Dba_Ddl_Locks
    • Dml_Locks
  • Backup and Recovery Concepts and Configuration
    • About Backup and Recovery Structures
    • Managing Redo Data
    • Managing Archival Data
    • Automatic Crash Recovery

Send a Comment

Your email address will not be published.


+91 9376007676  


Oracle 11g Administration I

1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)
  • Course No : ORC-204
  •  Theory : 40%
  •  Lab : 60%
  • Duration : 30 hours
Scroll Up
Skip to toolbar