Location: Database

Discussion: Best Practices for troubleshooting ORA-01591,ORA-02049 errorsReported This is a featured thread

Category: Discussion Forum / General Discussion
Showing 2 posts
Airborne_Ranger
Airborne_Ranger
Best Practices for troubleshooting ORA-01591,ORA-02049 errors
Mar 21 2008, 3:22 PM EDT | Post edited: Mar 21 2008, 3:22 PM EDT
The error description seem to indicate that at least the deadlock error is the result of a frozen two-phase commit. I get this error message when trying to run these transactions through WLS 8.1SP5 with JDBC connection pools set up and pointing to a single Oracle DBMS 9.2.1 instance. I'm not sure if the origin of the problem is the Oracle init or WebLogic JDBC Connection Pool settings or both.

Any help would be great. 4  out of 5 found this valuable. Do you?    
Keyword tags: 10g 11g 7 8 8i 9i database sql

chemacomes
1. RE: Best Practices for troubleshooting ORA-01591,ORA-02049 errors
May 13 2008, 9:07 AM EDT | Post edited: May 13 2008, 9:07 AM EDT
"The error description seem to indicate that at least the deadlock error is the result of a frozen two-phase commit. I get this error message when trying to run these transactions through WLS 8.1SP5 with JDBC connection pools set up and pointing to a single Oracle DBMS 9.2.1 instance. I'm not sure if the origin of the problem is the Oracle init or WebLogic JDBC Connection Pool settings or both.

Any help would be great."
You can see a description & action for this error in:

http://www.wikioracle.es/doku.php?id=errores_oracle:oracle_9i:ora:ora-01591

regards 0  out of 9 found this valuable. Do you?    

Related Content

  (what's this?Related ContentThanks to keyword tags, links to related pages and threads are added to the bottom of your pages. Up to 15 links are shown, determined by matching tags and by how recently the content was updated; keeping the most current at the top. Share your feedback on Wetpaint Central.)
SQLPro Is there a concept of SQL that uses Genetic algorithms? Database
I am seeking for a new contract Download Oracle 9i database OLAP option - DBA Sample Scripts
Call for Papers 2010 Conference New Zealand Oracle Users Group Virtual Columns
Index Of Oracle SQL Commands unconference: What's New in Eleven Dot Two Why can't we build wiki's on Oracle.