close
Welcome! Wikis are websites that everyone can build together. It's easy!

Location: Database

Discussion: Best Practices for troubleshooting ORA-01591,ORA-02049 errors

Keyword tags: 10g 11g 7 8 8i 9i database sql

Watch

Anonymous  (Get credit for your thread)
Airborne_Ranger
Airborne_Ranger		 Best Practices for troubleshooting ORA-01591,ORA-02049 errors
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. 1  out of 2 found this valuable. Do you?    
chemacomes

chemacomes		 RE: Best Practices for troubleshooting ORA-01591,ORA-02049 errors
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 4 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.)
Certs Good Luck ideas for utilizing Real Application Testing
Oracle Roles and Privileges Why are there so few Oracle Certs? Certs should be considered carefully
Take 11g Cert Test Would Oracle consider specialty certs? Starting XE Database after bootup
Unconference: How to use native database REST Web Services in Oracle 11g Editions Why can't we build wiki's on Oracle.