title
Please take a moment to fill out this form. We will get back to you as soon as possible.
All fields marked with an asterisk (*) are mandatory.
Oracle Database 11g R2 Administration I
Duration
5 Days
Course
DBOR-923
Available Formats
Classroom Training, Online Training
Course Description
Overview
Administration of the Oracle database management system (DBMS) software environment and of the server systems on which the DBMS runs is one of the primary tasks required of database administrators. While it is true that the hardware and software platforms on which the DBMS runs have become increasingly complex, as has the database software itself, the capabilities provided by the Oracle database have correspondingly become more sophisticated.Objectives
The overall objective of this training course is to allow the student to gain the skills necessary for day-to-day administration of an Oracle database. These training materials are the starting point for Oracle database administrators and sets the foundation for advanced administrator training and certification.
Major tasks to be considered within this course are:
- Configuration of the Linux and MS Windows operating systems in anticipation of a database installation
- Server Class installation of the Oracle 11g R2 Enterprise Edition database
- Verification of a valid database installation
- Database administrator interface options, including the use of Enterprise Manager, command-line SQL*Plus, and terminal console SSH
- Database deinstallation
- Online software patching
- Startup and shutdown of database services and related software components
- Super administrator authentication options
- An in-depth exploration of the database architecture, including memory, process and data structures, and the management of those structures.
- Management of database files.
- Specialized facilities intended to maximize performance of enterprise-scale transactional applications, such as the shared SQL and PL/SQL cache, the Result Cache, the database buffer cache, and other similar components.
- Management of security policies and procedures, including administration of user accounts, roles, privileges and profiles.
- Utilization of advanced self-tuning and self-management capabilities, including the use of Oracle-Managed Files, database Advisors and other components of the Management Framework.
- Performance monitoring, problem troubleshooting, and resolving lock and conflict issues.
- Using the Oracle Enterprise Manager and SQL interfaces for administration tasks.
- Control over database support services, including the Database Control, Oracle Net and others.
- A primer on backup and recovery structures and strategies.
- Operating system-specific considerations for various platforms, especially Linux and MS Windows Server.
Audience
- Database administrators
- Web server administrators
- System administrators
- Implementation specialists
- Data center support engineers
- Senior application designers and developers
Prerequisites
-
Many students taking this course have familiarity with system administration and administration of other non-Oracle databases, and this is helpful though not mandatory. Specific course prerequisites for this course are these Sideris titles:
- DBOR-917 ORACLE DATABASE 11G R2: SQL FUNDAMENTALS - COMPLETE LIBRARY
- DBOR-920 ORACLE DATABASE 11G R2: PROGRAM WITH PL/SQL - COMPLETE LIBRARY
Topics
- IDENTIFY system requirements
- OPTIMAL flexible architecture (OFA)
- ORACLE_BASE
- ORACLE_HOME
- CONFIGURE linux installation
- CONFIGURE MS windows installation
- PREREQUISITE checs & fixup utility
- MORE about the installation
- START the installation
- DESKTOP class installation 11g r2
- SERVER class installation 11g r2
- POST-installation configuration
- ACCESSING the EM database control
- USING the EM interface
- USING sql*plus
- USING em sql worksheet
- USING ssh
- DATABASE upgrade
- NETCA
- DBUA
- ONLINE patching
- ORACLE deinstaller
- STARTING & stopping database control
- STARTING & stopping the listener
- STARTING & stopping the database
- SYSBDA
- THE oracle enterprise architecture
- GENERAL database architecture
- V$VERSION
- MORE about database instances
- USING V$SGA_dynamic_components
- ABOUT the pga
- MANAGING memory
- INSTANCE background processes
- SQL execution processes
- USING V$SESSION
- CREATE a new database
- CONFIGURE an existing database
- DROP a database
- MANAGE DBCA templates
- MANUALLY create a database
- MORE about the database files
- TRANSPARENT data encryption
- MANAGING TDE
- IMPLEMETNING column encryption
- ABOUT tablespaces
- TABLESPACE management
- AUTOEXTEND options
- DROP tablespace
- ALTER tablespace
- 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
- MANAGING data files
- MANAGING temp files
- ENABLE oracle-managed files (OMF)
- ABOUT undo space management
- CONFIGURE undo management
- UNDO_management
- UNDO_tablespace
- UNDO_retention
- GUARENTEE undo retention
- MONITOR undo space
- USE the undo advisor
- 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 & v$dispatcher_config
- V$QUEUE
- DATABASE system privileges
- DATABASE object privileges
- AUDITING of database activity
- AUDIT_trail parameter
- ENHANCED default security settings
- CREATE & managed database accounts
- GRANT & 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 & system privileges
- WITH grant option & object privileges
- ALTER user…default role
- SET role
- ENHANCED default security settings
- SEC_case_sensitive_logon setting
- LOADER concepts
- CONTROL file options
- LOAD methods
- USING the EM interface
- MANAGE directory objects
- ABOUT the data pump architecture
- DATA pump import
- DATA pump data dictionary views
- USING the EM interface
- MANAGEMENT & advisory framework
- MANAGE awr
- ADDM
- USE metrics & alert thresholds
- AUTOMATIC maintenance tasks
- ABOUT latches & locks
- MANAGE & monitor latches
- V$LOCK
- V$LOCKED_OBJECT
- V$SESSION
- V$SESSION_WAIT
- DBA_BLOCKERS & dba_waiters
- DBA_DMI_LOCKS & dba_ddl_locks
- DML_LOCKS
- ABOUT backup & recovery structures
- MANAGING redo data
- MANAGING archival data
- AUTOMATIC crash recovery
- CREATING a basic backup strategy
Related Courses
-
Oracle Database 11g R2 SQL Complete
DBOR-917- Duration: 5 Days
- Delivery Format: Classroom Training, Online Training
- Price: 3,500.00 USD
-
Oracle Database 11g: Advanced PL/SQL Programming & Tuning
DBOR-922- Duration: 5 Days
- Delivery Format: Classroom Training, Online Training
- Price: 3,500.00 USD
Self-Paced Training Info
Learn at your own pace with anytime, anywhere training
- Same in-demand topics as instructor-led public and private classes.
- Standalone learning or supplemental reinforcement.
- e-Learning content varies by course and technology.
- View the Self-Paced version of this outline and what is included in the SPVC course.
- Learn more about e-Learning
Course Added To Shopping Cart
bla
bla
bla
bla
bla
bla
Self-Paced Training Terms & Conditions
??spvc-wbt-warning??
Exam Terms & Conditions
??exam-warning??
??group-training-form-area??
??how-can-we-help-you-area??
??personalized-form-area??
??request-quote-area??
Sorry, there are no classes that meet your criteria.
Please contact us to schedule a class.
STOP! Before You Leave
Save 0% on this course!
Take advantage of our online-only offer & save 0% on any course !
Promo Code skip0 will be applied to your registration
Nothing yet
Purchase Information
??elearning-coursenumber?? ??coursename??
View Cart
title
Please take a moment to fill out this form. We will get back to you as soon as possible.
All fields marked with an asterisk (*) are mandatory.