广告位招租!
知识无价,人有情,无偿分享知识,希望本条信息对你有用!
今天和大家分享如何为Oracle 19c(未启用RMAN的单实例)安装Critical Patch Update(Patch Number:34771828),本指引不包含Roll Back部分,本文仅供参考,谢谢!
cd /home/oracle/NewVersion_Opatch/OPatch/
./opatch version
cd /home/oracle/NewVersion_Opatch
unzip /home/oracle/PatchZip/p6880880_190000_Linux-x86-64.zip
cd /home/oracle/NewVersion_Opatch/OPatch/
./opatch version
select * from v$version;
export PATH=$PATH:/usr/ccs/bin
cd /home/oracle/Patch
unzip /home/oracle/PatchZip/p34771828_190000_Linux-x86-64.zip
cd /home/oracle/Patch/34771828
/home/oracle/NewVersion_Opatch/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
sqlplus /nolog
conn / as sysdba
shutdown immediate;
exit;
lsnrctl stop;
cd /etc/
ls oraInst.loc
cat oraInst.loc
cp oraInst.loc /home/oracle/Backup_ORACLE_HOME/20230215_oraInst.loc
cd /home/oracle/Patch/34771828
/home/oracle/NewVersion_Opatch/OPatch/opatch apply
/home/oracle/NewVersion_Opatch/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
sqlplus /nolog
conn / as sysdba
startup
alter system set "_bug27355984_xt_preproc_timeout" = 1000 scope=both;
quit
/home/oracle/NewVersion_Opatch/OPatch/datapatch -verbose
lsnrctl start
select * from v$version;
https://updates.oracle.com/Orion/Services/download?type=readme&aru=25078620
OPatch 12.2.0.1.36 for DB 19.0.0.0.0 (Jan 2023)
Critical Patch Updates, Security Alerts and Bulletins
Oracle Critical Patch Update Advisory - January 2023
最后,恭祝各位使用愉快!