13 February, 2019

Check whether the patch applied or not

select apd.driver_file_name, to_char(apd.creation_date,'DD-MON-YYYY:HH24:MI:SS') "Started",
to_char(apd.last_update_date,'DD-MON-YYYY:HH24:MI:SS') "Last_Updated",apd.DRIVER_TYPE_C_FLAG "C", 
apd.DRIVER_TYPE_D_FLAG "D", apd.DRIVER_TYPE_G_FLAG "G" , apd.MERGED_DRIVER_FLAG "Merged", 
apdl.language "Language" from ad_patch_drivers apd,ad_patch_driver_langs apdl 
where apd.patch_driver_id=apdl.patch_driver_id and apd.driver_file_name like '%&Patch_Number%';

The System has encountered an error when servicing the request. Please try again. If the error persists, please contact the system administrator.



Error Message:


Noticed below error while login to EBS



Below is the exception from logs:


java.lang.NoClassDefFoundError: Could not initialize class oracle.apps.fnd.functionSecurity.User




Exception in static block of jtf.cache.CacheManager. Stack trace is: oracle.apps.jtf.base.resources.FrameworkException: IAS Cache initialization failed.
Caused by: java.lang.RuntimeException: oracle.apps.jtf.base.resources.FrameworkException: Cache not initialized
Caused by: oracle.apps.jtf.base.resources.FrameworkException: IAS Cache initialization failed.




We have noticed that the distributed Caching System is failing to initialize on port: 12345 due to “java.lang.RuntimeException: oracle.apps.jtf.base.resources.FrameworkException” exception.



The list of hosts in the distributed caching system are :

1. hostname_1

2. hostname_2 
3. hostname_3 
4. hostname_4 
5. hostname_5


We have to make sure the port 12345 should be free on each host running the JVMs.


Below is the action plan to resolve this issue:

  Shut down the application services

 Check the java cache port number is still accessing or not.

[applmgr@hostname_1 logs]$ netstat -ntpl |grep 12345

tcp        0      0 ::ffff:10.2.128.101:12345   :::*                        LISTEN      19210/java


 Find the process for this port number and kill the process.


[applmgr@hostname_1 logs]$ ps -ef | grep 19210

Kill -9 19210


 Start the application services.


Useful Scripts

To Find session details using SID. set verify off col sid format 99999 col machine format a10 col program format a25 trunc col username form...