Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

Session fails intermittently with "ORA-12801: error signaled in parallel query server P01F, instance gbexe26db02vcn2:oltt226n2 (2)"
Problem Description
Session fails intermittently with the following Oracle error:

ORA-12801: error signaled in parallel query server P01F, instance gbexe26db02vcn2:oltt226n2 (2) 
Cause
Solution
This is a general error reported by Oracle server when more than one queries are requested to the server and it is not able to process them, may be due to resource issues on the Oracle server or some other issues at the database. DBA should check this further.

This error is often accompanied by another error message. ORA-12801 error sometimes has been seen intermittently for no apparent reason, usually when the server is especially active, and it's always the second error message which is the main cause of the issue.
ORA-12801 is somewhat generic and user should look for more details in DB alert.log.
More Information
Applies To
Product: PowerCenter
Problem Type:
User Type:
Project Phase:
Product Version: PowerCenter
Database:
Operating System:
Other Software:

Reference
Attachments
Last Modified Date:1/9/2019 7:48 AMID:534091
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)