IT/Database

Oracle 19c SAP Bundle Patch 19.29.0.0.251021 - 202511

SAP_BASIS 2025. 12. 1. 17:24

Set Enviroment Variable

setenv IHRDBMS /oracle/TC2/19.0.0
setenv OHRDBMS /oracle/TC2/19

 

 

Prepare media

 

 

Extract OPatch and MOPatch

mv $IHRDBMS/OPatch $IHRDBMS/OPatch-pre-SBP_192900251021_202511
unzip -qd $IHRDBMS OPATCH19P_2511-70004508.ZIP -x SIGNATURE.SMF
unzip -qd $IHRDBMS/sapbundle SAP19P_2511-70004508.ZIP 'SBP_192900251021_202511/MOPatch/*'
test -d $IHRDBMS/MOPatch && mv $IHRDBMS/MOPatch $IHRDBMS/MOPatch-pre-SBP_192900251021_202511
mv $IHRDBMS/sapbundle/SBP_192900251021_202511/MOPatch $IHRDBMS/MOPatch

 

 

Check Version: OPatch 12.2.0.1.47 and MOPatch 2.12

ora19:oratc2 79> $ORACLE_HOME/OPatch/opatch version
========================================================
GENERIC OPATCH VERSION - FOR USE IN SAP ENVIRONMENT ONLY
========================================================
OPatch Version: 12.2.0.1.47

OPatch succeeded.

ora19:oratc2 80> $ORACLE_HOME/MOPatch/mopatch.sh -h
Invalid or incomplete option specified.
Usage: mopatch [-hvdn] [-o opatch-param] [-j jre]
               [-m make-utility] [-z unzip-utility]
               [-s patch-source-path] [patch-work]

Options:
  -h    show a short command-line overview.  See SAP Note 1027012 for
        complete documentation.
  -v    be verbose; produce more diagnostic output
  -d    dryrun mode; do not deinstall or install any patches

  -s sap-bundle-patch-path
        Install the specified SAP Bundle Patch.  Must be specified exactly
        once.

This utility requires environment variable ORACLE_HOME to be set.

MOPatch - Install Multiple Oracle Patches in One Run - 2.12.
Copyright (c) 2007, 2025, Oracle and/or its affiliates. All rights reserved.

 

 

Temporarily change to super user

su root -c "chown `id -u` $IHRDBMS/bin/oradism && chmod u+rw $IHRDBMS/bin/oradism"

 

Install SAP Bundle Patch

env ORACLE_HOME=$IHRDBMS $IHRDBMS/MOPatch/mopatch.sh -v -s SAP19P_2511-70004508.ZIP

 

 

Temporarily change to super user

su root -c "chown root $IHRDBMS/bin/oradism && chmod 4750 $IHRDBMS/bin/oradism"

 

 

Set recommedned parameter

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','13699643:OFF','14255600:ON','14595273:ON','18405517:2','20355502:10',
'20636003:OFF','22387320:ON','22540411:ON','23220873:ON','23738304:OFF','24561942:ON',
'25643889:ON','26536320:ON','27321179:ON','27466597:ON','28173995:ON','28234255:3',
'28414968:3','28498976:ON','28558645:ON','28602253:ON','28708585:ON','28835937:ON',
'28999046:ON','29302565:ON','29304314:ON','29385774:ON','29450812:ON','29487407:ON',
'29687220:ON','29867728:ON','29930457:ON','30008456:ON','30018126:ON','30142527:ON',
'30195773:ON','30231086:ON','30235691:ON','30249927:ON','30470947:ON','30483217:ON',
'30537403:ON','30751171:ON','30758835:ON','30776676:ON','30786641:ON','30887435:ON',
'31009032:ON','31072746:ON','31082719:ON','31143146:ON','31266779:ON','31444353:1',
'31487332:ON','31496840:ON','31579233:ON','31821701:ON','31961578:ON','31988833:ON',
'32014520:ON','32107621:ON','32205825:ON','32212062:ON','32302470:ON','32321289:ON',
'32396085:ON','32408640:ON','32578113:ON','32614157:ON','32851615:ON','32874571:ON',
'33297275:ON','33303725:ON','33369863:ON','33547527:ON','34605396:ON','34610498:ON',
'35233495:ON','35330506:ON','35465301:ON','35751181:ON','36004815:OFF','36040099:ON',
'36373163:ON','36446103:ON','36527753:ON','36698344:ON','36769534:ON','36936899:ON',
'36994814:ON','37129294:ON','37651954:ON','37818321:ON'
COMMENT='SAP_192900251021_202511 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',
'34011029 level 7'
COMMENT='SAP_192000230718_202308 RECOMMENDED SETTINGS'
SCOPE=SPFILE;