|
|
|
|
|
|
Oracle Training Overview
This Oracle 11g courseware training guide book will allow the student to gain the skills necessary for day-to-day administration of an Oracle database. 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.
Oracle Training Objectives
- 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.
Oracle Training Audience
The primary audiences for this course are:
- Database administrators
- Web server administrators
- System administrators
- Implementation specialists
- Data center support engineers
- Senior application designers and developers
Oracle Training 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 titles:
- ORACLE DATABASE 11g R2: INTRODUCTION TO SQL – COMPLETE LIBRARY
- ORACLE DATABASE 11g R2: PROGRAM WITH PL/SQL – COMPLETE LIBRARY
Suggested Next Courses
This course should be considered the first part of the integrated database administrator curriculum. Therefore, in the not-too-distant future one should proceed to the follow-up course
- ORACLE DATABASE 11g R2: ADMINISTRATION II.
Oracle Training Course duration
5 Days
Oracle Training Course outline
INSTALLATION & UPGRADE VOLUME
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 & 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 & PATCHING
- DATABASE UPGRADE
- NETCA
- DBUA
- ONLINE PATCHING
- ORACLE DEINSTALLER
VOLUME A:
MANUALLY STARTING & STOPPING DATABASE SERVICES
- STARTING & STOPPING DATABASE CONTROL
- STARTING & STOPPING THE LISTENER
- STARTING & 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 &
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
VOLUME B:
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 & 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 & MANAGE 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
MOVING DATA: SQL LOADER
- LOADER CONCEPTS
- CONTROL FILE OPTIONS
- LOAD METHODS
- USING THE EM INTERFACE
MOVING DATA: EXPORT & IMPORT
- MANAGE DIRECTORY OBJECTS
- ABOUT THE DATA PUMP ARCHITECTURE
- DATA PUMP IMPORT
- DATA PUMP DATA DICTIONARY VIEWS
- USING THE EM INTERFAC
DATABASE MAINTENANCE & PERFORMANCE
MONITORING
- MANAGEMENT & ADVISORY FRAMEWORK
- MANAGE AWR
- ADDM
- USE METRICS & ALERT THRESHOLDS
- AUTOMATIC MAINTENANCE TASKS
MANAGING CONCURRENCY & LOCKS
- ABOUT LATCHES & LOCKS
- MANAGE & MONITOR LATCHES
- V$LOCK
- V$LOCKED_OBJECT
- V$SESSION
- V$SESSION_WAIT
- DBA_BLOCKERS & DBA_WAITERS
- DBA_DML_LOCKS & DBA_DDL_LOCKS
- DML_LOCKS
BACKUP & RECOVERY CONCEPTS & CONFIGURATION
- ABOUT BACKUP & RECOVERY STRUCTURES
- MANAGING REDO DATA
- MANAGING ARCHIVAL DATA
- AUTOMATIC CRASH RECOVERY
- CREATING A BASIC BACKUP STRATEGY
|
|
|
|
|
