In SAP environment, MOPatch is very helpful and it has bundle patchs (SBP). Using this tool we can install multiple patches at single run, it will automate the oracle patching processes. However, note that MOPatch internally calls OPatch to install patches.
Pre-checks
- Make sure you have enough space in $ORACLE_HOME file system
- Take a Tar or backup of $ORACLE_HOME
- Install latest Opatch and MOpatch (in case of SAP)
$ unzip -qd $ORACLE_HOME OPATCH12201P_2008-70001555.ZIP -x SIGNATURE.SMF
$ unzip -qd $ORACLE_HOME/sapbundle SAP12201P_2011-70001555.ZIP 'SBP_12201201020_101020/MOPatch/*'
$ test -d $ORACLE_HOME/MOPatch && mv $ORACLE_HOME/MOPatch $ORACLE_HOME/MOPatch-pre-SBP_12201201020_101020
$ mv $ORACLE_HOME/sapbundle/SBP_12201201020_101020/MOPatch $ORACLE_HOME/MOPatch
- check the version of MOPatch & Opatch version
$ORACLE_HOME/OPatch/opatch version
Execution
- Stop all database applications
- Backup the database and related files
- Shut down the databases, listeners, and other processes running from the Oracle Home, use the fuser OS command to check for stale SQL*Plus sessions: $SBPFUSER $ORACLE_HOME/bin/oracle
- Install the patch –
For SAP systems using MOPatch
env ORACLE_HOME=$ORACLE_HOME $ORACLE_HOME/MOPatch/mopatch.sh -v -s SAP12201P_2011-70001555.ZIP
You should see a message
MOPatch completed successfully
Overall Status : COMPLETE
env ORACLE_HOME=$ORACLE_HOME $ORACLE_HOME/MOPatch/mopatch.sh -v -s SAP12201P_2011-70001555.ZIP
You should see a message
MOPatch completed successfully
Overall Status : COMPLETE
For Other Oracle Systems using Opatch
$ cd /opt/patches/<patch number>
$ opatch apply
You should see a message
Opatch completed successfully
Overall Status : COMPLETE
Post-Checks
- Start the database and verify the database processes and logs. The logs should not have any error messages
- Run the post patch update steps for SAP system
- Apply _FIX_CONTROL, EVENT parameters if required.
Ex:- ALTER SYSTEM SET "_FIX_CONTROL"='4545454:ON','4547778:OFF',……. COMMENT='SAP_12201201020_101020' SCOPE=SPFILE;
Where EVENT, initialization parameter will be used to generate information in form of a trace file in the context of the event. The trace file is located in a directory specified by the parameter USER_DUMP_DEST
ALTER SYSTEM SET EVENT= '10027','10028', '10142' COMMENT='SAP_12201171017_101020' SCOPE=SPFILE;
- Restart the database and Take a backup
- Start the application and check the application
- Known issues related to the installation of Database Release Update 12.2.0.1.201020 and the other patches contained in this SBP are described in SAP Note 2507228 Database: Patches for 12.2.0.1.
- Known issues related to the Oracle installation utilities, including MOPatch, OPatch, and the Oracle Universal Installer, are described in SAP Note 1915299 Troubleshooting Software Installation (12.1/12.2).
Please refer Oracle documentation
https://docs.oracle.com/cd/E24628_01/doc.121/e39376/opatch_overview.htm
https://docs.oracle.com/cd/E24628_01/doc.121/e39376/opatch_overview.htm
Oracle Help Center
https://docs.oracle.com/cd/E25290_01/doc.60/e25224/patchesupdates.htm
Welcome back Jasola escort This is how I am able to keep my clients satisfied. If you have any sex-related fantasy in your mind, all you have to do is to tell me about it. I am able to provide real girlfriend experiences to my clients. You can fulfill your long-standing desire of caressing and eating the white tits and ass of a white woman by hiring my services. I can make you forget all the worries of your personal life with my skills and performance on the bed. I can make you forget all the worries of your personal life with my skills and performance on the bed.Jasola escorts
ReplyDeleteA fantastic blog with excellent information and valuable content just added your blog to my bookmarking sites thank you for sharing.
ReplyDeleteData Science Course in Chennai
Excellent article! In any case, on the off chance that you need to make more substance, you can attempt Article Forge. Article Forge is a well versatile composing computerization stage that manages its work genuinely well with creating good quality articles. This tools might help you in generating more content!
ReplyDelete
ReplyDeleteAwesome article. I enjoyed reading your articles. this can be really a good scan for me. wanting forward to reading new articles. maintain the nice work!
Data Science Courses in Bangalore
The success of each and every campaign is dependent on the effectiveness of online advertising and SEO software tools. SEO Group Buy Tools is an ideal choice to buy affordable SEO softwares and software tools which are offered at reasonable rates. This SEO group buy SEO tools helps in making money and also make money online with affordable SEO marketing tools
ReplyDeleteI feel very grateful that I read this. It is very helpful and very informative and I really learned a lot from it.
ReplyDeleteDevOps Training in Hyderabad
Enormous database upheld projects require the information planner range of abilities and the undertaking director ought to guarantee that the individual alloted to this job on the task has the designer range of abilities and experience.
ReplyDelete