Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

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

Posted on 2009-04-30
2
Medium Priority
?
2,315 Views
Last Modified: 2013-12-10
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
Comment
Question by:cha513
1 Comment
 
LVL 10

Accepted Solution

by:
rajesh_bala earned 2000 total points
ID: 24289364
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

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Upgrading Tomcat – There are a couple of methods to upgrade Tomcat is to use The Apache Installer is to download and unzip and run the services.bat remove|install Tomcat6 Because of the App that we are working with, we can only use Tomcat 6.…
There are numerous questions about how to setup an IBM HTTP Server to be administered from WebSphere Application Server administrative console. I do hope this article will wrap things up and become a reference for this task. You need three things…
Integration Management Part 2
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…
Suggested Courses

581 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question