Oracle Database Administration
Buy now
Learn more
Course Materials
Slides
Lab Guide
LESSON 1: Introduction to DBMS and RDBMS
Overview of DBMS, RDBMS
LESSON 2: Introduction to Oracle Database Server
What is Oracle Database Server?
Responsibilities of Oracle DBA
Oracle Database Versions, Editions an...
LESSON 3: Architecture of Oracle Database Server
Database and Instance
Instance Configurations
Applications and Databases
Tablespaces, Data Files, Data Blocks,...
Overview of Data Dictionary
Client Process and Server Process
Dedicated Server and Shared Server
Overview of SGA and Background Processes
Shared Pool
Database Buffer Cache
Redo Log Buffer
Writing of modified Buffers to the Da...
Instance Recovery
Fixed SGA
Process Monitor
Concluding the Instance Concepts
PGA Memory
Initialization Parameters
Oracle Database Memory Management
Overview of Oracle Database Installation
Overview of Oracle Database Installation
Creating Linux VM
Download and Install VirtualBox
Creating VM
Downloading Oracle Linux
Installing Oracle Linux
Configuring Oracle Linux
Installing Oracle Database
About Optimal Flexible Architecture (...
Understanding Installation Requirements
Configuring Installation Requirements
Downloading Oracle Database Software
Installing Oracle Database Software
Creating Database
Post Installation Tasks
Setting Environment Variables
How to start/stop DB, VM, Physical Ma...
Understanding the Installed Database
Data Dictionary
About Data Dictionary
Lab Practices
Managing Database Startup and Shutdown
Overview of Database Startup
Lab Practices: Database Startup
Overview of Database Shutdown
Lab Practice: Database Shutdown
Managing Initialization Parameters
Managing Initialization Parameters
Lab Practice: Managing Initialization...
Managing Diagnostic Data
Managing Diagnostic Data
About Diagnostic Data
Lab Practice: Managing Diagnostic Data
Managing Tablespaces and Data Files
Overview of Tablespaces
Overview of Data Files
Overview of ROWID
How Database allocates Space?
Extent Management
Segment Space Management
Row Chaining and Row Migration
Fragmentation
High Water Mark (HMW)
Shrinking Segments
Classification of Tablespaces
About default Tablespaces
Lab Practice: Querying information ab...
Lab Practice: Creating Tablespaces
Managing Tablespaces
Managing Data Files - Part1
Managing Data Files - Part2
More Demos
Managing Temporary Tablespaces
Overview of Managing Temporary Tables...
Lab Practices: Managing Temporary Tab...
Managing Undo Tablespaces
Overview of Undo Tablespace
Overview of Managing Undo Tablespaces
Lab Practices: Managing Undo Tablespaces
Managing Control Files
Overview of Control Files
Overview of Managing Control Files
Lab Practices: Managing Control Files
Managing Redo Log
Overview of Redo Log Files
Overview of Managing Online Redo Log
Lab Practices: Managing Online Redo Log
Managing Archive Log
Overview of Archive Log Mode
Lab Practices: Archive Log
Oracle Managed Files (OMF)
About Oracle Managed Files
Configuring OMF
OMF Name Formats
Lab Practices: Configuring and Using OMF
User Administration
Overview of Administering User Accounts
About Predefined Accounts and Schema ...
Lab Practices: Administering User Acc...
Profiles Administration
Overview of Profiles
Lab Practices: Using Profiles
Privileges and Roles
Managing Database Privileges and Roles
Oracle Net Services
About Oracle Net Services
Components of Oracle Net Services
About Oracle Net Listener
Overview of Creating and Managing Ora...
Overview of Establishing Net Connections
How to Implement and Test Oracle Net ...
Lab Practice: Configuring Network bet...
Lab Practice: Starting Default Listener
Lab Practice: Installing Oracle Client
Lab Practice: Establishing Remote Dat...
Creating Custom Listener using NETCA
Creating Custom Listener Manually
Using TNSPING utility
Recovery Manager (RMAN)
About Recovery Manager (RMAN)
RMAN Concepts
Backup Set Backup and Image Copy Backup
Lab Practice: Starting RMAN and Manag...
Performing Backup and Reporting opera...
Overview of Configuring Recovery Catalog
Lab Practice: Configuring Recovery Ca...
Registering Target Database in Recove...
Overview of Recovery using RMAN
Recovering Non-System Data Files
Recovering Non-System Tablespace
Recovering System Data Files
Recovering ALL Data Files
Recovering Control Files
Recovering SPFILE
Recovering Complete Database
Restoring to a NEW Location
Recovery using Image Copies
Database Point in Time Recovery
Tablespace Point in Time Recovery
Flashback Features
Overview of Flashback Database
Lab Practice: Configuring Flashback D...
Lab Practice: Performing Flashback Da...
Overview of Flashback Drop Table
Lab Practice: Performing Flashback Dr...
Oracle Data Pump
Overview of Oracle Data Pump
Lab Practices: Using Data Pump
Patching
Updating Software using Patches
Links to download Patch files
Upgrading
Upgrading the Database
Multitenant Container Database Administration
Creating Container Database
Administering Container Database
Products
Course
Section
Managing Diagnostic Data
Managing Diagnostic Data
Oracle Database Administration
Buy now
Learn more
Course Materials
Slides
Lab Guide
LESSON 1: Introduction to DBMS and RDBMS
Overview of DBMS, RDBMS
LESSON 2: Introduction to Oracle Database Server
What is Oracle Database Server?
Responsibilities of Oracle DBA
Oracle Database Versions, Editions an...
LESSON 3: Architecture of Oracle Database Server
Database and Instance
Instance Configurations
Applications and Databases
Tablespaces, Data Files, Data Blocks,...
Overview of Data Dictionary
Client Process and Server Process
Dedicated Server and Shared Server
Overview of SGA and Background Processes
Shared Pool
Database Buffer Cache
Redo Log Buffer
Writing of modified Buffers to the Da...
Instance Recovery
Fixed SGA
Process Monitor
Concluding the Instance Concepts
PGA Memory
Initialization Parameters
Oracle Database Memory Management
Overview of Oracle Database Installation
Overview of Oracle Database Installation
Creating Linux VM
Download and Install VirtualBox
Creating VM
Downloading Oracle Linux
Installing Oracle Linux
Configuring Oracle Linux
Installing Oracle Database
About Optimal Flexible Architecture (...
Understanding Installation Requirements
Configuring Installation Requirements
Downloading Oracle Database Software
Installing Oracle Database Software
Creating Database
Post Installation Tasks
Setting Environment Variables
How to start/stop DB, VM, Physical Ma...
Understanding the Installed Database
Data Dictionary
About Data Dictionary
Lab Practices
Managing Database Startup and Shutdown
Overview of Database Startup
Lab Practices: Database Startup
Overview of Database Shutdown
Lab Practice: Database Shutdown
Managing Initialization Parameters
Managing Initialization Parameters
Lab Practice: Managing Initialization...
Managing Diagnostic Data
Managing Diagnostic Data
About Diagnostic Data
Lab Practice: Managing Diagnostic Data
Managing Tablespaces and Data Files
Overview of Tablespaces
Overview of Data Files
Overview of ROWID
How Database allocates Space?
Extent Management
Segment Space Management
Row Chaining and Row Migration
Fragmentation
High Water Mark (HMW)
Shrinking Segments
Classification of Tablespaces
About default Tablespaces
Lab Practice: Querying information ab...
Lab Practice: Creating Tablespaces
Managing Tablespaces
Managing Data Files - Part1
Managing Data Files - Part2
More Demos
Managing Temporary Tablespaces
Overview of Managing Temporary Tables...
Lab Practices: Managing Temporary Tab...
Managing Undo Tablespaces
Overview of Undo Tablespace
Overview of Managing Undo Tablespaces
Lab Practices: Managing Undo Tablespaces
Managing Control Files
Overview of Control Files
Overview of Managing Control Files
Lab Practices: Managing Control Files
Managing Redo Log
Overview of Redo Log Files
Overview of Managing Online Redo Log
Lab Practices: Managing Online Redo Log
Managing Archive Log
Overview of Archive Log Mode
Lab Practices: Archive Log
Oracle Managed Files (OMF)
About Oracle Managed Files
Configuring OMF
OMF Name Formats
Lab Practices: Configuring and Using OMF
User Administration
Overview of Administering User Accounts
About Predefined Accounts and Schema ...
Lab Practices: Administering User Acc...
Profiles Administration
Overview of Profiles
Lab Practices: Using Profiles
Privileges and Roles
Managing Database Privileges and Roles
Oracle Net Services
About Oracle Net Services
Components of Oracle Net Services
About Oracle Net Listener
Overview of Creating and Managing Ora...
Overview of Establishing Net Connections
How to Implement and Test Oracle Net ...
Lab Practice: Configuring Network bet...
Lab Practice: Starting Default Listener
Lab Practice: Installing Oracle Client
Lab Practice: Establishing Remote Dat...
Creating Custom Listener using NETCA
Creating Custom Listener Manually
Using TNSPING utility
Recovery Manager (RMAN)
About Recovery Manager (RMAN)
RMAN Concepts
Backup Set Backup and Image Copy Backup
Lab Practice: Starting RMAN and Manag...
Performing Backup and Reporting opera...
Overview of Configuring Recovery Catalog
Lab Practice: Configuring Recovery Ca...
Registering Target Database in Recove...
Overview of Recovery using RMAN
Recovering Non-System Data Files
Recovering Non-System Tablespace
Recovering System Data Files
Recovering ALL Data Files
Recovering Control Files
Recovering SPFILE
Recovering Complete Database
Restoring to a NEW Location
Recovery using Image Copies
Database Point in Time Recovery
Tablespace Point in Time Recovery
Flashback Features
Overview of Flashback Database
Lab Practice: Configuring Flashback D...
Lab Practice: Performing Flashback Da...
Overview of Flashback Drop Table
Lab Practice: Performing Flashback Dr...
Oracle Data Pump
Overview of Oracle Data Pump
Lab Practices: Using Data Pump
Patching
Updating Software using Patches
Links to download Patch files
Upgrading
Upgrading the Database
Multitenant Container Database Administration
Creating Container Database
Administering Container Database
3 Lessons
Managing Diagnostic Data
About Diagnostic Data
Lab Practice: Managing Diagnostic Data