Issue: click on any form in the apps env and users were getting the below message.
Seems session is getting killed.
No useful information from the forms logs except the session dump file after session got killed.
No errors were reported in the database parameter file.
1) Didn’t work.
processes integer 200
SQL> select count(*) from v$session;
Raised the process & sessions in the DB but this didn’t help
2) As per ORA-01001 When Clicking Cancel-Query Button [ID 436537.1]
profile option is not set in our environment. so this is not the issue.
For NON-RAC environments perform the following actions:
1. Add SDU=32767 in the listener.ora of db tier, and the
2. Add SDU=32767 in the tnsnames.ora at middle tier, then bounce the db and listener after that.
Added the SDU in the listener and tnsnames files on both dbserver & app server and this fixed the issue. ( I didn’t bounce anything after adding the SDU).
Now we are not getting any exception error messages but the jobs are going to pending state.
Here I brought apps down and ran the cmclean.sql in the database and this helped clear the conc hung state and jobs were going to completion.