Curated Video
Oracle Database Administration from Zero to Hero - Managing the Fast Recovery Area
In this video, we will delve into the management of the Fast Recovery Area (FRA). You will learn about the purpose of the FRA, its advantages, and how to enable and monitor it. Additionally, we will discuss best practices for effectively...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Configuring Databases for Shared Server
In this practice video, we will apply the knowledge gained in configuring databases for shared server mode. You will work with shared server processes in the database on srv1 for the PDB1 service. Specifically, you will learn how to test...
Curated Video
Oracle Database Administration from Zero to Hero - Configuring Databases for Shared Server (Part 3 of 3)
In this video, we will conclude our coverage of configuring databases for shared server mode. You will understand the rules and considerations involved in altering the dispatcher configurations. This clip is from the chapter "Configuring...
Curated Video
Oracle Database Administration from Zero to Hero - Configuring Databases for Shared Server (Part 2 of 3)
In this video, we will continue our discussion on configuring databases for shared server mode. You will learn how to set up dispatcher configurations and configure clients to work with shared and dedicated servers. This clip is from the...
Curated Video
Oracle Database Administration from Zero to Hero - Configuring Databases for Shared Server (Part 1 of 3)
In this video, we will begin our exploration of configuring databases for shared server mode. You will learn about the shared server architecture, its advantages, and the necessary steps to configure it. This clip is from the chapter...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Using Database Links
In this practice video, we will reinforce our understanding of using database links. You will create and use a database link to the SOE schema in PDB1. This clip is from the chapter "Managing Database Connectivity" of the series "Oracle...
Curated Video
Oracle Database Administration from Zero to Hero - Using Database Links (Part 2 of 2)
In this video, we will continue our discussion on using database links. You will learn how to create database links, use them in synonyms, and understand using Global Name as a Loopback Database Link. This clip is from the chapter...
Curated Video
Oracle Database Administration from Zero to Hero - Using Database Links (Part 1 of 2)
In this video, we will explore the usage of database links. You will learn about database links, their types, and users, as well as understand naming database links. This clip is from the chapter "Managing Database Connectivity" of the...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Configuring Oracle Network Environment (Part 4 of 4)
In this practice video, we will conclude our hands-on practice with configuring the Oracle network environment. You will install the Oracle instant client and save the srv1 Current State Snapshot. This clip is from the chapter "Managing...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Configuring Oracle Network Environment (Part 3 of 4)
In this practice video, we will further enhance our understanding of configuring the Oracle network environment. You will install the sample application, Swingbench. This clip is from the chapter "Managing Database Connectivity" of the...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Configuring Oracle Network Environment (Part 2 of 4)
In this practice video, we will continue our hands-on practice with configuring the Oracle network environment. You will control the allowable connection naming methods and the Listener using lsnrctl. This clip is from the chapter...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Configuring Oracle Network Environment (Part 1 of 4)
In this practice video, we will apply the knowledge gained in configuring the Oracle network environment. You will manage connections to Oracle databases and network configuration tools, with a focus on using Easy Connect and Local...
Curated Video
Oracle Database Administration from Zero to Hero - Configuring Oracle Network Environment (Part 4 of 4)
In this video, we will conclude our discussion on configuring the Oracle network environment. You will learn how to use the Listener Control Utility and register database services in the listener. This clip is from the chapter "Managing...
Curated Video
Oracle Database Administration from Zero to Hero - Configuring Oracle Network Environment (Part 2 of 4)
In this video, we will continue our exploration of configuring the Oracle network environment. You will learn about Oracle Net Naming Methods and how to use them. This clip is from the chapter "Managing Database Connectivity" of the...
Curated Video
Oracle Database Administration from Zero to Hero - Configuring Oracle Network Environment (Part 1 of 4)
In this video, you will learn about configuring the Oracle network environment. You will understand the Oracle Net Listener, the database connection cycle, and Oracle Net Configuration files. This clip is from the chapter "Managing...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Using Database Authentication Methods
In this practice video, we will reinforce our understanding of database authentication methods, specifically focusing on OS authentication and password file authentication in Oracle databases. You will examine OS authentication for...
Curated Video
Oracle Database Administration from Zero to Hero - Using Password File Authentication
In this video, you will learn about password file authentication. You will understand the concept, create a password file, set the REMOTE_LOGIN_PASSWORDFILE parameter, explore the relationship between OS authentication and password file...
Curated Video
Oracle Database Administration from Zero to Hero - Using OS Authentication (Part 2 of 2)
In this video, we will continue our exploration of OS authentication. You will learn how to allow administrative OS authentication for OS users and create OS-authenticated normal users. This clip is from the chapter "Managing Database...
Curated Video
Oracle Database Administration from Zero to Hero - Applying the Principle of Least Privileges
In this video, we will discuss the importance of applying the Principle of Least Privileges in Oracle databases. You will understand the concept and best practices for granting minimal privileges to users. This clip is from the chapter...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Managing Local and Common Users (Part 2 of 2)
In this practice video, we will continue our hands-on practice with managing local and common users. You will grant privileges as common or local and enable common users to view information about specific PDBs. This clip is from the...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Managing Users and User Security (Part 2 of 2)
In this practice video, we will continue our hands-on practice with managing users and user security. You will check the user account tablespace quota and manage user password settings using user profiles. This clip is from the chapter...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Managing Users and User Security (Part 1 of 2)
In this practice video, we will apply the knowledge gained in managing database users and user security. You will perform common tasks involved in managing database users and roles, with a focus on implementing a simple example. This...
Curated Video
Oracle Database Administration from Zero to Hero - Managing User Profiles (Part 2 of 2)
In this video, we will continue our exploration of managing user profiles. You will learn how to enable password complexity verification functions, obtain information about user passwords and profiles, implement gradual password rollover...
Curated Video
Oracle Database Administration from Zero to Hero - Managing User Profiles (Part 1 of 2)
In this video, we will focus on managing user profiles. You will learn about the benefits of user profiles, explore password parameters and the password change lifecycle, understand resource limit parameters in user profiles, and learn...