Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

Saturday, May 4, 2019

How to list the applied Patches in Weblogic:

To find List the applied patches in weblogic,do the following.

For Versions Prior 10.3:

Go to your MW_HOME/utils/bsu directory
Run the following command

./bsu.sh -report

Note* If you get any error like “unable to access patch-client.jar” – Execute the setWLSEnv.sh from WL_HOME/server/bin script and retry

For weblogic 12c and above:

Goto MW_HOME/OPatch/ directory
Run the following command
./opatch lspatches

If you are not aware of what is your MW_HOME and what is your WL_HOME.

Look for the weblogic.jar file in your filesystem

$ find /apps -name "weblogic.jar"
/apps/oracle-weblogic/wls12213/wlserver/server/lib/weblogic.jar

WL_HOME = Parent directory of server/lib/weblogic.jar 

therefore /apps/oracle-weblogic/wls12213/wlserver/ is WL_HOME

MW_HOME = Parent directory of WL_HOME

therefore /apps/oracle-weblogic/wls12213 is my MW_HOME

Ways To Find Oracle Weblogic Version:

There are at least 3 different ways to find the version of Oracle Weblogic Server:


1.Using the registry.xml file located in your MW_HOME directory.
Look for a line similar to:
<component name=”WebLogic Server” version=”10.3.4.0″ InstallDir=”/u01/weblogic/Oracle/Middleware/wlserver_10.3″>

2.Using the .product.properties file located in your WLS_HOME directory.
example: /u01/weblogic/Oracle/Middleware/wlserver_10.3 or E:\Oracle\Middleware\wlserver_10.3
Look for a line similar to:
WLS_PRODUCT_VERSION=10.3.4.0

3.Using the Oracle Weblogic Server Administration Console
Use the left hand menu to navigate to Environment -> Servers.� Then, click the [Monitoring] tab. You should see a screen similar to the one below:

Friday, May 3, 2019

Apply patches in 12.2 in downtime mode

Check Patches:
SELECT DISTINCT RPAD(a.bug_number,
11)|| RPAD(e.patch_name,
11)|| RPAD(TRUNC(c.end_date),
12)|| RPAD(b.applied_flag, 4)  BUG_APPLIED
FROM
apps.ad_bugs a,
apps.ad_patch_run_bugs b,
apps.ad_patch_runs c,
apps.ad_patch_drivers d ,
apps.ad_applied_patches e
WHERE
a.bug_id = b.bug_id AND
b.patch_run_id = c.patch_run_id AND
c.patch_driver_id = d.patch_driver_id AND
d.applied_patch_id = e.applied_patch_id AND
a.bug_number in  ('23199810','22748721')
ORDER BY 1 DESC;

select ADOP_SESSION_ID, BUG_NUMBER, STATUS, APPLIED_FILE_SYSTEM_BASE, PATCH_FILE_SYSTEM_BASE, ADPATCH_OPTIONS, NODE_NAME, END_DATE, CLONE_STATUS
from ad_adop_session_patches
order by end_date desc;

Precheck: Spool in file

select count(*) from dba_objects where status='INVALID';

select object_type,count(*) from dba_objects where status='INVALID' group by object_type;



Apply patches in 12.2 in downtime mode::::::::::::::

Bring down services: and start with below:

adop phase=apply patches=22748721 apply_mode=downtime

In case of many patch with merge option:

adop phase=apply patches=23199810,23199810_PTB:u23199810.drv,23199810_DK:u23199810.drv,23199810_NL:u23199810.drv,23199810_F:u23199810.drv,23199810_D:u23199810.drv,23199810_HU:u23199810.drv,23199810_I:u23199810.drv,23199810_PL:u23199810.drv,23199810_PT:u23199810.drv,23199810_RU:u23199810.drv,23199810_ZHS:u23199810.drv,23199810_E:u23199810.drv,23199810_ZHT:u23199810.drv merge=yes apply_mode=downtime