Oracle Database 23ai Administration

Name: Oracle Database 23ai Administration
Rating: 3.4 (36 reviews)

Oracle 23ai Enterprise Administration

Created byRajeev Raj

Last updated 11/2025

English

English [Auto],

What you'll learn

Understand Oracle Database architecture.
Understand Oracle Database memory and processes.
Configure listener and naming methods to establish connections to database.
Create and manage a database.
New Features for Oracle 18c, 19c,21c, 23c and 23ai
Create and manage tablespaces and optimize UNDO tablespace.
Create and manage PDBs.
Create and manage users and roles.
Understand audit requirements, create audit policies, and review audit results.
Transport and load data between databases.
Oracle RMAN Backup & Recovery
Monitor database and SQL performance and tune database performance.
Oracle 23ai Enterprise Administration
Mission Critical Database Architecture
Oracle AI-Vector Search Optimization

Course content

22 sections • 52 lectures • 25h 9m total length

Introduction32:05
Gain practical, hands-on Oracle database administration on the latest 23 i platform. Learn multitenant architecture with container and pluggable databases, and essential storage and auditing concepts.
Oracle Database 23ai Installation On Linux48:19
Learn to install Oracle database 23ai on Linux using rpm, covering memory, swap, and temp space prerequisites on Oracle Linux 9 and creating a container database with a pluggable database.
Database Licensing Information1:11:27
Understand Oracle licensing terms across standard, enterprise, and personal editions, including multitenant limits. Explore optional licenses such as Active Data Guard, Advanced Analytics, Advanced Compression, and Diagnostic and Tuning Packs.

Oracle Database 23c Installation on Linux40:49
Install Oracle database 23c on Oracle Linux eight using rpm-based methods or yum, with pre-install configuration for developer edition.
Oracle Database 21c Installation on OEL 834:23
Install Oracle database 21c on oracle linux 8 on premises using rpm-based or manual pre-install methods, configuring a single instance with a cdb-only architecture and pdb.
Oracle Database 19c Installation on Linux37:59
Learn how to install Oracle Database 19c release 3 on CentOS Linux using the Oracle Universal Installer, including memory, swap, and temporary space checks, and configure the enterprise edition.

Oracle Database Architecture1:20:26
Learn about Oracle database architecture, including memory structures (SGA and PGA), background processes, and physical and logical storage, plus single instance, multi-tenant, and RAC concepts and the listener's role.
Oracle Database Architecture Part-II58:15
Dive into Oracle database architecture, part II, detailing the SGA components, including the library cache, shared pool, shared SQL and PL/SQL areas, data dictionary cache, and server result cache.

Oracle Database Creation Using DBCA in silent mode31:03
Learn to create a container database with DBCA in silent mode, using CDB test and shared passwords, as demonstrated for Oracle 19c onwards.
Database creation using DBCA21:27
Create an Oracle 23ai database with the DBCA GUI, using a container database with a pluggable database in general purpose mode, and configure the fast recovery area and memory.
Creating a New CDB using SQL command.51:58
Learn how to create a new container database (cdb) with sqlplus, configure environment and init parameters, and run catalog and catproc to build the data dictionary.

Accessing an Oracle Database57:38
Connect to the Oracle database instance over the network using SQL Plus or SQL Developer, with OS authentication or username/password, while learning about listeners and the data dictionary.
SQL Developer Access in Oracle26:29
Access SQL Developer on your machine and connect to an Oracle database. Navigate Oracle Home, manage tables, and use export and import features to monitor and update database performance.

Investigating Initialization Parameter Files15:36
Investigate how Oracle uses the initialization parameter file to start a database, locate the SPFILE and PFILE, and review parameters like memory size, database name, and recovery settings.
Viewing Initialization Parameters by Using SQL*Plus48:36
View and understand Oracle initialization parameters with sql+plus by using show parameter and v$parameter, explore memory settings, SGA targets, undo, control file multiplexing, and related dynamic views for database configuration.
Modifying Initialization Parameters by Using SQL*Plus45:12
Demonstrates modifying Oracle initialization parameters with SQL*Plus, showing session, system, and PDB level changes, differences between dynamic and static parameters, and verification via show parameter and queries.
Diagnostic Information27:59
Use the edr tools and the automatic data diagnostic repository with adrci to monitor Oracle database health, view alert logs, and enable ddl logging for capturing ddl statements.

Configuring the Oracle Network to Access a Database9:23
Configure Oracle network using the network admin tool to set up naming with tnsnames.ora, back up file, create a DNS name service, and verify access to the CDB via sqlplus.
Creating a Net Service Name for a PDB13:04
Create and verify a PDB net service name using the DNS name file, test connectivity with ping and SQL Plus, and explore alternatives with Net Manager and the listener.

Exploring the Default Listener14:35
Explore how to configure and manage the default listener and multiple listeners in Oracle Database 23ai administration, including local and remote listeners, DNS names, and TCP/IP settings.
Creating a Listener24:50
Create and configure a second listener named listener two on port 1561, update tnsnames.ora and DNS entries, and verify dynamic activation with alter system set local_listener.

Requirements

Basic knowledge of Oracle SQL
Basics knowledge of LINUX
Basic understanding of database

Description

This Oracle Database 23ai Administration course is the latest Oracle database release. This course will provide detailed information on the architecture of an Oracle database instance and database, enabling you to effectively manage your database. You learn how to create database storage structures appropriate for the business applications supported by your database. In addition, you learn how to create users and administer database security to meet your business requirements. Basic information on backup and recovery techniques is presented in this course.

There are several benefits to learning this Oracle Database Administration course:

Career advancement: Oracle DBA certification can enhance your career prospects and make you more attractive to employers.
Industry recognition: Oracle certifications are highly sought after and can help you differentiate yourself from your peers.
High demand: There is a growing demand for Oracle DBAs in the industry.
Lucrative career: A career in database administration can be lucrative and rewarding.
Exposure to trends: Attending conferences and seminars conducted by DBA Trainings can give you exposure to the latest features of database.
Gaining experience: DBA trainings can give you first-hand experience of the product's capabilities.
Learning career-relevant skills: DBA Trainings can help you gain skills that are relevant to your career

Who this course is for:

Database Administrators
Database Architects
Developers
Data Scientist
Data Analytics
Oracle 23ai Enterprise Administration

Oracle Database 23ai Administration

What you'll learn

Explore related topics

Course content

Introduction3 lectures • 2hr 32min

Introduction to Oracle Database3 lectures • 1hr 53min

Database Architecture2 lectures • 2hr 19min

Creating an Oracle Database3 lectures • 1hr 44min

Starting and Shutting an Oracle Database1 lecture • 45min

Accessing an Oracle Database2 lectures • 1hr 24min

Managing Database Instances4 lectures • 2hr 17min

Configuring Naming Methods2 lectures • 22min

Configuring and Manage the Listener2 lectures • 39min

Creating PDBs from Seed1 lecture • 21min

Requirements

Description

Who this course is for: