【Oracle点滴积累】Oracle 19c安装Critical Patch Update for January 2023

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

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

cd /home/oracle/NewVersion_Opatch/OPatch/
./opatch versioncd /home/oracle/NewVersion_Opatch
unzip /home/oracle/PatchZip/p6880880_190000_Linux-x86-64.zipcd /home/oracle/NewVersion_Opatch/OPatch/
./opatch version

select * from v$version;

 

export PATH=$PATH:/usr/ccs/bin

cd /home/oracle/Patch
unzip /home/oracle/PatchZip/p34771828_190000_Linux-x86-64.zip
cd /home/oracle/Patch/34771828
/home/oracle/NewVersion_Opatch/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./

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

lsnrctl stop;cd /etc/
ls oraInst.loc
cat oraInst.loc
cp oraInst.loc /home/oracle/Backup_ORACLE_HOME/20230215_oraInst.loc

 

cd /home/oracle/Patch/34771828
/home/oracle/NewVersion_Opatch/OPatch/opatch apply

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

sqlplus /nolog
conn / as sysdba
startup
alter system set "_bug27355984_xt_preproc_timeout" = 1000 scope=both;
quit

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

lsnrctl start

select * from v$version;

Patch 34771828 - Database Release Update Revision 19.16.2.0.230117https://updates.oracle.com/Orion/Services/download?type=readme&aru=25078620

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

 OPatch 12.2.0.1.36 for DB 19.0.0.0.0 (Jan 2023)

https://updates.oracle.com/Orion/PatchDetails/handle_plat_lang_change?release=600000000122912&plat_lang=46P&patch_file=&file_id=&password_required=&password_required_readme=&merged_trans=&aru=24973991&patch_num=6880880&patch_num_id=3506013&default_release=600000000122912&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 - January 2023https://www.oracle.com/security-alerts/cpujan2023.html

Oracle Critical Patch Update Advisory - January 2023

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