广告位招租!
知识无价,人有情,无偿分享知识,希望本条信息对你有用!
今天和大家分享如何为Oracle 19c(未启用RMAN的单实例)安装Critical Patch Update (Patch Number: 33806138),本指引不包含Roll Back部分,本文仅供参考,谢谢!
mkdir /home/oracle/Patch
mkdir /home/oracle/PatchZip
mkdir /home/oracle/Backup_ORACLE_HOME
mkdir /home/oracle/NewVersion_Opatch
$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
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 ./
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
/home/oracle/NewVersion_Opatch/OPatch/opatch apply
/home/oracle/NewVersion_Opatch/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
sqlplus /nolog
conn / as sysdba
startup
quit
/home/oracle/NewVersion_Opatch/OPatch/datapatch -verbose
lsnrctl start
select * from v$version;
https://updates.oracle.com/Orion/Services/download?type=readme&aru=24740917#CEGBIEDI
Critical Patch Updates, Security Alerts and Bulletins
Oracle Critical Patch Update Advisory - April 2022
最后,恭祝各位使用愉快!