目录
实验环境
后处理步骤
参考
实验环境
操作系统:SUSE Linux Enterprise Server 12 SP5
数据库版本:Oracle 12.2.0.1
数据库SID:T73
数据库用户:orat73
下载Oracle 12.2.0.1补丁
登录SAP官网:SAP Support Portal Home
点击“Software Downloads”按钮:
点击“DATABASES”底下的“Oracle”按钮:
点击“DOWNLOADS”底下的“ORACLE PATCHES”按钮:
点击“DOWNLOADS”底下的“ORACLE PATCHES 12.2.0.1”按钮:
选中操作系统类型“LINUX ON X86_64 64BIT”,再选中最新版本的Bundle Patch 12.2.0.1.220118 - 202202文件,点击加入下载篮按钮,最后通过SAP Download Manager下载相关文件:
将下载的Oracle Bundle Patch文件放入文件目录/sapcd/Oracle_12.2.0.1/MOPatch下
验证SAP软件签名
确认已安装SAP Host Agent并包含执行文件sapdsigner:
/usr/sap/hostctrl/exe/sapdsigner
下载SAP软件签名证书并放入文件目录/sapcd/Oracle_12.2.0.1/MOPatch下,文件授权777:
cd /sapcd/Oracle_12.2.0.1/MOPatch
wget https://tcs.mysap.com/crl/crlbag.p7s
或
curl https://tcs.mysap.com/crl/crlbag.p7s > crlbag.p7s
chmod 777 crlbag.p7s
切换到root用户和文件目录/sapcd/Oracle_12.2.0.1/MOPatch下,并执行SAP软件签名验证:
/usr/sap/hostctrl/exe/sapdsigner \
-crl crlbag.p7s -manifest SIGNATURE.SMF \
-verify SAP12201P_2202-70001555.ZIP
/usr/sap/hostctrl/exe/sapdsigner \
-crl crlbag.p7s -manifest SIGNATURE.SMF \
-verify GIRU12201P_2202-70001555.ZIP
/usr/sap/hostctrl/exe/sapdsigner \
-crl crlbag.p7s -manifest SIGNATURE.SMF \
-verify OPATCH12201P_2202-70001555.ZIP
设置操作系统环境要求
切换到orat73用户下并设置环境变量:
su - orat73
echo $ORACLE_HOME
echo $IHRDBMS
setenv IHRDBMS /oracle/T73/12201
echo $IHRDBMS
echo $OHRDBMS
setenv OHRDBMS /oracle/T73/122
echo $OHRDBMS
echo $ORACLE_SID
echo $LD_LIBRARY_PATH
echo $SBPFUSER
setenv SBPFUSER /bin/fuser
echo $SBPFUSER
执行命令unzip的版本要求是6.0或以上:
unzip -h | head -1
临时切换到Bourne shell来封装命令:
/bin/sh
# execute for-loop in Bourne shell
for i in 1 2 3; do echo $i; done
exit
安装升级OPatch和MOPatch
查看OPatch版本:
$ORACLE_HOME/OPatch/opatch version
查看MOPatch版本:
$ORACLE_HOME/MOPatch/mopatch.sh -h
切换到文件目录/sapcd/Oracle_12.2.0.1/MOPatch下:
cd /sapcd/Oracle_12.2.0.1/MOPatch
解压OPatch和MOPatch文件并安装:
mv $IHRDBMS/OPatch $IHRDBMS/OPatch-pre-SBP_12201220118_202202
unzip -qd $IHRDBMS OPATCH12201P_2202-70001555.ZIP -x SIGNATURE.SMF
unzip -qd $IHRDBMS/sapbundle SAP12201P_2202-70001555.ZIP 'SBP_12201220118_202202/MOPatch/*'
test -d $IHRDBMS/MOPatch && mv $IHRDBMS/MOPatch $IHRDBMS/MOPatch-pre-SBP_12201220118_202202
mv $IHRDBMS/sapbundle/SBP_12201220118_202202/MOPatch $IHRDBMS/MOPatch
确认升级后的OPatch版本(升级后版本必须是12.2.0.1.28或更新版本):
$ORACLE_HOME/OPatch/opatch version
确认升级后的MOPatch版本(升级后版本必须是2.7.9或更新版本)
$ORACLE_HOME/MOPatch/mopatch.sh -h
安装SAP Bundle Patch
在安装SAP Bundle Patch之前,请先关闭该数据库相关的所有SAP应用、数据库实例和监听。
检查SQL*Plus会话(如果显示任何SQL*Plus会话,请使用kill命令关闭对应的会话):
$SBPFUSER $IHRDBMS/bin/oracle
查看Oracle已安装的补丁信息:
$ORACLE_HOME/OPatch/opatch lsinventory
从上图看,Oracle数据库未安装任何补丁。
安装SAP Bundle Patch:
env ORACLE_HOME=$IHRDBMS $IHRDBMS/MOPatch/mopatch.sh -v -s SAP12201P_2202-70001555.ZIP
确认Oracle已安装的补丁信息:
$ORACLE_HOME/OPatch/opatch lsinventory
启动数据库实例和监听:
sqlplus / as sysdba
SQL> startup
SQL> quit
lsnrctl start
后处理步骤
执行后处理脚本catsbp:
env ORACLE_HOME=$OHRDBMS ORACLE_SID=$ORACLE_SID $OHRDBMS/sapbundle/catsbp
升级Oracle Recovery Manager Catalog:
rman catalog <user>/<pwd>@<servicename>
upgrade catalog;
upgrade catalog;
exit
调整参数_FIX_CONTROL和EVENT:
ALTER SYSTEM SET "_FIX_CONTROL"=
'5099019:ON','6055658:OFF','6120483:OFF','6399597:ON','6430500:ON','6972291:ON',
'7324224:OFF','7658097:ON','8932139:ON','8937971:ON','9196440:ON','9495669:ON',
'13627489:ON','14255600:ON','14595273:ON','18405517:2','20107874:ON','20355502:10',
'20636003:OFF','22540411:ON','22746853:ON','23197730:ON','23643560:ON',
'23738553:ON','25476149:ON','25643889:ON','26423085:ON','26536320:ON','27321179:ON',
'27466597:ON','28072567:ON','28602253:ON','29450812:ON','29687220:ON','29930457:ON','31444353:1'
COMMENT='SAP_12201201020_202011 RECOMMENDED SETTINGS'
SCOPE=SPFILE;
ALTER SYSTEM SET EVENT=
'10027',
'10028',
'10142',
'10183',
'10191',
'10995 level 2',
'38068 level 100',
'38085',
'38087',
'44951 level 1024',
'60025'
COMMENT='SAP_12201171017_201711 RECOMMENDED SETTINGS'
SCOPE=SPFILE;
重启数据库使参数生效:
shutdown immediate;
startup;
然后启动SAP应用。
参考
过程步骤请参考文件README12201P_2202-70001555.HTM。