DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Thursday, March 1, 2012

Steps to Debug Oracle Patch Failure in Oracle Applications

-->
Following are the steps to debug Patch failures in Oracle applications

1) Check the patch log file :

 Log file for adpatch or apps patch will exist as specified while running adpatch The default location is $APPL_TOP/admin/SID/log with name adpatch.log.


2) See on which worker the Patch has failed.
Check the Worker log for the failed Worker at the same location ($APPL_TOP/admin/SID/log) by the name adwork<worker_number>.log
Based on the error in the log , fix the problem ; Use adctrl ; select option restart failed worker & then give worker number you want to restart to confirm if problem is fixed.
Types of files

a) odf files : Object Definition Files

-odf files are there to create tables ,indexes and view etc.

Types of files
a) odf files : Object Definition Files

-odf files are there to create tables ,indexes and view etc.

a) odf files : Object Definition Files
-odf files are there to create tables ,indexes and view etc.

-odf files are there to create tables ,indexes and view etc.
b) pls scripts :

-If the failed pls scripts are for creating stored procedure or packages

b) pls scripts :
-If the failed pls scripts are for creating stored procedure or packages

-If the failed pls scripts are for creating stored procedure or packages
c) sql Scripts:
-Failure on the SQL Script

-Failure on the SQL Script
d) WFLOAD and FNDLOAD failure- Look for the error message in the log file of the worker that fails.


d) WFLOAD and FNDLOAD failure- Look for the error message in the log file of the worker that fails.



1) Try to execute the failing sql / pls manually and see the results

2) Check the Alert Log

If any of the workers failed due to insufficient tablespace, then add the space , restart the failed worker.

3) Check the database session waits - There could be enqueues.

1) Try to execute the failing sql / pls manually and see the results
2) Check the Alert Log

If any of the workers failed due to insufficient tablespace, then add the space , restart the failed worker.

3) Check the database session waits - There could be enqueues.

2) Check the Alert Log
If any of the workers failed due to insufficient tablespace, then add the space , restart the failed worker.

3) Check the database session waits - There could be enqueues.

If any of the workers failed due to insufficient tablespace, then add the space , restart the failed worker.
3) Check the database session waits - There could be enqueues.

3) Check the database session waits - There could be enqueues.
Check the locks and locked objects to ensure that the session applying the patch is now waiting on a lock. If so need to diagnose , kill the session holding the lock.
(Scripts for database Diagnosis provided in the database Scripts Section)
4) For WFLOAD and FNDLOAD

4) For WFLOAD and FNDLOAD
5) If adpatch fails to generate reports or forms. it is ok to skip these failure as you can always regenerate them after patching.

6) If it fails for a Pre-req patch and a lot of downtime has already lapsed :

5) If adpatch fails to generate reports or forms. it is ok to skip these failure as you can always regenerate them after patching.
6) If it fails for a Pre-req patch and a lot of downtime has already lapsed :

6) If it fails for a Pre-req patch and a lot of downtime has already lapsed :


If you want to skip a worker , this option is not visible & do it using adctrl option 8 . It is not a good idea to skip the failed worker without consulting from oracle.


If you want to skip a worker , this option is not visible & do it using adctrl option 8 . It is not a good idea to skip the failed worker without consulting from oracle.

If you want to skip a worker , this option is not visible & do it using adctrl option 8 . It is not a good idea to skip the failed worker without consulting from oracle.

If you want to skip a worker , this option is not visible & do it using adctrl option 8 . It is not a good idea to skip the failed worker without consulting from oracle.


To Note that Workers are controlled by adctrl.


There can be different types of files / errors causing job failures :




Resolution:

You need to look at the log file generated by the above command. The worker’s logfile should point you to the location of the log file.
Adpatch Fails due to Pre req Patch

1 comment:

Sridevi K said...

Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.