Oracle Bundle Patch

Thursday, April 8, 201020comments

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 + 20 comments

April 19, 2010 at 10:37 PM

nice job! waiting for your new artical. ........................................

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

May 4, 2016 at 11:32 PM

Thanks for the great information ,was looking for this information from long.Great blog SAP Basis Training in Chennai

August 22, 2016 at 11:57 PM

Great place to learn new things and got the best SAP BASIS Training in Chennai

December 5, 2016 at 3:28 AM

SAP MM,SD, real Time Training in Chennai
We provides Best SAP MM,SD Training in Chennai wih real time project assistance by our leading Materail Management Consultant.
For Free Live Demo @ Call to 8122241286.
www.thecreatingexperts.com
SAP MM
SAP SD

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

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

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

July 11, 2017 at 11:56 PM

SAP BASIS Training in Chennai is provided by

THE CREATING EXPERTS they provide hands on training with real time scenarios

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

contact 8122241286 for more info

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

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.

July 22, 2017 at 1:55 AM

SAP BASIS training is provided by THE CREATING EXPERTS

If you are looking for a real time trainer then take a look at the mail below

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

contact 8122241286

July 22, 2017 at 5:54 AM

SAP BASIS training is provided by THE CREATING EXPERTS

If you are looking for a real time trainer then take a look at the mail below

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

contact 8122241286

July 24, 2017 at 2:27 AM

SAP BASIS training is provided by THE CREATING EXPERTS

If you are looking for a real time trainer then take a look at the mail below

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

contact 8122241286

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.

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

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.

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