标签:password plat default Update patch oracle Oracle home Patch
广告位招租!
知识无价,人有情,无偿分享知识,希望本条信息对你有用!
今天和大家分享如何为Oracle 19c安装Critical Patch Update (Patch Number: 33806138),本指引不包含Roll Back部分。
![](https://i-blog.csdnimg.cn/direct/0c9640aedda54b11b456151356b4197f.png)
![](https://i-blog.csdnimg.cn/direct/ece9eb27ef334545affcf466f666ba71.png)
![](https://i-blog.csdnimg.cn/direct/2335fbdd8e214db9a4695eadfba57432.png)
mkdir /home/oracle/Patch
mkdir /home/oracle/PatchZip
mkdir /home/oracle/Backup_ORACLE_HOME
mkdir /home/oracle/NewVersion_Opatch
![](https://i-blog.csdnimg.cn/direct/8ed83ed5522d4f0a97e904ad63883659.png)
$ORACLE_HOME/OPatch/opatch version
cd /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=
![](https://i-blog.csdnimg.cn/direct/7fc93448f0cd451cb4f871247103f29c.png)
![](https://i-blog.csdnimg.cn/direct/959ede7482634b1a90333257387c9e84.png)
select * from v$version;
export PATH=$PATH:/usr/ccs/bin
cd /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 ./
![](https://i-blog.csdnimg.cn/direct/ebbb230fc2e141c9ad74396b2ea905e9.png)
![](https://i-blog.csdnimg.cn/direct/1fe1a7b8c6bb49268c115a046b0f4eae.png)
sqlplus /nolog
conn / as sysdba
shutdown immediate;
exit;
lsnrctl stop
echo $ORACLE_HOME
cd /u01/app/oracle/product/19c/
tar -pcvf /home/oracle/Backup_ORACLE_HOME/oracle_home_bkup.tar dbhome_1
![](https://i-blog.csdnimg.cn/direct/27824f71b2b24982919d99982957588c.png)
/home/oracle/NewVersion_Opatch/OPatch/opatch apply
![](https://i-blog.csdnimg.cn/direct/b684b269ff634d17b834d0628070524c.png)
/home/oracle/NewVersion_Opatch/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
![](https://i-blog.csdnimg.cn/direct/972faf313d1d4aefa4fca004ca34f5c9.png)
![](https://i-blog.csdnimg.cn/direct/945a764cc913468abb6bef2002dbdbd3.png)
sqlplus /nolog
conn / as sysdba
startup
quit
/home/oracle/NewVersion_Opatch/OPatch/datapatch -verbose
![](https://i-blog.csdnimg.cn/direct/39af563a34e240d29229718c953da03b.png)
![](https://i-blog.csdnimg.cn/direct/4505763fd8d54c6eae3247ff49857b05.png)
lsnrctl start
![](https://i-blog.csdnimg.cn/direct/bd5b34b3ce414bb280eeed99a067cd6a.png)
select * from v$version;
![](https://i-blog.csdnimg.cn/direct/cb57598e06c947d4b37a286ae73f1813.png)
Patch 33806138 - Database Release Update Revision 19.14.1.0.220419
https://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 Bulletins
https://www.oracle.com/security-alerts/#CriticalPatchUpdates
Critical Patch Updates, Security Alerts and Bulletins
Oracle Critical Patch Update Advisory - April 2022
https://www.oracle.com/security-alerts/cpuapr2022.html
Oracle Critical Patch Update Advisory - April 2022
最后,恭祝各位使用愉快!
标签:password,
plat,
default,
Update,
patch,
oracle,
Oracle,
home,
Patch
From: https://blog.csdn.net/ncutyb123/article/details/141106320