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

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

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

cd /home/oracle/NewVersion_Opatch/OPatch/
./opatch version

cd /XX_Oracle_Patch/NewVersion_Opatch/OPatch/
./opatch version

cd /home/oracle/NewVersion_Opatch
unzip /home/oracle/PatchZip/p6880880_190000_Linux-x86-64.zip

cd /XX_Oracle_Patch/NewVersion_Opatch/
unzip /XX_Oracle_Patch/PatchZip/p6880880_190000_Linux-x86-64.zip

cd /XX_Oracle_Patch/NewVersion_Opatch/OPatch
./opatch version

select * from v$version;

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

cd /XX_Oracle_Patch/Patch
unzip /XX_Oracle_Patch/PatchZip/p35943157_190000_Linux-x86-64.zip
cd /XX_Oracle_Patch/Patch/35943157/
/XX_Oracle_Patch/NewVersion_Opatch/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./

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

lsnrctl stop;

echo $ORACLE_HOME
cd /u01/app/oracle/product/19c/
tar -pcvf /XX_Oracle_Patch/Backup_ORACLE_HOME/oracle_home_bkup.tar dbhome_1


cd /etc/
ls oraInst.loc
cat oraInst.loc
cp oraInst.loc /XX_Oracle_Patch/Backup_ORACLE_HOME/20240221_oraInst.loc

cd /XX_Oracle_Patch/Patch/35943157/
/XX_Oracle_Patch/NewVersion_Opatch/OPatch/opatch apply

/XX_Oracle_Patch/NewVersion_Opatch/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./

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

/XX_Oracle_Patch/NewVersion_Opatch/OPatch/datapatch -verbose

lsnrctl start

select * from v$version;

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