ORA-00068: invalid value 0 for parameter _query_execution_time_limit, must be between 1952541791 and 6252643

Problem Description:

Users were seeing below error in application servers

03/05/2018 06:01:43 AM : 0 : ClaimVersionDao : 0 : 2 : Generic TPS Error. Check system application log for additional details. ADOException exception (could not execute query

[ SELECT distinct IC_CLAIM_ID
FROM claim_version
WHERE 1=1
AND CLAIM_ID = :p0 ]
Name:claimId – Value:20149913944300
[SQL: SELECT distinct IC_CLAIM_ID
FROM claim_version
WHERE 1=1
AND CLAIM_ID = :p0] : ORA-00068: invalid value 0 for parameter _query_execution_time_limit, must be between 1952541791 and 6252643)
03/05/2018 06:01:43 AM : 0 :  :  :  : An error occurred — attempting to run the last workflow step.

Troubleshooting and Solution:

Reviewing the alert log and patch details for 12.1.0.2 database involved, proved that we applied the patches when Database was up and running. This seems to be the cause of this issue and
thus restart fixed the issue. Also the messages for “_disable_image_check” started as soon as we finished the patching when databases in live. Instances need to be down when one-off
are applied. If in case one-off is applied while instance is up, a restart should fix the issue created by that. In this case looks like restart is done.
So no more action seems needed now. And root cause of the issue is patch 27589110 was accidentally applied when instances were running.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: