Oracle Database Administration for JuniorDBA/Oracle cloud.
https://www.udemy.com/course/oracle-12c-database-administration-with-hands-on-experience/?referralCode=1E201288CABCE8A80C5D Topics Covered Database instance and storage Instance memory pools Instance background processes Client connections Database storage file types Control files and backup files Multi-tenant databases Starting and stopping the database Installing Oracle 12c software Using the developer tools Database management Oracle Backup (RMAN) Hands-On Demo and Concepts Starting and connecting to database How to […]
Learn Oracle Database Upgrade – Oracle 11g to 12c upgrade
https://www.udemy.com/course/learn-oracle-database-upgrade-oracle-11g-to-12c-upgrade/?referralCode=107A695E7B5C1D8C96B4 Course Goal: High level steps to upgrade from Oracle 11G to 12C using Oracle Linux 7.4 Step-1 Download Oracle Linux 7.6 , Oracle 11G and 12C Software Step-2 Install Oracle Linux 7.6 Step by Step Step-3 Basic Host Configuration of Linux Server Step-4 Setup Oracle Perquisites on Linux Server Step-5 Install Oracle 11G Software […]
Oracle 18c and Dataguard setup on premises and oracle Cloud
https://www.udemy.com/course/database-administration-oracle-18c-lab-setup-and-data-guard/?referralCode=4F4C9298878B8A837B9F Section-1 Oracle 18C lab environment hands-on Download Software Configure Virtual Machine and Install Oracle Linux 7 OS Configuration for Oracle 18C Copy and install Oracle 18c Configure LISTENER DBCA generate scripts to create database Connecting to Container Databases (CDB) and Pluggable Databases (PDB) in Oracle Database 18c Section -2 Oracle Data-Guard LAB Setup on […]
Linux Command Line basics
https://www.udemy.com/course/learn-linux-command-line-in-days-and-level-up-your-career/?referralCode=A46CD4BE90BC7402F154 The following topics are included. · What is the Linux command line? · Writing Linux commands at the prompt · Finding help for Linux commands · Copying, moving, and deleting files and folders · Configuring user roles and file permissions · Using pipes to connect commands · Searching and editing text · Finding system […]
Oracle Solaris 11 Administration and Sun Cluster Practical
https://www.udemy.com/course/solaris-114-administration-and-sun-cluster-with-hands-on/?referralCode=B025BBF08484F94DC653 Part -1 Basic Solaris administrations Including installing Solaris 11, the Image Packaging System, administering Oracle Solaris Zones, the ZFS file system, networking, controlling access to systems and files, and managing users and resource management and finally demo on ZFS storage appliance. Introduction Basic Solaris Administration Setup IPS and boot environments Overview of IPMP(IP Multi-Pathing) […]
Oracle Solaris 11 System Administration from Zero to Hero
https://www.udemy.com/course/oracle-solaris-11-system-administration-from-zero-to-hero/?referralCode=7287A8742282F72302DE Course Goal: • Enable you to perform basic Oracle Solaris 11 system administration tasks successfully and efficiently • Present tasks that cover the full spectrum of system administrative responsibilities: – OS installation – Package management – Network, data storage, zones, and user administration – Services and process management – System monitoring and troubleshooting Provide […]
How to Implement the Password Verify Function in a EDB PostgreSQL Advanced Server Database
Step 1: Create password verification function CREATE OR REPLACE FUNCTION sys.verify_password(user_name varchar2, new_password varchar2, old_password varchar)RETURNS boolean IMMUTABLELANGUAGE plpgsqlAS $function$BEGINIF (length(new_password) < 8)THEN— raise_application_error(-20001, ‘too short’);RAISE EXCEPTION ‘too short’;END IF;IF new_password= old_passwordTHEN— raise_application_error(-20002, ‘includes old password’);RAISE exception ‘includes old password’;END IF;IF substring(upper(new_password) FROM upper(user_name)) IS NOT NULLTHEN— raise_application_error(-20003, ‘New passowrd not allowed to include username’);RAISE […]