广告位招租!
知识无价,人有情,无偿分享知识,希望本条信息对你有用!
今天和大家分享如何为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;
最后,恭祝各位使用愉快!