【Oracle点滴积累】Oracle 19c安装Critical Patch Update for April 2022

广告位招租！
知识无价，人有情，无偿分享知识，希望本条信息对你有用！

今天和大家分享如何为Oracle 19c(未启用RMAN的单实例)安装Critical Patch Update (Patch Number: 33806138)，本指引不包含Roll Back部分，本文仅供参考，谢谢！

mkdir /home/oracle/Patch
mkdir /home/oracle/PatchZip
mkdir /home/oracle/Backup_ORACLE_HOME
mkdir /home/oracle/NewVersion_Opatch

$ORACLE_HOME/OPatch/opatch versioncd /home/oracle/NewVersion_Opatch/
ls
unzip /home/oracle/PatchZip/p6880880_180000_Linux-x86-64.zip
cd OPatch/
./opatch version

OPatch 12.2.0.1.30 for DB 18.0.0.0.0 (Apr 2022)https://updates.oracle.com/Orion/PatchDetails/handle_plat_lang_change?release=600000000107457&plat_lang=46P&patch_file=&file_id=&password_required=&password_required_readme=&merged_trans=&aru=24740835&patch_num=6880880&patch_num_id=3341338&default_release=600000000107457&default_plat_lang=226P&default_compatible_with=&patch_password=&orderby=&direction=&no_header=0&sortcolpressed=&tab_number=

URL: https://updates.oracle.com/Orion/PatchDetails/handle_plat_lang_change?release=600000000107457&plat_lang=46P&patch_file=&file_id=&password_required=&password_required_readme=&merged_trans=&aru=24740835&patch_num=6880880&patch_num_id=3341338&default_release=600000000107457&default_plat_lang=226P&default_compatible_with=&patch_password=&orderby=&direction=&no_header=0&sortcolpressed=&tab_number=

select * from v$version;

export PATH=$PATH:/usr/ccs/bincd /home/oracle/Patch
unzip /home/oracle/PatchZip/p33806138_190000_Linux-x86-64.zip
cd /home/oracle/Patch/33806138/
/home/oracle/NewVersion_Opatch/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./

sqlplus /nolog
conn / as sysdba
shutdown immediate;
exit;

lsnrctl stopecho $ORACLE_HOME
cd /u01/app/oracle/product/19c/
tar -pcvf /home/oracle/Backup_ORACLE_HOME/oracle_home_bkup.tar dbhome_1

/home/oracle/NewVersion_Opatch/OPatch/opatch apply

/home/oracle/NewVersion_Opatch/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./

sqlplus /nolog
conn / as sysdba
startup
quit

/home/oracle/NewVersion_Opatch/OPatch/datapatch -verbose

lsnrctl start

select * from v$version;

Patch 33806138 - Database Release Update Revision 19.14.1.0.220419https://updates.oracle.com/Orion/Services/download?type=readme&aru=24740917#CEGBIEDI

https://updates.oracle.com/Orion/Services/download?type=readme&aru=24740917#CEGBIEDI

OPatch 12.2.0.1.30 for DB 18.0.0.0.0 (Apr 2022)https://updates.oracle.com/Orion/PatchDetails/handle_plat_lang_change?release=600000000107457&plat_lang=46P&patch_file=&file_id=&password_required=&password_required_readme=&merged_trans=&aru=24740835&patch_num=6880880&patch_num_id=3341338&default_release=600000000107457&default_plat_lang=226P&default_compatible_with=&patch_password=&orderby=&direction=&no_header=0&sortcolpressed=&tab_number=

https://updates.oracle.com/Orion/PatchDetails/handle_plat_lang_change?release=600000000107457&plat_lang=46P&patch_file=&file_id=&password_required=&password_required_readme=&merged_trans=&aru=24740835&patch_num=6880880&patch_num_id=3341338&default_release=600000000107457&default_plat_lang=226P&default_compatible_with=&patch_password=&orderby=&direction=&no_header=0&sortcolpressed=&tab_number=

How to Perform ORACLE_HOME Backup? (Doc ID 565017.1)https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=224565810094551&id=565017.1&_afrWindowMode=0&_adf.ctrl-state=159xwjsjry_4

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=224565810094551&id=565017.1&_afrWindowMode=0&_adf.ctrl-state=159xwjsjry_4

Critical Patch Updates, Security Alerts and Bulletinshttps://www.oracle.com/security-alerts/#CriticalPatchUpdates

Critical Patch Updates, Security Alerts and Bulletins

Oracle Critical Patch Update Advisory - April 2022https://www.oracle.com/security-alerts/cpuapr2022.html

Oracle Critical Patch Update Advisory - April 2022

最后，恭祝各位使用愉快！