Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

Oracle Database Administration Training

No Reviews Yet

Course type: Online Instructor led Course

Platform: gotomeeting

Course ID: 30425

Course type: Online Instructor led Course

Platform: gotomeeting

Students Interested 0 (Seats Left 0)

No Reviews Yet

About the Course

Course Description:


This Course covers both basic and advanced concepts with the core elements of Oracle 11g/12c database administration.


Architecture & Configuration
Overview of Oracle DBA tasks
Oracle as a flexible, complex & robust RDBMS
The evolution of hardware and the relation to Oracle
Different DBA job roles(VP of DBA, developer DBA,production DBA, database babysitter)
The changing job role of the Oracle DBA
Environment management (network, CPU, disk and RAM)
Instance management (managing SGA regions)
Oracle table and index management
Instance Architecture
Instance vs. database
Components of an instance
Creating the OFA file structure ($DBA, bdump, udump, pfile)
Oracle Instance Internals
SGA vs. PGA
Background processes
Interfaces with server and disk I/O subsystem
Using SQL*Plus for DBA management
Connecting and executing SQL
Using the “as sysdba” syntax
Overview of SQL*Plus DBA commands (startup, etc.)
Control file, UNDO and REDO management
Explaining the use of control files
Listing the Contents of the control File
File locations for control Files
Obtaining Control File Information
Listing control file contents
Displaying and Creating Undo segments
Altering Undo Segments
Determining the Number and Size of Undo segments
Understanding flashback technology
Troubleshooting Undo – snapshot too old
Redo log concepts for recovery
Online redo log (log_buffer) online redo logs and archived redo logs
Oracle ARCH and LGWR background processes
Redo log dictionary queries


Redo log switch frequency and performance
Multiplexing the Online Redo Log Files
Archiving the Oracle Redo Logs
Recovery using the redo log files
User and privilege management
Creating New Database Users
Using pre-spawned Oracle connections
Auditing User activity
Identifying System and Object Privileges
Granting and Revoking Privileges
Creating and Modifying Roles
Displaying user security Information from the Data Dictionary
Oracle database management
Overview of instance management
Parameter files (init.ora, listener.ora, tnsnames.ora)
Rules for sizing SGA components
Automated Oracle memory management (AMM)
Initialization file management
Creating the init.ora file
Using spfile
Displaying init.ora values with vparameter
Oracle*Net configuration
Creating the listener.ora file
Creating the tnsnames.ora file
Data buffer configuration & sizing
Inside the Oracle data buffers
Using the KEEP pool
Monitoring buffer effectiveness
Using multiple blocksizes (multiple buffer pools)
Shared pool and PGA configuration & Sizing
Shared pool concepts and components
Understanding the library cache
Relieving shared pool contention
Overview of PGA for sorting and hash joins
Using sort_area_size, hash_area_size and pga_aggregate_target
Troubleshooting network connectivity
Verifying network connectivity with ping and tnsping
Testing database links
Oracle object management
Oracle tables, views and materialized views
Types of Oracle tables (regular, IOT, sorted hash clusters, nested tables)
Oracle Views
Oracle materialized views
Oracle indexes
Types of Oracle indexes (b-tree, bitmap, bitmap join index)


Oracle Database Architecture


Planning for an Oracle database creation.
Creating an Oracle database using the MANUAL method.
Creating an Oracle database using the Graphical Tool (Database Configuration Assistant).
Startup and Shutdown of a database.
Components of an Oracle database and detailed architecture.
Advance Startup and Shutdown Scenarios.
Oracle database memory and process architecture.


Database storage


Tablespaces and allocation types.
Create tablespaces.
Create datafiles with fixed size and autoextend option.
Control files and producing a trace output to view its contents.
How to rename datafiles in a controlfile.
Redolog File architecture and best practices.
Enabling Archivelog mode for a database with automatic archiving.
Temporary tablespaces and temporary tablespace groups (11g R2 new feature).


Oracle Networking


Introduction.
Oracle listener configuration (Dynamic and Static Listeners).
Dynamic Service Registration and Naming Methods configuration in sqlnet.ora.
Oracle database connections from other computers.
Using Oracle netca (Network Configuration Assistant) for network configuration file tnsnames.ora.
Oracle listener administration and TNS_ADMIN environment variable.
Database Links.


User Administration and Security


How to create database users.
How to set database profile limits for a user.
Unlocking a user account and enabling password management.
Oracle database authorization using object and system privileges.
Oracle database authorization using database roles.
How to audit Oracle database connections in standard and XML mode.
How to audit Oracle DBA commands (SYS Operations).
How to schedule Oracle database jobs using DBMS_SCHEDULER package.


Used Managed (Manual) Backup and Recovery


Introduction and planning for a robust Backup and Recovery Strategy.
How to take an Oracle database backup in offline mode (COLD BACKUP).
Hot to take an Oracle database backup in online mode (HOT BACKUP).
How to clone a database using Cold Backup.
How to clone a database using Hot Backup.
How to recreate source database from a user-managed backup (Media failure scenario).


RMAN Backup and Recovery


Advantages of RMAN method compared to manual method.
Database backup using RMAN in normal and compressed mode.
Oracle database backup metadata.
Database backup using Recovery catalog (RMAN Catalog).
Querying the RMAN metadata.
How to clone a database using RMAN duplicate (11g R2 new feature: Backup based duplication).
How to restore and recover a database using its backup in the event of a media failure.
Oracle database backup retention policies and backups to Tape/offsite.
Fast Recovery Area for better management of backups and archive log files.


Oracle database upgrades


Introduction to Oracle versions and how to understand a version.
How to upgrade from a previous release to Oracle 12c.
How to upgrade from one patchset to another patchset within a release. What is slip-streaming ?
What are one-off/interim patches.
What are quarterly CPU patches (Cumulative Patch Updates).
Learn about Oracle Interim Patch Installer (OPATCH).
Upgrade a database using dbua (database upgrade assistant) GUI tool.


Oracle 12c database creation (non-CDB) and new features


How to create a non-CDB (traditional database) using Oracle 12c dbca utility.
Learn about the improvements in dbca utility.
How to configure and use Oracle Enterprise Manager Database Express web based tool.


Oracle 12c’s Multitenant Architecture


Understanding Container database (CDB) and Pluggable Database (PDB) in Oracle 12c release.
How Oracle 12c CDB,PDB instance architecture differs from Oracle 11g,10g instance architectures.
How to create a non-CDB database in Oracle 12c (Traditional database).
How to create a CDB database in 12c (using the multitenant feature).
How to move (plug) the non-CDB database into the CDB database as a pluggable database (PDB).
Real world Business use cases for using Oracle 12c Multitenant architecture.


Oracle Utilities


Oracle database logical backups.
Business use cases of logical backups compared to physical backups.
Data Pump Export modes.
Data Pump Import to import data from an export backup.
Advanced features in Oracle Data Pump Export.


Performance Tuning


How to handle performance issues in the real world.
V$ views for performance monitoring and analysis.
How to size the Oracle database memory structures for optimal performance.
Oracle database wait events.
Explain Oracle UNDO management internals and sizing.
Explain Oracle TEMP space internals and sizing.
SQL Query tracing using TKPROF.
Database wide tracing for Oracle Errors (Event Tracing).
Index Monitoring and internals of index maintenance by Oracle.
Statistics data collection for Oracle database optimizer.

Date and Time

Not decided yet.

About the Trainer

Kapil Kale picture

Avg Rating

0 Reviews

0 Students

5 Courses

Kapil Kale

B.com

12 Years of Experience

10+ Years of experience in IT Industry as Oracle DBA & Trainer.
Majority of experience as Corporate Trainer in Oracle DBA, SQL/PL-SQL
Expert in Oracle Architecture, Backup & Recoveries, RMAN Performance tuning and UNIX operating system & utilities.
Hands on experience in Oracle DBA and SQL right from installation, granting access, troubleshooting, etc.

Reviews

No reviews currently Be the First to Review

Discussions

Students Interested 0 (Seats Left 0)

Post your requirement and let us connect you with best possible matches for Oracle Database Post your requirement now

Enquire

Submit your enquiry for Oracle Database Administration Training

Please enter valid question or comment

Please select a category

No matching category found.

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

Please check the fields again.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Kapil

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please enter the OTP sent to your registered mobile number.

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more