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;'IT > Database' 카테고리의 다른 글
| Error in invoking target 'libasmclntsh19.ohso libasmperl19.ohso client_sharedlib' of makefile ins_rdbms.mk (0) | 2025.12.01 |
|---|---|
| Error in invoking target 'agent nmhs' of makefile '$ORACLE_HOME/sysman/lib/ins_emagent.mk'. (0) | 2025.11.26 |
| Fail to install oracle on linux (0) | 2024.05.13 |
| Oracle 11g Upgrade (1) | 2016.11.23 |
| 오라클 테이블스페이스 사용량 조회 (0) | 2014.04.22 |