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 and apply the new patch adop phase

Prerequest:- DBLink Name Schema name and password Connection string(tnsping SID) Creating Database Link:- Check DBLink is allreday existist or not SQL> Select * from dba_db_links where db_link='<db_link_name>'; SQL> CREATE DATABASE LINK <DB_LINK_NAME> CONNECT TO <Schema_name> IDENTIFIED BY <Schema_PWD> 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 SQL>set long 1000 SQL> select DBMS_METADATA.GET_DDL('DB_LINK','DB.DBLINK,'DB.OWNER') from dba_db_links; Connectivity Test:- select * from global_name@<DB_LINK_NAME> select * from global_name; Drop DB Link: Check the DB link and respective user and connect the user drop the db link  SQL> set lines 1000 col owner for a20 col username for a20 col host for a40 col 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 to download a database pat