Modern Oracle DBA

Adop Apply Phase Frequently Using Commands:- How to apply the patch adop phase=prepare adop phase=apply patches=<Patch_Number> adop phase=finalize adop phase=cutover adop phase=cleanup adop phase=fs_clone How to apply Multiple patches  adop phase=apply patches=<Patch1>,<Patch2>,<Patch3> How to apply Merge patch adop phase=apply patches=<Patch1>,<Patch2>,<Patch3>  merge=yes How to apply Patch Run File System/Hot Patch Mode adop phase=apply patches=<Patch_Number>  hotpatch=yes How to apply the patch downtimemode adop phase=apply patches=<Patch_Number>  apply_mode=downtime How to reapply the patch adop phase=apply patches=<Patch_Number>  options=forceapply How to restart the patch from where patch failed adop phase=apply patches=<Patch_Number>  restart=yes How to restart the failed patch from begining adop phase=apply patches=<Patch_Number>  abandon=yes How to ignore the failed patch ...

Prerequest:- DBLink Name Schema name and password Connection string(tnsping SID) Creating Database Link:- Check DBLink is allreday existist or not Copy SQL> Select * from dba_db_links where db_link='db_link_name'; Copy CREATE DATABASE LINK CONNECT TO IDENTIFIED BY USING 'TEST=( DESCRIPTION=( ADDRESS=( PROTOCOL=TCP (HOST=ebstest.vis.com) (PORT=1521) ) (CONNECT_DATA=( SERVICE_NAME=test INSTANCE_NAME=test )) ) )'; If you want to recreate a DB Link first get the source code from the database link before you drop the DBLink Copy SQL>set long 1000 SQL> select DBMS_METADATA.GET_DDL('DB_LINK','DB.DBLINK,'DB.OWNER') from dba_db_links; Connectivity Test:- Copy select * from global_name@DB_LINK_NAME select * from global_name; Drop DB Link: Check the D...

1. Download pacthes 2. Patch Alasysis 3. Conflicts check and system space check  4. Backups (GI Home, DB Home and Database) 5. Apply  6. Post checks Download the Patches:- Search the below keyword in metalink to download the CPU Patches Critical patch Update (CPU) Program JAN 2022 Critical patch Update (CPU) Program Apr 2022   Critical patch Update (CPU) Program JUL 2022   Critical patch Update (CPU) Program OCT 2022 I opened for the July patch, and here we need to click Patch availability for Oracle products -> 3.1 Oracle database. Oracle database (3.1) Many Oracle products patches are listed here. I need only Oracle database patches. So, I'll go with the Oracle database 3.1.7 My DB version is 19c So I will choose 3.1.7.3 Oracle database 19c Here I will download the below database patch and grid patch (GI) One interesting fact is that if you download the GI Patch Database patch, it will also come under GI Patch. As a result, there is no need t...