Oracle Bundle Patch

Thursday, April 8, 201014comments

How to Apply Oracle Bundle Patch


Download the dump from SAP service market place to your system.

1.PRE INSTALLATION INSTRUCTIONS

 Copy the dumps of patch at below mentioned path.

Drive/oracle/"SID"/"oracle version"/OPatch


 Stop SAP & DB along with all services of SAP & DB.

 Back up the current database that is installed, the %ORACLE_HOME% directory and Oracle inventory under c:\Program files\oracle directory. (This will help if there are problems applying the patch, and to restore the Inventory in case of an issue with the patch.)

 Now apply bundle patch.

OPatch>opatch apply patch no

 Installation may be interrupted coz. of error in overwriting an existing .dll file giving following error file already in use.

In case of above error don’t rename the file and RETRY(It doesn’t work) instead cancel the installation then and there rename the .dll file and start patch application again.

3. POST INSTALLATION INSTRUCTIONS

 Start all services of DB & DB

 Run script catcpu.sql

sqlplus /nolog

SQL> CONNECT / AS SYSDBA

SQL> STARTUP

SQL> @%ORACLE_HOME%\Bundle\Patch17\catcpu.sql

SQL> QUIT

 If above script reports any error then

Inspect the logfile %ORACLE_HOME%\Bundle\Patch17\Apply__.log for any errors.

 If catcpu.sql reports any Invalid Objects, compile the invalid objects as follows.

sqlplus /nolog

SQL> CONNECT / AS SYSDBA

SQL> @%ORACLE_HOME%\rdbms\admin\utlprp.sql 0

Above script will compile the invalid objects.

 To check for any invalid objects still there or not, execute the following statement:

SQL> SELECT OBJECT_NAME FROM DBA_OBJECTS WHERE STATUS = 'INVALID';

 Recompiling Views in the Database

To recompile the views for each database instance running out of the ORACLE_HOME being patched , follow these steps:

 Run the pre-check script, which reports the maximum number of views and objects that may be recompiled:

sqlplus /nolog

SQL> CONNECT / AS SYSDBA

SQL> @%ORACLE_HOME%\Bundle\view_recompile\ recompile_precheck_jan2009cpu.sql

SQL> QUIT

 Run the view recompilation script. Note that this script is run with the database in upgrade mode, which restricts connections as SYSDBA.

sqlplus /nolog

SQL> SHUTDOWN

SQL> CONNECT / AS SYSDBA

SQL> STARTUP UPGRADE

SQL>@%ORACLE_HOME%\Bundle\view_recompile\

view_recompile_jan2008cpu.sql

SQL> SHUTDOWN;

SQL> STARTUP;

 Check the log file for any errors. The log file is in the current directory and is named: vcomp__.log

 If any invalid objects were reported, run the utlrp.sql script as follows:

sqlplus /nolog

SQL> CONNECT / AS SYSDBA

SQL> @%ORACLE_HOME%\rdbms\admin\utlrp.sql

 If still any invalid objects are there then recompile those manually.

SQL> alter schemaname. compile;

 Verify that the view recompilation has been performed for the database, by executing the following statement:

SELECT * FROM registry$history where ID = '6452863';

TO VIEW ALL PATCHES APPLIED ISSUE BELOW COMMAND:-

\ORACLE\"SID"\"oracle version"\OPATCH>OPATCH LSINVENTORY


Share this article :

+ comments + 14 comments

August 17, 2015 at 7:13 AM

Pretty good post. I just came across your site and wanted to say that I’ve really enjoyed reading your posts. In any case I’ll be subscribing to your feed and I hope you will keep a good work!Cheer!


sap online training
software online training
sap sd online training
hadoop online training
sap-crm-online-training

August 17, 2015 at 7:14 AM

This is one awesome blog article. Much thanks again.
I really enjoy the blog.Much thanks again. Really Great.


oracle online training
sap fico online training
dotnet online training
qa-qtp-software-testing-training-tutorial

January 14, 2017 at 7:31 AM

Thanks for sharing great information in your blog. Got to learn new things from your Blog . It was very nice blog to learn about SAP BASIS.
Call us at 8122241286.
SAP basis

January 20, 2017 at 9:49 PM

Ad 7 SAP BASIS
It was very nice blog to learn about SAP BASIS. Thanks for sharing
We provides Best SAP BASIS. Training in Chennai with real time project assistance by our leading SAP BASIS. Consultant.
For Free Live Demo @ Call to 8122241286.
SAP MM, SAP SD, SAP HR,SAP FICO 
www.thecreatingexperts.com 
.SAP basis

Anonymous
June 29, 2017 at 6:33 AM

The Creating Experts is the leading trainer in SAP BASIS so, if you are looking for one here is the link

http://thecreatingexperts.com/sap-basis-training-in-chennai/

contact +91-08122241286

Anonymous
July 2, 2017 at 10:37 PM

SAP BASIS training is provided in CHENNAI.

THE CREATING EXPERTS is one of the leading trainer in SAP who provides real time training

http://thecreatingexperts.com/sap-basis-training-in-chennai/

contact 8122241286

Anonymous
July 14, 2017 at 5:55 AM

Nice blog....For a long time I was looking for SAP BASIS training in Chennai and got the link


THE CREATING EXPERTS is providing SAP BASIS training in real time

http://thecreatingexperts.com/sap-basis-training-in-chennai/

Contact 8122241286

Anonymous
July 15, 2017 at 4:03 AM

SAP BASIS training is provided in CHENNAI.I personally got trained with them one of the best trainers in CHENNAI

THE CREATING EXPERTS is one of the leading trainer in SAP who provides real time training

http://thecreatingexperts.com/sap-basis-training-in-chennai/

contact 8122241286

July 21, 2017 at 1:24 AM

Informative post...for a long time I was searching for a trainer in Chennai

And i landed with THE CREATING EXPERTS one of the leading trainer with real time training in Chennai

http://thecreatingexperts.com/sap-basis-training-in-chennai/

contact 8122241286 for more info.

Anonymous
July 27, 2017 at 7:22 AM

SAP basis training by THE CREATING EXPERTS

http://thecreatingexperts.com/sap-basis-training-in-chennai/

contact 8122241286 for more info.

If you are looking for SAP basis here is a real time trainer to get trained from.

Anonymous
July 28, 2017 at 9:03 AM

Creating experts, A leading career development organization with live examples by corporate Experts.

SAP training by online and classroom training is provided

http://thecreatingexperts.com/sap-basis-training-in-chennai/


Contact 8122241286 SAP basis training in chennai

Anonymous
July 30, 2017 at 2:01 AM

The Information you provided is very much useful for SAP Learners. This Information was very Interesting,

SAP training in Chennai by THE CREATING EXPERTS for SAP BASIS, take a look at the link below

http://thecreatingexperts.com/sap-basis-training-in-chennai/

contact 8122241286 for more info.

May 16, 2019 at 5:22 AM

thanks for sharing this information and if u want to know more about Watch Online TV for Free then pls visit us

April 28, 2020 at 11:39 PM

Tech Data Solution is one of the best Institute in Mumbai & Pune, who provide various courses such as Business Analytics, R, RPA, Blockchain, Python and Sas training course in Mumbai & Pune.
Data science course in pune
Data science course in Mumbai
best data science course in pune with placement
https://business.google.com/u/2/dashboard/l/17555097694249492665
Machine learning course in pune
Machine learning course in Mumbai

Post a Comment
 
Support : Basis SAP | Basis SAP | Basis SAP
Copyright © 2011. Basis SAP - All Rights Reserved
Template Created by Basis SAP Published by Basis SAP
Proudly powered by Blogger