本文主要是介绍【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 versioncd /XX_Oracle_Patch/NewVersion_Opatch/OPatch/
./opatch version
cd /home/oracle/NewVersion_Opatch
unzip /home/oracle/PatchZip/p6880880_190000_Linux-x86-64.zipcd /XX_Oracle_Patch/NewVersion_Opatch/
unzip /XX_Oracle_Patch/PatchZip/p6880880_190000_Linux-x86-64.zipcd /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_1cd /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;最后，恭祝各位使用愉快！
这篇关于【Oracle点滴积累】Oracle 19c安装Critical Patch Update for January 2024的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！
