Davis Apps DBA

In my environment we are having EBS(12.2.5) running with 12.1.0.2 database. One day in our DEV Instance  Front-End is not opening and faced the below error. So I followed the below steps as a solution and it worked. First, generate the JAR files Next, reload the generated jar files to the respective database  Now compile the APPS schema to reduce the count of Invalid objects. Once everything completed, you can clear your browser cache and try to login to the application., but normally the above steps will be accompanied by clearing the middle tier cache. So I gave the below steps to clear the middle tier cache from backend. To clear the cache, follow the below steps. Stop the application services Navigate to $OA_HTML/cabo/images/cache Take a backup of contents of the folder cache and then clear all the contents inside that cache folder Navigate to $OA_HTML/cabo/styles/cache Take a backup of contents of the folder ca...

In this post, we'll see how to run Gather Schema Statistics with Auto option. My Env: Oracle DB   : 12.1.0.2 Oracle EBS : 12.2.5 One important aspect of a healthy Oracle database is database statistics. It’s the main data on which CBO feeds to generate good execution plans for SQLs. Implementing a periodic and consistent gather statistics procedure in Oracle E-Business Suite is every Applications DBA’s duty. But often I see that they are not set up properly to take advantage of the latest database features.  So let’s take advantage of new features around gathering database statistics. GATHER AUTO : Initially introduced in 11gR2 as DBMS_STATS.AUTO_SAMPLE_SIZE, which yields a significant reduction in the time it takes to collect highly accurate statistics. Oracle decides which objects to gather fresh statistics for and also decides how to get them.  Oracle determines the estimate percent to be used.  The parallelism used is based on the  init....

Use the below query to identify which patches you already applied to keep your patch wizard updated.  Based on your Oracle EBS Version use the respective query to identify your patch wizard status. --Check for the Latest 11i Patch Wizard Patches Applied Select Bugs.Bug_Number as PATCH, Decode(Bugs.Bug_Number, 10405353, '10405353 for Release 11i (included in RECOMMENDED patch 14350791)', 15998913, '15998913 for Release 11i (included in RECOMMENDED patch 14350791)', 10123716, '10123716 for Release 11i (included in RECOMMENDED patch 14350791)', 14350791, '14350791 for the latest RECOMMENDED version of Patch Wizard in Oracle E-Business Suite (Release 11i)') as "11i Patch Wizard Patches", decode(Ad_Patch.Is_Patch_Applied('11i',-1,bugs.bug_Number),'EXPLICIT','APPLIED','NOT APPLIED') as APPLIED From  (select '10405353' as bug_number From Dual UNION ALL  select '15998913' as bug_number fro...

When you going to run Patch Wizard : Impact Analysis for the first time, follow the below step by step process. Download the Patch Information Bundle from the MOS document ' 741129.1 ' as given below Create a staging directory as below Copy the InfoBundleZip to staging directory we declared above Now start the patch impact analysis for the entire EBS application using the bundle patch.  Once the concurrent request is submitted, you can monitor the status from the respective log created for the request. The request you submitted for the patch impact analysis will submit a child request which inturn creates many requests to check all the products for the compliance of codelevel and other patchset level. Based on this analysis only the final impact report will be generated. Technically speaking this will not create the impact analysis report, rather it will create the patches already applied and the patche...