Showing posts from January, 2018

Finding EBS/Oracle Apps Version

We can use below query to identify Oracle Application Version. SQL> select release…

Read more

Apply WLS Patches using BSU

Below are few important commands to apply weblogic patches using BSU. Steps: Dow…

Read more

Understanding FS Clone in ADOP

Apart from the regular patching ADOP also provides a phase known as FS Clone.  FS clon…

Read more

Query to check if Patch applied to Patch Edition

We can use the below tables to validate if the patch has been applied to the patch editi…

Read more

Understanding Different Phases for ADOP

In the previous post, we have seen an overview about ADOP . Now we will try to understan…

Read more

ADOP : Application DBA Online Patching

With R12.2 EBS, Oracle has launched online application patching feature which helps to r…

Read more

Finding the Weblogic URL and Port from R12.2 Context File

We can find the weblogic URL and port from the CONTEXT_FILE by using the below variable.…

Read more

Query To Find OPP Log File for a Request ID and File Location

We can use below query to find the OPP log for a request ID and its path. SELECT fcpa.…

Read more