Re: error on framework pages

Posted by raiq1 on Apr 15, 2022; 2:59am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/error-on-framework-pages-tp10834p10843.html

Hi erman sir,

I have faced this problem after idle for some time and EBS Front page are getting error.

in the exception log, java.sql.SQLException: ORA-02396: exceeded maximum idle time, please connect again.

Just checked the alert log file for 19c database, there is an messages in the log.


(3):KILL SESSION for sid=(950, 64468):
(3):  Reason = profile limit idle_time
(3):  Mode = KILL SOFT -/-/NO_REPLAY
(3):  Requestor = PMON (orapid = 2, ospid = 1590, inst = 1)
(3):  Owner = Process: USER (orapid = 299, ospid = 16548)
(3):  Result = ORA-0

2022-04-15T01:41:54.348647+03:00
(3):KILL SESSION for sid=(116, 20112):
(3):  Reason = profile limit idle_time
(3):  Mode = KILL SOFT -/-/NO_REPLAY
(3):  Requestor = PMON (orapid = 2, ospid = 1590, inst = 1)
(3):  Owner = Process: USER (orapid = 325, ospid = 19435)
(3):  Result = ORA-0

2022-04-15T01:44:00.684592+03:00
(3):KILL SESSION for sid=(28, 33407):
(3):  Reason = profile limit idle_time
(3):  Mode = KILL SOFT -/-/NO_REPLAY
(3):  Requestor = PMON (orapid = 2, ospid = 1590, inst = 1)
(3):  Owner = Process: USER (orapid = 321, ospid = 19377)
(3):  Result = ORA-0


I think process are killing and this is the reason that EBS page are not open. what is your advice to prevent this error.

Kindly guide me  to solve this issue , for your review please check the attached log file.error_exception.txt

Regards,
Raiq