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 12c: Administration Workshop
Duration
5 Days
Course
DBOR-957
Available Formats
Classroom Training, Online Training
Course Description
Overview
The overall objective of this course is threefold. First, students learn many of the day-to-day administration tasks required of an Oracle database administrator. Second, it assists in preparation for certification as an Oracle Certified Associated (OCA) database administrator. Finally, it introduces one to many of the administration sub-specialties that one might next pursue. It is increasingly rare for a single database administrator to fulfill all the required responsibilities necessary for management of an enterprise-scale Oracle database installation. Therefore, one may eventually specialize into backup and recovery strategies, database performance tuning, security administration and the like.Whenever appropriate this course demonstrates how an Oracle database installation integrates with its host environment, most commonly a Linux, Unix or MS Windows operating system platform. Extensive examples, workshop exercises and solutions are provided using the SQL command-line, the Enterprise Manager Database Express and the Enterprise Manager Cloud Control interfaces.
Objectives
Audience
- Database administrators
- Application designers and developers
- Web server administrators
- System administrators
- Implementation specialists
- Data center support engineers
- Chief Information Officers (CIO) and other information technology (IT) management professionals
Prerequisites
- DBOR-950 and DBOR-951 Oracle Database 12c: SQL Fundamentals (Levels I & II)
- DBOR-955 Oracle Database 12c: Install & Upgrade Workshop
- DBOR-956 Oracle Database 12c: Architecture & Internals
Topics
- The Database Management Tools
- EM Database Express
- EM Cloud Control
- SQL Developer
- Database Administration Duties
- Database Instance Configurations
- Memory Structures
- Process Structures
- Storage Architecture
- Start & Stop The Database Listener
- About Database Startup/Shutdown
- SYSOPER
- SYSDBA
- Database State & Stages
- Startup With EM Cloud Control
- Startup With SQL*PLUS
- Shutdown With EM Cloud Control
- Shutdown With SQL*PLUS
- Using MS Windows Services
- Oracle NET Services Architecture
- Oracle NET Configuration Assistant
- Oracle NET Manager
- Using EM Cloud Control
- Advanced Network Compression
- Troubleshooting Network Problems
- About Database Diagnostics
- Fault Diagnosability Infrastructure
- Database Instance Health Snapshot
- The Support Workbench
- Proactive Database Health Checks
- Package Diagnostic Data
- Working With The Knowledge Base
- Starter Tablespaces
- Create Tablespace With EM CC
- Create Tablespace With SQL
- Manage Tablespaces With EM CC
- Manage Tablespaces With EM DE
- Manage Tablespaces With SQL
- DROP Tablespace
- ALTER Tablespace
- Managing Temporary Tablespaces
- Temp Tablespace Groups With EM
- Temp Tablespace Groups With SQL
- Default Permanent Tablespaces
- Bigfile Tablespaces
- Managing The SYSAUX Tablespace
- Manage Data Files With EM
- Access Metadata With SQL
- Manage Data Files With SQL
- Manage Temp Files
- Oracle-Managed Files (OMF)
- About Undo Space Management
- Configure Undo Management
- Guarantee Undo Retention
- Monitor Undo Space With SQL
- Use The EM Undo Advisor
- Database Security Principles
- Database System Privileges
- Database Object Privileges
- Super Administrator Roles
- Privilege Analysis
- Create & Manage User Accounts
- Manage Users With EM
- Manage Users With SQL
- CREATE User
- ALTER User
- DROP User
- Grant & Revoke Privileges
- Resource Limits Via Profiles
- ALTER Profile
- DROP Profile
- Password Management Via Profiles
- Role-Based Security Management
- Alter User...Default Role
- Set Role
- Delegating Privilege Authorization
- With Admin Option & System Privileges
- With Grant Option & Object Privileges
- Principle Of Least Privilege Checklist
- Auditing Database Activity
- Traditional Auditing
- Unified Auditing
- Create Audit Policy
- Loader From The Command Line
- Control File Options
- Load Methods
- Loader Express Mode
- Loader From EM
- Manage Directory Objects
- The Data Pump Architecture
- Data Pump Export
- Data Pump Import
- Data Pump Dictionary Views
- Using The EM Cc Interface
- Management Advisory Framework
- Performance Monitoring & AWR
- The SQL Tuning Advisor
- Monitoring Exceptions With Metrics
- About System & User Locks
- Monitor & Manage User Locks
- Monitor Locks With Data Dictionary
- Manage Locks With EM
- Backup & Recovery Structures
- Managing Redo Data
- Configuring For Recoverability
- Instance Recovery
- Recoverability Checklist
Related Courses
-
Introduction to Oracle Database 12c and SQL
DBOR-950- Duration: 3 Days
- Delivery Format: Classroom Training, Online Training
- Price: 2,100.00 USD
-
Oracle Database 12c: SQL II - Intermediate
DBOR-951- Duration: 3 Days
- Delivery Format: Classroom Training, Online Training
- Price: 2,100.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.