Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

****************Got the opportunity to pen a Book on Database Cloud Services.......More details to follow.***************

Title : Database Cloud Revealed
Publisher : Apress
Release Date : Jan-2021


My Cloud Certifications:

AWS Certified Solutions Architect Associate

Azure Certified Architect Expert

Azure Certified Architect

Azure Certified Administrator

Oracle Cloud Infrastructure 2018 Certified Architect Associate.

Oracle Cloud Infrastructure Classic 2018 Certified Architect Associate.

Oracle Database Cloud Administrator Certified Professional.

Oracle Database Cloud Service Operations Certified Associate.

Search This Blog

Tuesday, February 14, 2012

FRM-40735: ON-ERROR Trigger raised unhandled exception ORA-01001

Issue: click on any form in the apps env and users were getting the below message.

Followed by:

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.

Changes implemented:

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.

No comments: