Oracle Apps Patch FAQ

Google
 
Web teachmeoracle.com
Home Overview Architecture Installation Patching Training Feedback
 
My Blog
WebServer
Concurrent
Autoconfig
Cloning
Training
Apps Interview Q's
Tuning
Contact Us
 
 
My Favourites
Health Check 11i
11i Interview Q's
 
 
       

Q. How to find Apps Version in 11i ?

Run following SQL from apps user ;
SQL> select RELEASE_NAME from fnd_product_groups;
You should see output like
RELEASE_NAME
-----------------------
11.5.10.2
Which means you are on Apps Version 11.5.10.2

 Q. How to check if a patch is applied or not ?

Patch information in 11i is stored in AD_BUGS & AD_APPLIED_PATCHES table . You can query like

SQL> select bug_number from AD_BUGS where bug_number ='&patch_no';

Alternatively you can check patch information from OAM (Oracle Application Manager).

    Q. Where to find adpatch log files ?

Patch log files will be in directory $APPL_TOP/admin/$SID/log
like adpatchXXX.log ( file name you mentioned while patching ), adworkXXX.log for worker log files,

 
Previous Page
 

Oracle Apps 11i | Oracle Portal | Collaboration Suite | My Blog
Copyright © teachmeoracle.com
This work is copyright protected, Copying content from this site is illegal