Oracle Bundle Patch

Thursday, April 8, 20108comments

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 + 8 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

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