Support Article
Derived Values abort sporadically
SA-44464
Summary
Derived Value aborts every second or third time it is executed in the online mode.
Error Messages
Oracle error -12592
ORACLE ERROR = ORA-12592: TNS:bad packet
Oracle error -3114
ORACLE ERROR = ORA-03114: not connected to ORACLE
Steps to Reproduce
Run a Derived Value in the online mode.
Root Cause
Oracle bug caused the CMD application server to disconnect from database server repeatedly.
Resolution
-
Apply Patch 18841764 available for Oracle version 11.2.0.4.
- Increase the SQLNET.SEND_TIMEOUT value in sqlnet.ora file at database end as a workaround until the patch can be applied.
Published November 2, 2017 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.