Oracle Database Administration
Buy now
Learn more
Discussions
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 and Management Packs
LESSON 3: Architecture of Oracle Database Server
Database and Instance
Instance Configurations
Applications and Databases
Tablespaces, Data Files, Data Blocks, Schema
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 Database
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
Link to download Oracle Linux 7.6 software from One Drive
Downloading Oracle Linux from Oracle Portal
Installing Oracle Linux
Configuring Oracle Linux
Installing Oracle Database
About Optimal Flexible Architecture (OFA)
Understanding Installation Requirements
Configuring Installation Requirements
Downloading Oracle Database software from One Drive
Downloading Oracle Database Software from Oracle Portal
Installing Oracle Database Software
Creating Database
Post Installation Tasks
Setting Environment Variables
How to start/stop DB, VM, Physical Machine?
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 Parameters
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 about default tablespaces
Lab Practice: Creating Tablespaces
Managing Tablespaces
Managing Data Files - Part1
Managing Data Files - Part2
More Demos
Managing Temporary Tablespaces
Overview of Managing Temporary Tablespaces
Lab Practices: Managing Temporary Tablespaces
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 only Accounts
Lab Practices: Administering User Accounts
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 Oracle Net Listeners
Overview of Establishing Net Connections
How to Implement and Test Oracle Net Services on Laptop
Lab Practice: Configuring Network between Physical Machine and VM
Lab Practice: Starting Default Listener
Lab Practice: Installing Oracle Client
Lab Practice: Establishing Remote Database Connectivity
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 Managing RMAN Configuration Parameters
Performing Backup and Reporting operations using RMAN
Overview of Configuring Recovery Catalog
Lab Practice: Configuring Recovery Catalog
Registering Target Database in Recovery Catalog
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 Database
Lab Practice: Performing Flashback Database Operation
Overview of Flashback Drop Table
Lab Practice: Performing Flashback Drop Table Operation
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
Lesson
Downloading Oracle Linux from Oracle Portal
Downloading Oracle Linux from Oracle Portal
Oracle Database Administration
Buy now
Learn more
Discussions
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 and Management Packs
LESSON 3: Architecture of Oracle Database Server
Database and Instance
Instance Configurations
Applications and Databases
Tablespaces, Data Files, Data Blocks, Schema
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 Database
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
Link to download Oracle Linux 7.6 software from One Drive
Downloading Oracle Linux from Oracle Portal
Installing Oracle Linux
Configuring Oracle Linux
Installing Oracle Database
About Optimal Flexible Architecture (OFA)
Understanding Installation Requirements
Configuring Installation Requirements
Downloading Oracle Database software from One Drive
Downloading Oracle Database Software from Oracle Portal
Installing Oracle Database Software
Creating Database
Post Installation Tasks
Setting Environment Variables
How to start/stop DB, VM, Physical Machine?
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 Parameters
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 about default tablespaces
Lab Practice: Creating Tablespaces
Managing Tablespaces
Managing Data Files - Part1
Managing Data Files - Part2
More Demos
Managing Temporary Tablespaces
Overview of Managing Temporary Tablespaces
Lab Practices: Managing Temporary Tablespaces
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 only Accounts
Lab Practices: Administering User Accounts
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 Oracle Net Listeners
Overview of Establishing Net Connections
How to Implement and Test Oracle Net Services on Laptop
Lab Practice: Configuring Network between Physical Machine and VM
Lab Practice: Starting Default Listener
Lab Practice: Installing Oracle Client
Lab Practice: Establishing Remote Database Connectivity
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 Managing RMAN Configuration Parameters
Performing Backup and Reporting operations using RMAN
Overview of Configuring Recovery Catalog
Lab Practice: Configuring Recovery Catalog
Registering Target Database in Recovery Catalog
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 Database
Lab Practice: Performing Flashback Database Operation
Overview of Flashback Drop Table
Lab Practice: Performing Flashback Drop Table Operation
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
Lesson unavailable
Please
login to your account
or
buy the course
.