• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2451
  • Last Modified:

Error ORA-14450: attempt to access a transactional temp table already in use

I get the following error code in the application log

ORA-14450: attempt to access a transactional temp table already in use


this application runs on Weblogic App servers in a cluster of 6 maanged servers on 6 physical servers, but this error is seen just on the two managed server app logs
0
cha513
Asked:
cha513
1 Solution
 
rajesh_balaCommented:
Well, looks like this is a classic ORACLE error and the fix is to reconnect the oracle connection.

http://www.dbasupport.com/forums/archive/index.php/t-58263.html

Do you have physical reconnect timeout in your JDBC/Datastore. There has to be an option wherein the connection would automatically close physically and a new connection would be restored in the JDBC pool. May be you can explore that option and set it to a lower value to check if this error is happening still (lowering the value means, the connection would be closed refreshed physically soon)

~Rajesh.B


0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now